Change data capture
I like to implement a cdc between dynamic crm and sql server. pl. let me know if it possible ?How I can implement it.
Your answer has 2 parts:
1. Net Change
If you use Net Change, the second and subsequent time the map is run it will only select records that have been changed since the last time it was run. Scribe stores the last run time in the cloud and uses it as part of the query.
select ... where LastModifiedDate > LastRunTime
2. Selecting relevant columns
In the main query block, Scribe Online automatically selects the relevant columns that are used in the map. This happens under the hood and you don't need to do anything. if you used 10 out of 30 total columns in the map, the main query would only select those 10 columns. In a Lookup block, you specify which columns are returned in the query.
I recommend getting a trial and creating some maps.
There are a few ways to implement this, depending on your requirements. Due to the way CRM tracks changes, it may be challenging to get field level changes.
The most simple solution is to implement a Pull method using a Scribe online Integration Service map. Source connection is CRM and the target is SQL with the same record schema. Use Net Change triggered on the lastmodifiedon field. Configure the Scribe solution to run on a schedule and replicate all fields. This will capture the current state of the record, which can be compared to previous states with the lastmodifiedon date.
For a Push method, do the same with a Web Hook that sends the Record GUID.
Downside is that it stores all fields every change and takes a lot of storage.
For field level changes (using a push method), create a CRM solution that triggers a web hook on every field change. Sent it to a Scribe Event map. Store in a log type table in SQL that has the field name / and new value as a key / value pair.
The main limitation is that CRM uses a single field (lastmodifiedon) to track all change to any field. Tracking a subset of fields in CRM for the Change Data Capture will require a custom CRM solution. A method would be to add another last modified date field to use for the fields you want to track,
Hope that helps.