Guide4 min read

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.

Auke Westra

By Auke Westra

Founder of DigiData

Practical guide. This article covers the steps, checks, and common issues. View the Exact Online product page for supported data, operation and availability.

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.

TestExpectedIf 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

Auke Westra

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 us

Related articles