Has anyone used Pyramid with Dynamics (D365 - FinOps and CE) ?
One of my clients uses Microsoft Dynamics as its core systems - both D365 FO (Fin Ops) and CE (Customer Engagement).
In trying to design a DWH / BI solution for them I'm discovering how hard Microsoft make it to get data out of these cloud products - there have been a number of different MS connectors which have been introduced and retired in the last few years.
Has anyone any experience or advice (@ian_macdonald) - particularly about using Pyramid to extract the data from these products into a separate data warehouse solution?
All advice very welcome, thanks in advance.
Regards,
Richard.
2 replies
-
Hi
I would look at CData's connectors to get the ability to extract the data from MS Dynamics
https://www.cdata.com/drivers/dynamics365/jdbc/
This can then be added as a custom connector in the admin tool,
thanks
Mark