Forum Discussion

tejaswib's avatar
tejaswib
Frequent Visitor
2 years ago
Solved

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. 

2 Replies

  • christinepayton's avatar
    christinepayton
    Icon for Most Valuable Professional rankMost 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. 

    • tejaswib's avatar
      tejaswib
      Frequent Visitor

      Thanks for your reply.