Copernica

The Dataddo Copernica connector enables simple API data extraction without writing a single line of code.

Automatic Data Synchronization

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

Available Endpoints

All available endpoints from the Copernica API are listed here:

https://www.copernica.com/en/documentation/restv2/rest-api

Creating a Copernica Data Source

To create a Copernica data source, navigate to Sources at the top left of the Dataddo app.

Top Bar Marked-png-1

Then click on New Sources from the top right corner.

Source Selection Page-png-1

From the list of connectors, choose the Copernica connector.

Searching for copernica

You will be redirected into the Copernica connector where you can select the required Dataset.

Dataset1-copernica

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 on the right side of the window. The picture below shows all datasets containing the attribute Device.

Dataset2-copernica

Alternatively, you can browse through all of the possible attributes for each Dataset by clicking on the Show attributes button on the right side of each dataset.

Dataset3-copernica

Once you select a Dataset, you can start with the configuration by clicking on Start Configuration. First of all, you will need to give Dataddo authorization to connect with your Copernica account. 

configure account

Once you click on Authorize, you will be redirected to a new window in order to sign in with your Copernica account. If you happen to have any Copernica accounts already connected to Dataddo, you can select the one you would like to use from the drop-down menu. 

Selection of an account copernica

Next, you can name your data source, and select the required attributes.

Selecting metrics and attributes copernica

On the snapshotting page, you will set up the destination configuration. To help you with the snapshot mapping, you can select from two pre-configured templates depending on your planned 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 move on without selecting the two options.

snapshotting options

Lastly, you configure your snapshotting preferences, choosing Date range (if available), Snapshotting frequency, and Snapshotting retention. 

snapshotting configuration

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 button in the top right corner Save source.

Preview copernica

Your new source is now created. You can click on Add source to a flow to bind the source with a flow. To create a flow, please follow our Creating a data flow guide.

FAQ

  • No data?

 

                 

Do not worry, this is a common issue that occurs to many users. Quick ways to fix this issue:

  1. Your account might not have any records for the dates you specified. Try changing the date range to a different date or a longer period (last 30 days, this year) to obtain data.
  2. You could have made a slight mistake when configuring your account, but it's ok. You can restart the process of configuration again and check the connector configuration. You can also try to use a different account or a different combination of metrics.

  • Problem Connecting?

                  

If you get the 'Something went wrong' message, please make sure that your account has sufficient permissions and the configuration looks correct. If these issues are still persistent. You can contact us or create a ticket and we will address it as soon as possible.

 

  • How to deactivate the Dataddo account?

Screenshot 2021-01-08 at 14.52.22

Check whether your account has the correct permissions to access this dataset. Navigate to Settings > Connected accounts. If your account is OK, click on Test. If your account is broken, click on re-authorize

  • Want to deactivate your account?

If you want to deactivate your Dataddo account, you can contact us or create a ticket and we will handle it as soon as possible.