Polling Event Example Config
1. XML Example
This example XML uses the following values:
1.1 Blank XML Example
<BatchDataSyncConfig name="Data Polling" version="1.0.0" xmlns="http://www.cinchy.co">
<PollingEventBrokerDataSource>
<Schema>
<Column name="" dataType="" isMandatory="" validateData=""/>
<Column name="" dataType="" isMandatory="" validateData=""/>
</Schema>
</PollingEventBrokerDataSource>
1.2 Populated XML Example
<?xml version="1.0" encoding="utf-16"?>
<BatchDataSyncConfig name="Data Polling" version="1.0.0" xmlns="http://www.cinchy.co">
<PollingEventBrokerDataSource>
<Schema>
<Column name="ID" dataType="Number" isMandatory="false" validateData="false"/>
<Column name="NAME" dataType="Text" isMandatory="false" validateData="false"/>
<Column name="AGE" dataType="Number" isMandatory="false" validateData="false"/>
<Column name="ADDRESS" dataType="Text" isMandatory="false" validateData="false"/>
<Column name="SALARY" dataType="Number" isMandatory="false" validateData="false"/>
</Schema>
</PollingEventBrokerDataSource>
1.3 Example with Destination
<?xml version="1.0" encoding="UTF-16"?>
<BatchDataSyncConfig xmlns="http://www.cinchy.co" name="Data Polling" version="1.0.0">
<PollingEventBrokerDataSource>
<Schema>
<Column name="ID" dataType="Number" isMandatory="false" validateData="false" />
<Column name="NAME" dataType="Text" isMandatory="false" validateData="false" />
<Column name="AGE" dataType="Number" isMandatory="false" validateData="false" />
<Column name="ADDRESS" dataType="Text" isMandatory="false" validateData="false" />
<Column name="SALARY" dataType="Number" isMandatory="false" validateData="false" />
</Schema>
</PollingEventBrokerDataSource>
<CinchyTableTarget reconcileData="true" domain="Automation" table="Customer1" suppressDuplicateErrors="true">
<ColumnMappings>
<ColumnMapping sourceColumn="ID" targetColumn="Id" />
<ColumnMapping sourceColumn="NAME" targetColumn="Name" />
<ColumnMapping sourceColumn="AGE" targetColumn="Age" />
<ColumnMapping sourceColumn="ADDRESS" targetColumn="Address" />
<ColumnMapping sourceColumn="SALARY" targetColumn="Salary" />
</ColumnMappings>
<SyncKey>
<SyncKeyColumnReference name="Id" />
</SyncKey>
<NewRecordBehaviour type="INSERT" />
<DroppedRecordBehaviour type="DELETE" />
<ChangedRecordBehaviour type="UPDATE" />
<PostSyncScripts />
</CinchyTableTarget>
</BatchDataSyncConfig>
2. Connections UI Example
This example shows you how to set up a polling event source using the Connections UI.
2.1 Schema
Our column parameters are set as follows:
