There is a very nice new source connector for Dynamics F & O that allows you to bypass the Synapse Link / CDMUtil hassle involved with extracting Dynamics 365 F & O data. Additionally this virtualises the extraction, meaning you no longer need to make a redundant copy of the data involved.
At the moment, this requires a Fabric Ingest + Prepare setup which has some performance and functionality drawbacks. There are two improvements that could be made to allow more implementations to make use of this great provider:
- make it so that other types of prepare can also load through the virtual Onelake Ingest. This way you could add a separate OneLake Ingest or switch over and still be able to use Azure SQL or Snowflake or other Prepare variants.
- make it so that it is possible to build a data movement from Prepare to Prepare. This way, you could set up a separate Ingest + Prepare backed by Fabric capacity to extract and transform D365 F&O data and move the results to your “master” Prepare instance in, for example, Snowflake. The current “reuse existing objects” functionality does not work for this kind of situation.
Apart from D365 F & O, I would expect Business Central to also be able to benefit from a similar approach at some point.
