Skip to main content

Install and connect the Gateway

The Cloud Connector Gateway is a Windows service installed inside the customer's network. It discovers tables, reads rows and pushes them to the cloud over outbound HTTPS only; nothing connects in. One install serves any number of source system instances, SQL Server and ODBC mixed freely.

Requirements​

  • Windows 10/11 or Windows Server 2019 or later, x64. No .NET install is needed.
  • Outbound TCP 443 to the Cloud Connector URL.
  • Network reach to the SQL Server, or a 64-bit System DSN for an ODBC source. A 32-bit driver cannot be used, and a User DSN is invisible to the service: it tests green in the Setup UI and then every sync fails with "data source name not found".
  • For the Change Tracking strategy on SQL Server, a one-time ALTER DATABASE … SET CHANGE_TRACKING = ON plus ENABLE CHANGE_TRACKING per table.

Install and connect​

  1. In Cloud Connector, create an On-premises source system and an instance, open the instance, and in On-prem push (Cloud Connector Gateway) press Generate key. Copy the Base URL, the Source system instance ID and the key.
  2. Run the signed MSI on the host. It installs the Setup UI and the service (NT SERVICE\CloudConnectorGateway, automatic start) and opens the Setup UI.
  3. On the Instances tab, Add instance, paste the three values and press Test cloud connection. Pick the connector type, SQL Server (server, database, authentication) or ODBC (a System DSN), and press Test source connection; on ODBC, Check driver compatibility reports what the driver can and cannot do. Save.
  4. Repeat for every further database this host should serve. Each instance is its own cloud identity.
  5. On the Service tab, Start. Adding, editing or disabling an instance later is picked up without a restart.

The Logs tab shows the UI and service log files; the service deletes log files older than 45 days.