In this article, you will learn how to integrate Dataddo in Personio. You will get an overview of the requirements, together with instructions, for setting up the integration with the Personio employee data API.
What is Dataddo?
Dataddo is a data management platform that allows you to connect all of your data to any BI tool and/or data warehouse. The Dataddo-Personio integration will help you elevate your reporting capabilities and ensure all your dashboards are always updated with the latest data.
The Personio connector gives you the ability to sync your data automatically in hourly, daily, weekly, or monthly increments.
How can I set up the Integration Between Dataddo and Personio?
To start the activation in Personio, follow these steps:
- Go to the Marketplace and search for the integration.
- Click on the integration to open the drawer with further details.
- Select Connect to start the activation process.
- Click Generate new API credentials.
- Copy the client ID and secret and click Go to website to finish the setup in the partner's service environment.
Creating a Personio Data Source
To create a Personio data source, navigate to Sources at the top left of the Dataddo app. Click on New Sources from the top right corner.
From the list of connectors, choose the Personio connector.
You will be redirected into the Personio connector where you can select the required Dataset.
After you select a Dataset, you can start the configuration by clicking on Start Configuration. Firstly, you need to give Dataddo authorization to connect with your Personio account.
Once you click on Authorize, you will be redirected to a new window to sign in with your Personio account. If you already have Personio account(s) connected to Dataddo, select the one you would like to use from the drop-down menu.
Name your data source and select the required attributes.
On the snapshotting page, 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:
If you are already experienced with the snapshotting setup, go ahead and move on without selecting the two options.
- Click on the option Dashboarding App if you want your data to connect to applications, such as Google Data Studio, Power BI, or Tableau.
- Click on the option Data Warehouse if you want your data to be sent to warehouse storage, such as MySQL, Big Query, or PostgreSQL.
Configure your snapshotting preferences, choosing Date range (if available), Snapshotting frequency, and Snapshotting retention.
Click on See Preview to review all your selections. To save the Data Source, click on the Save source button in the top right corner.
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 the instructions provided in the Dataddo Creating a data flow guide.
What Data is Transferred?
The data you wish to transfer about Employees, Attendances and Absences is transmitted through Dataddo into your data warehouse or dashboarding tool.
What are the Costs?
The price for the Personio–Dataddo integration is €30 for each Personio dataset (Employees, Attendances, Absences). Contact Dataddo's Sales team for customized pricing.
Who do I Contact at Dataddo?
For Sales inquiries, please contact firstname.lastname@example.org.
For Support, please contact email@example.com.