The Data Export Service for Dynamics 365 is a relatively new solution introduced for the purpose of replicating data from Dynamics 365 to a publicly accessible SQL server. The integration is a point and click solution that does not require any code. The replication is useful for data analytics, business intelligence reporting, machine learning, and intensive read operations.
In this recipe, we will replicate the account entity from Dynamics 365 to an SQL PaaS database on Azure.
Other than installing the Data Export Service for Dynamics 365 as described in the previous recipe, there are quite a few prerequisites required to get the solution up and running: