Dataddo Simplicate connector enables simple API data extraction without writing a single line of code.
Dataddo Simplicate connector can extract all the data available through the official API. You can find the full list of available data here
Obtaining API Key and API Secret
From your Simplicate account, go to "Setting" in the left-hand corner of your account after signing in. From the "Account" menu, choose "API."
Copy the given "API Main" and "API Secret" keys.
Obtaining the Subdomain
Login to your Simplicate account and look at the URL in your browser to locate your subdomain. Your subdomain should look something like this https://example.simplicate.com
Creating a Simplicate Data Source
To create a Simplicate data source, navigate to Sources at the top left of the Dataddo app.
Then click on New Source in the top right corner.
From the list of connectors, choose the Simplicate connector.
You will be redirected into the Simplicate connector where you can select the required Dataset.
If you are not sure which Dataset you need, but you, for example, know which metrics and attributes you are looking for, you can use the Search for Dataset function on the left or you can browse through all the possible attributes and metrics for each Dataset by clicking on the right arrow.
Missing metric or attribute?
Once you select a Dataset, you can start with the configuration by clicking on Next. First of all, you will need to give Dataddo authorization to connect with your Simplicate account. Once you click on Authorize, you will be redirected to your account to log in.
After you log in and give Dataddo the necessary permissions to access your data, you will get redirected back to the connector. If you happen to have more Simplicate accounts connected to Dataddo, you can select the one you would like to use from the drop-down menu.
Next, you can name your data source, and select the required attributes.
The last step consists of selecting your snapshotting preferences. To help you with the snapshot mapping, we make it easier for you to create a connection based on your destination.
- Click on the option "Dashboarding App" if you want your data to connect to applications, like Google Data Studio, Power BI, or Tableau.
- Click on the option "Data Warehouse", If you want your data to be sent to warehouse storage, like MySQL, Big Query, or PostgreSQL.
- If you are already experienced with the snapshotting setup, you can go ahead and process without selecting any of the two options.
Now you are all set and ready. Click on See Preview to review all the selections made by you before saving the Data Source using the buttons in the top right corner - either Save and Exit or Save & Create Flow. To create a flow, please follow our Creating a data flow guide.