Skip to content

CRM 2015 Data Change Tracking Facilitates System Integration

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

 

 

No comment yet, add your voice below!


Add a Comment

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