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.