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
  • Pre-Requisites
  • Server Sizing
  • SQL Service Broker Setup
  • Event Listener Setup
  • Installation
  • Listener Configuration
  • Starting the Service
  • CLI Worker Setup
  • Installation
  • Worker Configuration
  • Log Settings
  • Starting the Service
  • Uninstall Instructions
  • Event Listener
  • CLI Worker

Was this helpful?

v4 Worker/Listener Installation Guide

Previousv5 Connections and CLI Installation GuideNextv5 Worker/Listener Installation Guide

Last updated 1 year ago

Was this helpful?

Pre-Requisites

  • Windows Server 2012+

    • .NET Core 3.1 Hosting Bundle (see below for download link)

  • SQL Server 2012+

    • Service Broker enabled

  • Cinchy Platform

Server Sizing

Minimum requirements:

  • 4 Gb of RAM

  • 30 Gb of HDD space

  • 2 CPU Cores

SQL Service Broker Setup

You need to set up the Service Broker by executing:

ALTER DATABASE [Your Cinchy Database Name] SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE;

Event Listener Setup

Installation

  • Extract content of the Cinchy Event Listener zip file to <your event listener folder>

  • Execute create-cinchy-event-listener-windows-service.ps1 PowerShell script. Pass in filePath parameter -filePath <Your Listener/Worker Path> to the agent.exe file. The script is in the installation directory.

Listener Configuration

Open appSettings.json in the Event Listener directory.

Client Settings

URL

Your Cinchy URL

Password

For v4 this will be the desired user's password.

AppSettings

Parameter

Value

Domain

Cinchy Web URL (ex. https://cinchy.net/Cinchy)

AuthServiceDomain

Cinchy SSO URL (ex. https://cinchy.net/CinchySSO)

UserName

Username for a Cinchy user that has access to read from the [Cinchy].[Listener Configs] table

Password

Encrypted password for the user above (you can use the CLI to encrypt the password)

GetNewListenerConfigsInterval

(seconds) How often the listener polls for new configs in the [Cinchy].[Listener Configs] table. Default is 60.

LogLevel

Logging level for the listener. Recommended to be set to "Info"

LogDirectory

Directory for storing the logs.

ConnectionStrings

Parameter

Value

SqlServer

Fill in the connection string to the SQL server hosting the Cinchy database.

Starting the Service

  • Open the Run box (Windows + R)

  • Open services.msc

  • In the list of services, find the Cinchy Event Listener service

  • Right click on the service and click Start

CLI Worker Setup

Installation

  • Extract content of the Cinchy.CLIWorker.zip file to C:\<your cli worker folder>

  • Execute create-cinchy-cli-worker-windows-service.ps1 PowerShell script. Pass in filePath parameter. filePath = path to the Cinchy.CLI.exe file. The script is in the installation directory.

Worker Configuration

Open appSettings.json in the CLI Worker directory.

Client Settings

URL

Your Cinchy URL

Password

For v4 this will be the desired user's password.

AppSettings

Parameter

Value

Domain

Cinchy Web URL (ex. https://cinchy.net/Cinchy)

Server

URL to the Cinchy instance to which you want to sync the messages to without the protocol (ex. cinchy.net/Cinchy)

UserName

Username for a Cinchy user that has access to read from the [Cinchy].[Listener Configs] table

Password

Encrypted password for the user above (you can use the CLI to encrypt the password)

Model

"Cinchy". This is the model for the CLI.

TempDirectory

Temp directory for the CLI to store files.

DatabaseName

Name of the database (same as the one in the ConnectionStrings below)

ConnectionStrings

Parameter

Value

SqlServer

Fill in the connection string to the SQL server hosting the Cinchy database.

Log Settings

  • Open log4net.config

  • Under <file value="" /> you can change where you want to write your logs to.

Starting the Service

  • Open the Run box (Windows + R)

  • Open services.msc

  • In the list of services, find the Cinchy CLI Worker service

  • Right click on the service and click Start

Uninstall Instructions

Event Listener

  • Stop the Cinchy Event Listener service

  • Execute remove-cinchy-event-listener-windows-service.ps1 located in installation directory. Machine reboot may be required to complete the removal process.

CLI Worker

  • Stop the Cinchy CLI Worker service

  • Execute remove-cinchy-cli-workerwindows-service.ps1 located in installation directory. Machine reboot may be required to complete the removal process.

Download .NET Core 3.1 (Linux, macOS, and Windows)Microsoft
Logo