Cinchy Table

1. Overview
Cinchy Tables are commonly used data sync targets.
Prior to setting up your data sync destination, ensure that you've configured your Source.​
The Cinchy Table destination supports batch and real-time syncs.
2. Destination Tab
The following table outlines the mandatory and optional parameters you will find on the Destination tab (Image 1).
Destination Details
Column Mapping
Filter
The following parameters will help to define your data sync destination and how it functions.
Parameter
Description
Example
Destination
Mandatory. Select your destination from the drop down menu.
Cinchy Table
Domain
Mandatory. The domain where your destination table resides.
Product
Table Name
Mandatory. The name of you destination table.
Q1 Sales
Suppress Duplicate Errors
Optional. This field determines whether duplicate keys are to be reported as warnings (unchecked) or ignored (checked). The default is unchecked.
Checking this box can be useful in the event that  you only want to load the distinct values from a collection of columns in the source.
​
Degree of Parallelism
The number of batch inserts and updates that can be run in parallel. This defaults to 1.
1
The Column Mapping section is where you define which source columns you want to sync to which destination columns. You can repeat the values for multiple columns.
Parameter
Description
Example
Source Column
Mandatory. The name of your column as it appears in the source.
Name
Target Column
Mandatory. The name of your column as it appears in the destination.
Name
Link Column
This value is only used when utilizing a Cinchy Table destination with a linked column. 

For example:
Your destination column is an Employee's favourite colour that links into the System Colours table.

If your source data contains hex values (eg. #00B050) for that mapping, then you'd put Hex Value in the link column field.

If your source data contains the colour names (eg. Green), then you'd put Name in the link column field.
​
You have the option to add a destination filter to your data sync. Please review the documentation here for more information on destination filters.​
Image 2: Define your Destination
4. Next Steps
Define your Sync Behaviour.
Add in your Post Sync Scripts, if required.
Define your Permissions.
If you are running a real-time sync, set up your Listener Config and enable it to begin your sync.
If you are running a batch sync, click Jobs > Start a Job to begin your sync.

Parameter	Description	Example
Destination	Mandatory. Select your destination from the drop down menu.	Cinchy Table
Domain	Mandatory. The domain where your destination table resides.	Product
Table Name	Mandatory. The name of you destination table.	Q1 Sales
Suppress Duplicate Errors	Optional. This field determines whether duplicate keys are to be reported as warnings (unchecked) or ignored (checked). The default is unchecked. Checking this box can be useful in the event that you only want to load the distinct values from a collection of columns in the source.
Degree of Parallelism	The number of batch inserts and updates that can be run in parallel. This defaults to 1.	1

Parameter	Description	Example
Source Column	Mandatory. The name of your column as it appears in the source.	Name
Target Column	Mandatory. The name of your column as it appears in the destination.	Name
Link Column	This value is only used when utilizing a Cinchy Table destination with a linked column. For example: Your destination column is an Employee's favourite colour that links into the System Colours table. If your source data contains hex values (eg. #00B050) for that mapping, then you'd put Hex Value in the link column field. If your source data contains the colour names (eg. Green), then you'd put Name in the link column field.

Last modified 3mo ago