Cinchy Event Broker/CDC

Cinchy Change Data Capture Notifications

1. Basic Parameters

Parameter
Value
runQuery
Optional. If true, executes a saved query, using the Cinchy ID of the changed record as a parameter. These query results are then used as the sync source, rather than using the Cinchy table where the data change originated.

2. Listener Config

3. XML Example

<?xml version="1.0" encoding="utf-16"?>
<BatchDataSyncConfig name="CDC Sync Cinchy Table into Cinchy Table1" version="1.0.0" xmlns="http://www.cinchy.co">
<CinchyEventBrokerDataSource runQuery="false">
<Schema>
<Column name="Name" dataType="Text" trimWhitespace="true" isMandatory="false" validateData="false"/>
<Column name="Age" dataType="Number" isMandatory="false" validateData="false"/>
<Column name="Date" dataType="Date" isMandatory="false" validateData="false"/>
<Column name="Choice" dataType="Text" isMandatory="false" validateData="false"/>
<Column name="Bool" dataType="Bool" isMandatory="false" validateData="false"/>
<Column name="Link" dataType="Bool" isMandatory="false" validateData="false"/>
</Schema>
</CinchyEventBrokerDataSource>
<CinchyTableTarget reconcileData="true" domain="CLI" table="CDCTarget1" suppressDuplicateErrors="false">
<ColumnMappings>
<ColumnMapping sourceColumn="Name" targetColumn="Name"/>
<ColumnMapping sourceColumn="Age" targetColumn="Age"/>
<ColumnMapping sourceColumn="Date" targetColumn="Date"/>
<ColumnMapping sourceColumn="Bool" targetColumn="Bool"/>
<ColumnMapping sourceColumn="Choice" targetColumn="Choice"/>
<ColumnMapping sourceColumn="[Link].[Description]" targetColumn="Link1" />
</ColumnMappings>
<PostSyncScripts/>
<SyncKey>
<SyncKeyColumnReference name="Name"/>
</SyncKey>
<NewRecordBehaviour type="INSERT"/>
<DroppedRecordBehaviour type="DELETE"/>
<ChangedRecordBehaviour type="UPDATE"/>
</CinchyTableTarget>
</BatchDataSyncConfig>