AI on ERP data

Ask your ERP data what you want to know. No exports, no SQL.

With AI on ERP data, you ask questions about revenue, orders, stock or receivables in plain language. ENABLE works with the ERP data in your own PostgreSQL data warehouse: the AI writes a query, ENABLE runs it read-only and you see the result with the query alongside it. The AI only sees table and column names, never rows.

Book a demo Explore the platform

enable.dataanalytics.nl/acme

EnglishClient adminSV

SQL Explorer

SQLDAX

What was revenue per region this quarter, compared with last year? Generate SQL

acme_warehouse Query plan: read-only Run

1SELECT r.region,
2       SUM(i.revenue) FILTER (WHERE i.year = 2026) AS revenue_2026,
3       SUM(i.revenue) FILTER (WHERE i.year = 2025) AS revenue_2025
4FROM   sales.invoices i
5JOIN   master.region r ON r.region_id = i.region_id
6WHERE  i.quarter = 3
7GROUP BY r.region
8ORDER BY revenue_2026 DESC;

5 rows · 0.21 s CSV · JSON

regionrevenue_2026revenue_2025Δ

South1,421,3001,198,400+18.6%

North1,284,9001,121,700+14.5%

Central1,183,2001,041,000+13.7%

East962,400911,800+5.5%

West881,600852,300+3.4%

Q3 revenue by region

South

North

Central

East

West

AI on ERP data means asking questions about the data in your ERP system, such as sales orders, invoices, stock and purchasing, and getting an answer that comes straight from that data. In ENABLE, this doesn't happen in the ERP itself but on a copy of your ERP data in your own PostgreSQL data warehouse.

A controller at Acme Groothandel, a fictional wholesaler, might type: "Which ten customers had the biggest drop in revenue this year compared with last year?". The AI writes SQL for it based on the table and column names in the warehouse, ENABLE checks the query with a read-only query plan and runs it. You see the result as a table or chart, with the query alongside, so you can check how the figure was arrived at.

Why go through a data warehouse? An ERP is built to record transactions, not to analyse them. In a warehouse you combine ERP data with other sources, you don't burden the ERP with heavy analyses, and the AI never comes anywhere near your accounting records.

Key points

AI on ERP data at a glance

Questions in plain language

Revenue, orders, stock, purchasing or receivables: type your question and the AI writes SQL that fits the tables in your warehouse.

Only real tables and columns

The AI receives the structure of your warehouse (tables, columns, data types and relationships) and is instructed to use only names that actually exist.

Read-only and bounded

Every query runs in a read-only transaction, with a 45-second timeout and a limit on the number of queries per minute.

Query visible and editable

The SQL sits next to every result. If a filter or definition is wrong, you adjust the query or ask the AI to explain it.

From question to dashboard

Save a good question. Whatever keeps coming back becomes a standard Power BI dashboard or a custom dashboard in the Dashboard Builder (pilot).

Targets next to actuals

The Targets app records monthly KPI targets in your own warehouse, so you can put them next to the ERP figures in a query or dashboard.

How AI on ERP data works: from ERP to answer

AI on ERP data in ENABLE consists of four layers. The ERP remains your source for transactions, a loading process copies the data to a PostgreSQL data warehouse, and ENABLE puts your questions to that warehouse, never to the ERP itself.

Layer	What happens	Who handles it
ERP (e.g. Business Central)	Orders, invoices, stock, purchasing	Your own ERP administrators
Loading process	Copying data periodically, for example with Airbyte	Outside ENABLE, for example with help from Data Analytics
PostgreSQL data warehouse	Modelling the data into understandable tables	Per customer; the location varies by customer
ENABLE	Plain-language questions, dashboards, apps, API	The portal, hosted in Frankfurt

Example questions for ERP data at Acme Groothandel

Acme Groothandel is a fictional wholesaler that uses Microsoft Dynamics 365 Business Central as its ERP. This is what a week of questions to its ERP data looks like:

"What was revenue per product group per month this year, compared with last year?"
"Which items are in stock but haven't sold in the last 90 days?"
"Which customers have outstanding invoices older than 60 days, and for what amount?"
"What is the average delivery time per supplier over the last six months?"
"Which sales orders are open and not yet delivered?"

Analysing ERP data with AI: Business Central, Exact Online and AFAS

Whether a question can be answered depends on what is in your warehouse, not on which ERP you use. If the delivery date isn't in the data, the AI can't make it up either. The clearer the table and column names, the better the AI picks the right fields; that is why it pays to model ERP data into understandable tables or views.

Some ERP vendors build AI features into their own software, such as Copilot in Business Central. Those are aimed at the work inside the ERP. ENABLE focuses on analysis: questions about the data in your warehouse, optionally combined with other sources such as your CRM or webshop.

Exact Online and AFAS Profit are business software packages widely used in the Netherlands and Belgium. The same approach applies to them: the data first goes into your warehouse.

ERP	How the data gets into your warehouse	In ENABLE
Microsoft Dynamics 365 Business Central	Load with a tool such as Airbyte, then model	Usable via the warehouse
Exact Online	Via a loading tool or custom integration	Usable via the warehouse, no ready-made connector
AFAS Profit	Via a loading tool or custom integration	Usable via the warehouse, no ready-made connector

AI on ERP data in dashboards and apps

The SQL Explorer is the place for one-off questions. What you want to see more often, you make permanent. In the Dashboard Builder (pilot), "Ask AI" suggests a chart based on the metadata of approved data sources; you apply the suggestion or discard it.

Apps work on the same warehouse too: the built-in Targets app for monthly KPI targets, or an app you have built yourself, such as a (made-up) stock planner that creates an order proposal per item. That way everyone looks at the same figures.

What to watch for with AI on business data from your ERP

The technology is rarely the problem. The difference lies in definitions and access.

Definitions: does revenue include or exclude credit notes and discounts? Record that in a view or saved query.
Freshness: the answers are only as up to date as the latest load of the warehouse.
Access: the SQL Explorer queries the entire warehouse. Give it to people who are allowed to see everything; others work with dashboards that use row-level security.
Privacy: the AI only receives metadata and the question. So don't type personal data into your question.

In ENABLE

How AI on ERP data works in ENABLE

01
Load ERP data into the warehouse
Your ERP data is loaded into a PostgreSQL data warehouse outside ENABLE, for example with Airbyte, and modelled into understandable tables.
02
Connect the warehouse
ENABLE connects to your organisation's warehouse over an encrypted connection and runs read-only queries only.
03
Ask a question
You type a question in the SQL Explorer. The AI receives the table and column names and writes SQL; ENABLE checks it with a read-only query plan.
04
Save, share or make it permanent
View the result as a table or chart, export to CSV, save the query or turn it into a dashboard or API endpoint.

Book a demo How the platform works

FAQ

Frequently asked questions

What is AI on ERP data?

AI on ERP data is AI that answers questions about the data in your ERP system, such as orders, invoices and stock. In ENABLE, the AI writes a SQL query on a copy of your ERP data in your own data warehouse, and ENABLE runs it read-only.

Can I use AI on Business Central data?

Yes, once your Business Central data is in a PostgreSQL data warehouse. Loading happens outside ENABLE, for example with Airbyte. After that, you ask questions about that data in plain language in the SQL Explorer.

Does AI on ERP data also work with Exact Online or AFAS?

Yes, if the data from Exact Online or AFAS Profit is in your data warehouse. ENABLE has no ready-made connector for those packages; loading is done with a loading tool or a custom integration.

Does the AI get to see my ERP data?

No, not the data itself. The AI only receives metadata, such as table and column names, and the user's question. The query runs in your own warehouse and the result is not sent back to the model.

Can the AI change anything in my ERP?

No. ENABLE has no connection to your ERP, only to your data warehouse, and queries run there in a read-only transaction. Posting, changing or deleting is not possible.

How up to date are the answers?

As up to date as the latest load of your data warehouse. How often it is refreshed is set in the loading process outside ENABLE.

Share securely, live fast, no headache

In an online demo we show you the portal: dashboards per role, row-level security, plain-language questions and how we set it up and manage it for you.

Book a demo info@enableyourdata.nl