Creating, Deleting and Updating Records in the Data Export Service for Dynamics 365

Leave a comment

The Data Export Service for Common Data Service apps such as Dynamics 365 is used to copy data from the cloud-based Dynamics 365 data store to an Azure SQL Server database.

Let’s look at some synchronization examples. First, let’s connect to our Azure SQL database and search our accounts for an account where the name is TEST. We can see it does not exist:

Now, in the Dynamics 365 org, enter an account called TEST and save:

Refresh the data. You will see the account has been created.

Note, Microsoft has stated under certain conditions, “15 minutes is a typical synchronization latency. Microsoft provides no service level agreement (SLA) for the Data Export Service and makes no guarantees or commitments regarding synchronization latency times”:

Update the account:

In SQL, we see the updated account:

Delete the account, and it will be removed from the SQL database:

Browsing out to Settings->Data Export, you can see when the synchronization has last run and any issues:

 

ABOUT CARL DE SOUZA

Carl de Souza is a developer and architect focusing on Microsoft Dynamics 365, Power BI, Azure, and AI.

carldesouza.comLinkedIn Twitter | YouTube

 

Leave a Reply

Your email address will not be published. Required fields are marked *