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.

Discover Agents

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

  • SQL Server

    Relational

    T-SQL
  • AS400 · IBM i

    Legacy business system

    DB2 for i
  • Oracle

    Relational

    PL/SQL
  • PostgreSQL

    Relational

    SQL
  • MySQL

    Relational

    SQL
  • MongoDB

    Document NoSQL

    MQL
  • 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.

North-WestNorth-Eastoutside profileCentreoutside profileSouthoutside 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 Agents

Let'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.

Office
Corso Vercelli 89, 28100 Novara

Your data is treated according to our Privacy Policy and will not be shared with third parties.