The SQL Gateway is an installed application that allows you to connect to ODBC data sources as if they were virtual MySQL, PostgreSQL, or SQL Server databases.

SQL Gateway

The CData SQL Gateway enables remote access to ODBC data sources as virtual SQL Server, PostgreSQL, or MySQL databases. The SQL Gateway application listens on a configured port for requests made in the MySQL, PostgreSQL, or TDS (SQL Server) wire protocols and responds to those by reading from and writing to the ODBC data source. This allows you to connect to any ODBC DSN from remote machines, using any application that can work with either MySQL, PostgreSQL or SQL Server.

Linked Server

CData supports creating a Linked Server in SQL Server Management Studio with our ODBC drivers. This section describes the benefits of using a linked server, how to create a linked server, metadata discovery using a linked server, and executing queries from the linked server.

MySQL Remoting

The CData ODBC Driver for SASXpt integrates with MySQL clients using MySQL Remoting, managed through the CData SQL Gateway application.

PostgreSQL Remoting

The CData SQL Gateway application exposes ODBC DSNs, such as those created using this driver, as virtual PostgreSQL databases through the use of PostgreSQL Remoting.

Server License

To use the SQL Gateway service, a Server License for the CData ODBC Driver for SAS Xpt is required to establish and run the remoting services, commonly referred to as SQL Gateway functionality.