Update a target dataset (e.g. a Cinchy table, a database table, etc.) with data from an input source (e.g. a delimited file, Salesforce, etc.) using a defined key to match records
View the parameters for this command below.
exportdata
Exports the results of a saved query to a delimited file.
View the parameters for this command below.
Ex:
./Cinchy.Connections.CLI.exe exportdata -h -s sandbox.cinchy.net/dev-aurora-2 -d Sandbox -n "Query With Over 1000" -u admin -p cinchy -o 'C:\Users\MyUser\Downloads\output.csv' -r
matchdata
Matches data across sources to create a master record in Cinchy
appdiff
Generates a report outlining the differences between the physical implementation of an application across Cinchy environments
encrypt
Generates an encrypted string for use in other areas of the CLI.
View the parameters for this command below.
--version
Outputs the current version of the CLI
Parameters
SyncData Parameters
-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. cinchy.co/Cinchy).
-u, --userid: Required. The user id to login to Cinchy.
-p, --password:Required. The password of the specified user. This can be optionally encrypted using the CLI's encrypt command.
-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).
--file: Works exactly as -v but it is for parameters that are files.
--help: Displays the help screen with the options.
-w, --writetofile: Write the data from Cinchy to disk, required for large data sets exceeding 2GB.
ExportData Parameters
-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. cinchy.co/Cinchy).
-u, --userid: Required. The user id to login to Cinchy.
-p, --password:Required. The password of the specified user. This can be optionally encrypted using the CLI's encrypt command.
-d, --domain: Required. The domain where your saved query resides.
-n, --name: Required. The name of your saved query.
-o, --outputpath. Required. The full path for the target output file.
-l, --delimiter. The delimiter to used in the output. This can be either COMMA, PIPE, or TAB. This defaults to COMMA if you do not set the parameter.
-i, --includeheaders. A flag to include headers in the output file.
-e, --encoding. The encoding to use for the output file, either ASCII, UTF8, or UTF16. This defaults to UTF16 if you do not set the parameter.
-t, --commandtimeout. The wait time in seconds before terminating the query execution. This defaults to 30 seconds if you do not set the parameter.
-g, --progressbatchsize. When downloading data, this is the number of MB after which progress should be logged. Setting this to 0 prevents any progress messages to the console. This defaults to 10 if you do not set the parameter.
-r, --overwriteoutput. A flag indicating whether to overwrite the output file contents if it already exists.
-q, --donotescape. Setting this flag prevents text values from being escaped using quotes. This should only be used if you are certain the delimiter will not appear in your data, otherwise output may be invalid.
-v, --param-values. Query parameter values defined as one or more name value pairs delimited by a colon (i.e. -v name1:value1 name2:value2)
-a, --tls. The TLS protocol version.
Encrypt Parameters
-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. cinchy.co/Cinchy).
-u, --userid: Required. The user id to login to Cinchy.
-p, --password:Required. The password of the specified user. This can be optionally encrypted using the CLI's encrypt command.
-t, --text. Required. The full text that you want to encrypt.
