Every database has a story. Data Analyst knows them all.
It maps your company's databases, even across different servers and technologies, and learns what each one is for. Then it answers your questions with real data and a chart built on the spot.
4 serversSQL Server · AS400 · PostgreSQL · MySQLIllustrative example
Illustrative example. To answer the question, Data Analyst starts from the CRM on SQL Server, where it finds customers and sales areas; it follows the CodCliente = CLICOD relation to the ERP on AS400, which holds invoices and open orders; then the cliente = CLICOD relation to the B2B portal on PostgreSQL, for online orders. The warehouse database on MySQL isn't needed for this question. Answer: North-West, open orders equal 38% of the half-year's revenue; North-East, 21%.
Different servers, different technologies: one question.
The CRM on SQL Server, the ERP on AS400, the portal on PostgreSQL, the warehouse on MySQL. In a company, data lives where history put it, not where it would be convenient. Data Analyst doesn't ask you to move it or merge it: it connects to each one where it is.
Data Analyst
One question
- T-SQL
SQL Server
Relational
- DB2 for i
AS400 · IBM i
Legacy business system
- PL/SQL
Oracle
Relational
- SQL
PostgreSQL
Relational
- SQL
MySQL
Relational
- MQL
MongoDB
Document NoSQL
And more
MariaDB and beyond. If your system isn't listed, get in touch.
Data Analyst connects to each database in its own language: SQL Server (T-SQL), AS400 · IBM i (DB2 for i), Oracle (PL/SQL), PostgreSQL (SQL), MySQL and MariaDB (SQL), MongoDB (document NoSQL, MQL), and more.
Before it answers, it surveys the ground.
Data Analyst connects to the servers you point it at and draws their map: tables, fields, relations. Then it notes what each database is for, so when a question comes in it already knows where to look.
- Where it starts
- From the servers you choose, with the credentials you give it. SQL Server, PostgreSQL, MySQL, AS400: even when they sit on different machines and nobody ever connected them.
One sheet per database
Tables and fields read from the database structure, server by server.
- A = B
Relations across systems
It finds the fields that match even across different databases, like the customer code in the CRM and in the ERP.
- why
Why each database exists
It notes what each one is for: where customers live, where invoicing happens, where online orders arrive.
The path of a question
When you ask something, it picks the databases it needs, follows the relations and leaves the rest alone.
Ask the way you'd ask a colleague.
No SQL, no report to book. Write the question in plain language: Data Analyst works out which databases to query and how to bring them together.
Which customers have orders open for more than a month? Show me the value by area.
CRMERP
How much has the North-East area ordered through the portal, month by month?
CRMB2B portal
Which low-stock items are ordered most online?
B2B portalWarehouse
How did first-half revenue compare with last year, area by area?
CRMERP
Illustrative examples
Same question, an answer fitted to who's asking.
Data Analyst answers only with the data the person asking is allowed to see. The filter comes from their profile, not from how the question is worded.
Switch profile: the question stays the same, the answer stops where the permissions stop.
How much are open orders worth by area, compared with revenue over the last six months?
North-West: open orders equal 38% of the half-year's revenue. The other areas are outside your profile.
Revenue, 6 monthsOpen orders
Illustrative example
Stop chasing the data that never made it into a dashboard.
Dashboards answer the questions someone thought of in advance. The rest turned into a request to IT and a wait. With Data Analyst, a new question gets its answer from the real data, with the chart it needs.
Data Analyst is part of AgentsLet's bring Data Analyst to your databases.
Tell us which systems you use: we'll show you how it maps them and how it answers your team's questions.
- [email protected]
- Office
- Corso Vercelli 89, 28100 Novara