Hi friends! I’m looking for architectural guidance to determine if the Dataverse should be used as our ODS or if we should stick with Azure SQL DB. We are using Dynamics 365 Business Central and Salesforce and a few supply-chain applications running on Azure VMs that generate invoices. We also are developing Power Apps to manage price negotiations that none of the other applications can do correctly.
So far, we have been using Azure SQL DB for point-to-point bi-direction synchronization between each of our applications and this has involved heavy use of Azure Data Factory. Rather than point-to-point we’d rather use a hub-and-spoke design with an ODS in the middle, and also use it for Power BI reporting.
Is the Dataverse and the Common Data Model the best way to go? It seems designed to be an SaaS hub between SaaS applications.
Importing data into BC is an issue. I discovered so far that DV can create virtual BC tables which can serve as a backdoor to updating BC. I also discovered DV virtual tables cannot be used as a source for DV Data Export to SQL destinations. So I’m slowly working through my proof-of-concept now trying to tie DV CDM tables bi-directionally to BC, SF, etc.
Got any advice or suggestions?
