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 Tej...
Need Help
  • christinepayton's avatar
    christinepayton
    2 years ago

    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
    2 years ago

    Thanks for your reply.

christinepayton's avatar
christinepayton
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

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
    2 years ago

    Thanks for your reply.