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

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).

-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.