v5.0 - v5.5 Data Sync Documentation
  • Overview
  • Release Notes
    • V4.5
    • V4.6
    • v4.7
    • v4.8
    • v4.9
    • v4.10
    • v4.12
    • v4.13
  • v4 Connections Installation Guide
    • v5 Connections and CLI Installation Guide
  • v4 Worker/Listener Installation Guide
    • v5 Worker/Listener Installation Guide
  • Upgrades & Config Changes
  • Builder Guide
    • Overview
    • Types of Data Syncs
    • Subscribing to Event Streams
      • Supported Stream Sources
        • Amazon Simple Queue Service (SQS)
        • Cinchy Change Data Capture
        • Data Polling
        • Kafka Topic
        • MongoDB
        • Salesforce
          • Push Topic
          • Platform Event
    • Configuring a Data Sync
      • Connections Experience & XML Config Reference
        • Info
          • Parameters
            • String Escape
        • Source Config Reference
          • Schema Columns
            • Calculated Column Examples
          • Auth Requests
          • Request Headers
          • Pagination
          • Source Filter
        • Target Destination Config Reference
          • Column Mappings
          • Target Destination Filter
        • Sync Behaviour
        • Post Sync
        • Permissions
        • Jobs
        • Connections Usage Example
      • Data Validation
      • Transformations
        • StringReplacement
      • Supported Data Sources
        • File Based Source
          • Binary File
            • Binary File Data Source Example
          • Delimited File
            • Delimited File Data Source XML Example
          • Fixed Width File
          • Excel
            • Excel Source XML Example
        • Cinchy Event Broker/CDC
          • Cinchy Event Broker/CDC XML Config Example
        • Cinchy Table
          • Cinchy Table XML Config Example
        • Cinchy Query
          • Cinchy Query Data Source Example
        • Copper
        • DB2
        • Dynamics 2015
        • Dynamics
        • DynamoDB
        • Kafka Topic
          • Apache AVRO Data Format
          • Kafka Topic Source Example
        • LDAP
        • MongoDB Collection
          • MongoDB Collection Source XML Example
        • MongoDB Collection (Cinchy Event Triggered)
        • MS SQL Server Query
        • MS SQL Server Table
        • ODBC Table
        • ODBC Query
        • Oracle Table
        • Oracle Query
        • Parquet
        • Polling Event
          • Polling Event Example
        • REST API (Cinchy Event Triggered)
        • REST API
          • REST API XML Example
        • SAP SuccessFactors
        • Salesforce Object (Bulk API)
        • Salesforce Platform Event
        • Salesforce Push Topic
        • Snowflake
          • Snowflake Source XML Example
        • SOAP 1.2 Web Service
      • Supported Sync Targets
        • Cinchy Table
        • DB2 Table
        • Dynamics
        • Kafka Topic
        • MongoDB Collection (Column Based)
        • MS SQL Server Table
        • Oracle Table
        • REST API
        • Salesforce
        • Salesforce Object
        • Snowflake Table
          • Snowflake Table Target XML Example
        • SOAP 1.2 Web Service
    • Common Design Patterns
    • Testing a Data Sync
    • Promoting a Data Sync
    • Scheduling a Data Sync
    • CLI Command List
    • Connections Functions
    • Monitoring
  • Cinchy Platform Documentation
Powered by GitBook
On this page
  • Setting Up a Task in Windows Task
  • Sample Action Script

Was this helpful?

  1. Builder Guide

Scheduling a Data Sync

Any task / job scheduling application can be used to run data sync automatically, on a schedule

Setting Up a Task in Windows Task

Scheduler Data synchronization commands can be scheduled to run automatically based on your data synchronization requirements (e.g. certain date/times/intervals). The CLI command that is used to execute the data synchronization can be saved as a script in PowerShell, Batch or a Command file.

Here's an example of how to schedule the CLI with Windows Task Scheduler:

  1. Launch Windows Task Scheduler

  2. Create a folder to contain the CLI jobs (options)

  3. Right click on CLI job folder

  4. Select Create Task

  5. On the General tab, enter the Name of the job you want to schedule

  6. Click on the Trigger Tab

  7. Click New and set your schedule preferences

  8. Click the Action Tab

  9. Click New button

  10. Click Browse and navigate to the folder that contains the data sync scheduling script for execution

  11. Copy and Paste the Start In (optional) filed the path for your Cinchy CLI folder

Sample Action Script

SET server="URL" SET user="UserID" SET password="EncryptedPassword" SET tempdir="Error Log Folder" SET file="File Path for Source"

dotnet Cinchy.Connections.CLI.dll syncdata -s %server% -u %user% -p %password% -m "ModelName" -d %tempdir% -f "Feed" -v "filePath":%file%
PreviousPromoting a Data SyncNextCLI Command List

Last updated 2 years ago

Was this helpful?