Installing the Worker/Listener
The Worker and Listener are important components for using Real-Time Data syncs. At a high level, the Worker/Listener follows this process:
- Once the Listener is successfully subscribed, it waits for events from streaming source.
- The Listener receives a message from a streaming source and pushes it to SQL Server Broker.
- The Worker then picks up message from SQL Server Broker.
- The Worker fetches the matching record from the target based on the sync key.
- If there are changes detected, the Worker pushes them to the target system. Successes and failures are logged in the worker's log file.
In a Kubernetes deployment of the Cinchy Platform, the Worker/Listener is automatically installed. The below steps refer only to an IIS deployment of the Cinchy Platform.
- Windows Server 2012+
- SQL Server 2012+
- Service Broker enabled
- Cinchy Platform
- 1.On a Windows Server machine, launch an instance of PowerShell as Administrator.
- 2.Set up the SQL Service Broker by executing the following command:
ALTER DATABASE [Your Cinchy Database Name] SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE;
- 1.
- 1.Download the latest Cinchy Event Listener.zip file from the Release Artifacts column.
- 2.Extract the .zip to the folder to <your event listener folder>
- 3.Execute the create-cinchy-event-listener-windows-service.ps1 PowerShell script that is located in the installation directory. Pass in filePath parameter -filePath <Your Listener/Worker Path> to the agent.exe file.
- 1.Download the latest Cinchy Connections.zip file from the Release Artifacts column.
- 2.Extract the content of the Cinchy Worker folder to C:\<your cli worker folder>
- 3.Execute create-cinchy-cli-worker-windows-service.ps1 PowerShell script that is located in the installation directory. Pass in filePath parameter filePath = path to the Cinchy.CLI.exe file.
- 1.Navigate to the appSettings.json in your Event Listener directory and make the following configurations:
Parameter | Value |
---|---|
URL | Cinchy Web URL (ex. https://cinchy.net/Cinchy) |
Password | The password for the user [email protected]. |
Parameter | Value |
---|---|
GetNewListenerConfigsInterval | (seconds) How often the listener polls for new configs in the [Cinchy].[Listener Configs] table. Default is 60. |
Parameter | Value |
---|---|
SqlServer | Fill in the connection string to the SQL server hosting the Cinchy database. |
2. To start the service, open the Run box (Windows + R) > services.msc
3. In the list of services, find the Cinchy Event Listener service. Right click on the service and click Start.
- 1.Navigate to the appSettings.json in your Worker directory and make the following configurations:
Parameter | Value |
---|---|
URL | Cinchy Web URL (ex. https://cinchy.net/Cinchy) |
Password | The password for the user [email protected]. |
Parameter | Value |
---|---|
Model | "Cinchy". This is the model for the CLI. |
TempDirectory | Temp directory for the CLI to store files. |
Parameter | Value |
---|---|
SqlServer | Fill in the connection string to the SQL server hosting the Cinchy database. |
- 2.To start the service, open the Run box on your machine (Windows + R) > type in services.msc
- 3.In the list of services, find the Cinchy Worker.
- 4.Right click on the service and click Start.
Last modified 4mo ago