dotnet Cinchy.CLI.dll <command> [options]
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
Exports the results of a query to a delimited file
Matches data across sources to create a master record in Cinchy
Generates a report outlining the differences between the physical implementation of an application across Cinchy environments
Generates an encrypted string for use in other areas of the CLI
Outputs the current version of the CLI
You must have a compatible instance of Cinchy available for the CLI to connect to.
The CLI runs using the .NET Core Framework, version 2.0.7+. The application can be compiled to a standalone executable for any of the target runtimes specified here.
If using the syncdata or exportdata commands, then the CLI Model must be installed in your instance of Cinchy (see below).
The syncdata and exportdata commands depend upon the below Cinchy Model being installed in your Cinchy instance. Upon execution of these commands, a reference to the model name must be passed in.
To install the model in a new environment, follow the below instructions:
Navigate to <your Cinchy instance url>/Apps/ModelLoader
Choose the file and click Submit.
Navigate back to the Models table within the Cinchy domain and locate the Name of the newly imported model. This name will be a parameter in the invocation of the CLI command.
The model contains 3 tables:
Data Sync Configurations - XML configurations for use by the syncdata command are managed in this table.
Execution Log - Both the syncdata and exportdata commands log their executions in this table. This table captures the start time, end time, status, execution output, parameters, etc.
Execution Errors - Any exceptions occurring during the syncdata operation are logged in this table, with a reference back to the record in the Execution Log table. Depending on the granularity of the exception there may be row / column level details available.