Services

On the Services tab, configure services to create proxy MySQL, PostgreSQL, or SQL Server connections to ODBC drivers. To run services as Windows services, select Run as a Windows Service on the Status tab.

For additional connection settings, such as configuring TLS/SSL, see Other.

Service Settings

The following settings configure the proxy service. Note that you must have Windows administrator access because the SQL Gateway connects through system DSNs.

Service Name: name the database.
SQL Server, PostgreSQL, or MySQL: select the database type to emulate.
SSL: select this option to use TLS/SSL to encrypt client connections. Required when emulating SQL Server databases, optional when emulating MySQL or PostgreSQL databases. See Other to configure the server certificate.
Port: select an inactive port for the service to run on.
Expose through SSH Tunnel: enable this option to allow remote access to firewalled databases through an SSH server. You need to first configure the SSH Tunnel feature on the Tunneling tab. If the SSH server is running, the SQL Gateway automatically selects a port on the server; when connecting to the SSH server, specify the Remote Port value.
Support multiple catalogs and schemas: enable this to expose multiple schemas and catalogs from the CData ODBC Driver for JSON in the service. Otherwise, the service only exposes the default schema and catalog.

Data Source

Data Source: select the system DSN for the ODBC data source you want to expose as a virtual SQL Server, PostgreSQL, or MySQL database.

Startup Settings

Windows services have the following startup options:

Automatic: the service automatically starts at boot.
Manual: services configured for manual startup can be started manually or from an application, such as the SQL Gateway or a script.
Disabled: the service can only be started manually from the Services snap-in to the Microsoft Management Console or the Task Manager.

You can start Windows services from the SQL Gateway's Services tab or from the Services snap-in to the Microsoft Management Console. To load the snap-in, enter run in the Start menu and then enter services.msc.

Logging Options

Basic information about the service, such as startup and shutdown, is displayed on the Status tab.

To retrieve more verbose service-specific logs, open the Services tab, select a service, navigate to Edit > Logging Options, then enable the Write Log to a File option and set Log Mode to your desired level of log complexity.

The logging options on the Other tab log to a file when the configured services start and stop, along with any errors encountered in the SQL Gateway app itself.

Managing Incoming Connections