Sync Data Command
The command line options control the execution parameters, and reference an XML based configuration that is stored in the Data Sync Configurations table of the Cinchy CLI Model through the --feed parameter. This XML configuration outlines parameters, any required connection details, the structure of the source data, filters, transformations, mappings to the target, the key columns for matching source to target, and the desired change behaviour. See here for additional information on the XML structure.


-h, --https
Flag indicating connections to Cinchy should be over https.
-s, --server
Required. The full path to the Cinchy server without the protocol (e.g.
-u, --userid
Required. The user id to login to Cinchy.
-p, --password
Required. The encrypted password of the specified user (generated using the CLI's encrypt command).
-m, --model
Required. The Cinchy model to use for retrieval of batch configuration information and persistence of execution log. (use Cinchy if you do not know what to choose)
-f, --feed
Required. The name of the feed configuration as defined in Cinchy.
-d, --tempdirectory
Only applies to Cinchy v4. Required. The path to a directory that the CLI can use for storing temporary files to support the sync (e.g. error files).
-b, --batchsize
(Default: 5000) The number of rows to sync per batch (within a partition) when executing inserts/updates.
-z, --retrievalbatchsize
(Default: 5000) The max number of rows to retrieve in a single batch from Cinchy when downloading data.
-v, --param-values
Job parameter values defined as one or more name value pairs delimited by a colon (i.e. -v name1:value1 name2:value2).
Works exactly as -v but it is for parameters that are files.
-o, --maxParallelUpdates
(Default: 1) Maximum number of parallel batches to be run.
-q, --quiet
Flag to avoid writing console output until completion.
Displays the help screen with the options.
-w, --writetofile
Write the data from Cinchy to disk, required for large data sets exceeding 2GB.
Copy link