Forum Discussion
How to integrate Paylocity and Ceipal data
How to integrate Paylocity and Ceipal data with Power BI Desktop?
What is the best approach to get the data with both the systems?
Can anyone please help me with the solution.
Thank You
Tejaswi
There's not a connector for those, so you would need a data integrations person to set up ETL to copy the data into a supported source (like SQL). There's a slew of tools to do this; some have connectors built in for specific sources to make it easier for you. You can connect directly to APIs in PBI, but it is better to store the data in a database.
Thanks for your reply.
2 Replies
- christinepayton
Most Valuable Professional
There's not a connector for those, so you would need a data integrations person to set up ETL to copy the data into a supported source (like SQL). There's a slew of tools to do this; some have connectors built in for specific sources to make it easier for you. You can connect directly to APIs in PBI, but it is better to store the data in a database.
- tejaswibFrequent Visitor
Thanks for your reply.