Skip to content
CRM 2015 Data Change Tracking

CRM 2015 Data Change Tracking Facilitates System Integration

A new feature is available in CRM 2015 Update 1 (for CRM Online) to track changes in CRM between “RetrieveEntityChangesRequest” calls.

There are many ways to synchronize data to / from Microsoft Dynamics CRM and other systems.  Scribe Message Queues utilize MSMQ technology, and get the job done quickly and efficiently.  A query can be run against the CRM database to identify changes or Scribe provides a “Publisher” feature that will handle this part of the job and send messages into the queue to sync with other systems.  A typical concept is to look at “Last Date Updated” of the table to know when you last queried the database; then next time you’re just looking for what changes since last time you queried.

Microsoft Dynamics CRM Online (CRM 2015 version) with Update 1 now has a feature that allows something very similar to be done via the SDK web service.  We can look at any entity and query the data to sync with an external system; and then next time we query the data, we’ll have a “version” number that will be used to identify only what changes have happened since the last retrieval method was run.

The feature first needs to be activated at the entity level.  Then the first time the RetrieveEntityChangesRequest is called, all records will be pulled.  A “version number” is then used to communicate which records in the CRM data have changed since the last RetrieveEntityChangesRequest.

Sample code can be found in this msdn article: CRM 2015 Data Change Tracking Facilitates System Integration

More detailed sample code can be found here: https://code.msdn.microsoft.com/Synchronize-data-with-5ac80d47

 

 

Related Posts

KingswaySoft SSIS D365 CDS Connector

Dynamics 365 Application User Setup for KingswaySoft SSIS

In order to connect the KingswaySoft Dynamics 365 SSIS Connector to your CRM system, you will need to use an Application User, otherwise known as server-to-server authentication. This video demo shows how to setup the KingswaySoft Dynamics 365 CDS connector to connect to Dynamics 365 CRM (online) with an Application Registration setup in Azure Active Directory.

Read More »

Drop us a note

Please drop us a note via the form below with your comments or questions on this blog post; or if there is anything we can help you with.