Sync Target

Each sync target will have different set of attributes supported, click desired target.

The sync target contains a Column Mapping object, that contains individual mappings from the source column to target column. This implicitly defines the schema of the target as well (to the extent required). It also contains a Sync Key object (which includes at least 1 sync key column) and the sync record behaviours.

Optionally you can also add a Filter and/or Post Sync Script(s).

<Target>
<ColumnMappings>
<ColumnMapping sourceColumn="Source Column Name" targetColumn="Target Column Name" />
...
</ColumnMappings>
<Filter>filter condition</Filter>
<PostSyncScripts>
<PostSyncScript name="PostSyncScriptName" timeout="200">
<CQL>update domain.table SET column = value where condition</CQL>
</PostSyncScript>
...
</PostSyncScripts>
<SyncKey>
<SyncKeyColumnReference name="Target Column Name" />
...
</SyncKey>
<NewRecordBehaviour type="INSERT/IGNORE" />
<ChangedRecordBehaviour type="UPDATE/IGNORE" />
<DroppedRecordBehaviour type="DELETE/EXPIRE/IGNORE"/>
</Target>

‚Äč