Exact Online

How to Create an Exact Online Data Source

1. Sign in to your Dataddo account and go to Authorizers. Click on Authorize New Service and from the list, choose Exact Online's language version you want to connect.

2. Go to Sources on the top navigation panel and click on Create Source in the top right corner From the list of sources, choose Exact Online.

3. First, select the required Dataset and click on Next.

   NOTE

   If you are not sure which Dataset you need, but you know which Metrics and Attributes you are looking for, you can use the Search by name or attribute function or you can browse through all the possible Attributes and Metrics for each Dataset by clicking on the specific Dataset.

   

4. From the drop-down menu, choose the Exact Online Account you connected to Dataddo, and then select Country and Division. Click on Next to continue with the setup.

5. Choose a Name for your data source, and select the Metrics and Attributes. Click on Next to continue.
   

   NOTE

   If you need different metrics and attributes, go back two steps and change the dataset. Metrics and attributes both depend on the selected dataset

6. Configure your snapshotting preferences by choosing your Sync frequency. Under Advanced settings you can select the exact Time of synchronization. Confirm your setup by clicking on Next.
   If you need to load historical data, please refer to our guide.

7. Before saving the source, preview your data by clicking on the Test Data button. Adjust the date range to see a more specific range of data.
   

8. Click on Save and congratulations, your new data source is ready!

Available Endpoints

All available endpoints from Exact Online are listed here.

Troubleshooting

Broken View / Error Message

If you cannot see a preview of your data, go back a few steps and check your setup. The most common causes are:

• Date range: We recommend a smaller date range. If you need to load historical data, check our guide.
• Invalid metrics, attributes, or breakdowns: You may not have any data for the selected metrics, attributes, or breakdowns.
• Combination of metrics, attributes, or breakdowns: The combination you have selected cannot be queried together. Please refer to the service's documentation to view a full list of which metrics can be included in the same source.
  

Authorization Issues with .be, .fr, .co, .uk Accounts

By default, the Dataddo Exact Online connector is pointed to the .nl version. So in case you did not authorize the connection to Exact Online yet, you will be redirected to an authorizer requesting the .nl version.

In case you have BE, FR, or UK version of Exact Online, navigate to Settings -> Connected Accounts and select the correct national version of Exact Online. Then proceed to the Exact Online connector in the Dataddo app.

You can read about how to reauthorize a service here.