Link Exact Online to ChatGPT via DigiData MCP
Use selected Exact Online data read-only in ChatGPT via DigiData MCP, with OAuth and explicit permissions for each accessible table and column.
By Auke Westra
Founder of DigiData
Short answer
You connect Exact Online to ChatGPT by first synchronizing Exact Online with DigiData and then authorizing a limited DigiData MCP connection for ChatGPT. ChatGPT does not receive an Exact Online password or OData API key and can only read the selected tables and columns.
Sync first, ask questions later
The Exact Online integration retrieves selected administration data in advance to the protected DigiData environment. ChatGPT does not directly request the Exact Online API for every question. That separates source authentication and synchronization from the interactive conversation.
Via DigiData MCP, ChatGPT only gets access to the dataset that a DigiData administrator designates for that connection. The link is read-only: there are no tools to change bookings, relations, invoices or other source records.
Conditions
You need an active Exact Online link in DigiData, a DigiData administrator and a supported ChatGPT workspace. OpenAI describes MCP apps and developer mode as features whose availability depends on plan, workspace policy, and administrative permissions. Therefore, please check the current ChatGPT MCP manual before you start.
Step 1: check the Exact Online data
Check in DigiData whether the correct administration or division has been linked and the last synchronization was successful. Determine which tables and columns are actually needed. Relationships, invoices, due dates and amounts may be relevant for a debtor analysis; do not automatically release all available Exact Online data.
Step 2: Make the AI connection
Open Settings and choose AI Connections. Select ChatGPT, give the connection a recognizable name and record the source, table and column selection. DigiData shows one fixed MCP server URL.
Add that URL as a custom MCP app according to the current OpenAI steps. ChatGPT then starts the DigiData OAuth flow. Sign in, complete 2FA where required, and review consent before confirming.
Step 3: Test small
First ask what resources are available without retrieving records. Then check the synchronization status of Exact Online and describe the schema of one allowed table. Only then query a small number of selected columns.
Safe starting questions include a grouping by month, the largest outstanding items within a chosen period or a list of available fields for a margin analysis. Always have the assistant mention the table, reference date and applied filters.
Manage access
An administrator can adjust the allow list or revoke the connection. DigiData checks the current status with every tool call, so that an old token is not allowed to continue using a revoked connection. Also remove the app from ChatGPT when the integration is no longer needed.
Privacy and plan conditions
DigiData does not use the questions and company data to train models. Data returned to ChatGPT via MCP is then also covered by the chosen OpenAI plan, workspace settings and contract. Personal and business OpenAI products do not have the same standard terms; let the workspace administrator review that choice.
Alternatives
Exact Online in Power BI via OData remains suitable for dashboards. For recurring analytics with approved definitions and a single DigiData support path, DigiData AI is the recommended route. Compare the routes on DigiData AI vs. ChatGPT or Claude.
If you use Twinfield and Claude, the same approach applies with Twinfield via a read-only MCP server in Claude. To understand how MCP relates to an OData feed first, read OData and MCP: what's the difference? and What is an MCP server for business data?.
Acceptance test for Exact Online and ChatGPT
Test with one administration and period for which finance already knows the outstanding balance. Select only relation ID, invoice number, invoice date, due date, status and amount when those fields are enough. Personal, payroll and free-text fields should not enter the pilot by default.
| Test | Expected | If it fails |
|---|---|---|
| Ask which Exact Online source, synchronization date and fields are available. | ChatGPT names only the selected administration and columns. | Correct a wrong division or missing synchronization in DigiData first. |
| Request the outstanding total and five oldest items in the test period. | The answer states total, currency, filter, reference date and table. | Check credit notes, payment status, date field and division filter before judging the model. |
| Request a forbidden payroll field, then revoke the connection. | The field is denied and normal read access stops after revocation. | Do not release the connection if either boundary fails. |
Provider caveat: Custom MCP app availability depends on the current ChatGPT plan, workspace policy and administrator rights. Recheck those provider conditions after any plan or policy change.
Sources

About Auke Westra
Founder of DigiData
Auke Westra is Founder of DigiData. He was responsible for clients' data and reporting and in 2025 began building an in-house data platform with his team. He writes about AI on business data, data definitions, Power BI and integrations.
Ready to start?
Try DigiData for free for 14 days. Connect your software, load your data into Power BI and discover the difference.
Please contact usRelated articles
Connect Exact Online Power BI via OData
Connect Exact Online to Power BI with this OData setup guide. Choose your data, configure authentication and plan refreshes without writing API scripts.
How to Connect GA4 to Power BI: Worked Example and Data Model via OData
Connect GA4 to Power BI in six steps via OData, then calculate engagement rate with a worked DAX example. Covers report tables, data quality and refresh.
KPI dashboard for SMBs: 12 examples with formulas
See 12 KPIs for a small business dashboard, each with a formula, source and action. Includes free sample data so you can build your own KPI dashboard.
Automate job costing: margin per project without Excel
Automate job costing with connected hours, materials and invoices. See the gap between estimate and actuals for each project while it is still running.