Using the Data Export Service solution for data replication

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.

Note

The Dynamics 365 Data Export Service is a free of charge add-on.

In this recipe, we will replicate the account entity from Dynamics 365 to an SQL PaaS database on Azure.

Getting ready

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:

Office \ Azure tenancy

You must have your Office 365 tenancy associated with your Azure tenancy, as the Data Export Service for Microsoft Dynamics 365 enterprise application residing within that tenancy...