Exact Online

The Dataddo Exact Online connector offers simple API data extraction without writing a single line of code.

Automatic Data Synchronization

Our Exact Online connector gives you the ability to sync your data automatically in hourly, daily, weekly, or monthly increments.

Available endpoints

All available endpoints from Salesforce are listed here.

Authorization issues with .be, .fr, .co.uk accounts

By default, the Exact Online connector is pointed to .nl version. So in case you did not authorize the connection to Exact Online yet, you will be redirected to an authorizer requesting .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.

How to create a Google Ads Data Source

To create an Exact Online data source, navigate to Sources at the top left of the Dataddo app.

   
Number 1

Sign in to your Dataddo account and click on Sources at the top of the page. Home Page - Data Source

Number 2

Click on Create Source in the top right corner.Data Sources - Create Source

Number 3 From the list of sources, choose Exact Online. You can type name of the connector into the search bar to find it faster.
Exact Online - step 3
Number 4 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.
Exact Online - step 4
Number 5 From the drop-down menu, choose your Exact Online Account connected to Dataddo, and then select Country and Division. Click on Next to continue with the setup. Exact Online - step 5
a) Add new account
If you want to connect a new Exact Online that is not on the list, click on Add Account. You will be redirected to the Exact Online Sign In page to confirm the right account. Once you confirm, you will be redirected back to the Dataddo app.
Exact Online - step 5 add new account
Exact Online - step 5 sign in
b) Authorize Your Account
If you have not authorized your Exact Online Account with Dataddo, click on Authorize and you will be redirected to your account to log in.
Exact Online - step 5 authorize
After you log in and give Dataddo the necessary permissions to access your data, you will be redirected back to the connector.
Number 6

Choose a Name for your Data Source and select the Metrics and Attributes. To continue to the next page, click Next.

NOTE: The Metrics and Attributes depend on the Dataset you selected in the previous step. If you need different Metrics and Attributes, go back two steps and change the Dataset.

Exact Online - step 6

Number 7

On the Storage selection page, you can set up the destination configuration. To help you with the snapshot mapping, we make it easier for you to create a connection to the destination based on your preference.

  • A) Click on the option Dashboarding App if you want your data to connect to applications such as Google Data Studio, Power BI, or Tableau.
  • B) Click on the option Data Warehouse, if you want your data to be sent to warehouse storage, e.g., MySQL, Big Query or PostgreSQL.
Exact Online - step 7
Number 8

Configure your snapshotting preferences by choosing your Data range, Sync type, Snapshotting frequency, Time and Timezone. Confirm your setup by clicking on Next.

NOTE: If you need to load historical data, check our guide.
Exact Online - step 8

Number 9 In the last step you can preview your data. Click on Save and your new Data Source is ready.
Exact Online - step 9 preview
* 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, attribute or breakdowns, or their combination - you may not have any values for them.
Exact Online - step 9 broken view

Congratulations, your new Data Source is ready!


Need assistance?

Feel free to contact us or create a ticket and we will help you setup the Data Source.