CData supports creating a linked server in SQL Server Management Studio with our ODBC drivers. This section describes how to create a linked server and then execute queries from that linked server.
Create a Linked Server
See Create a Linked Server for information on creating a linked server in SQL Server Management Studio.
Linked server support is enabled through the ODBC remoting feature. The ODBC remoting feature allows you to connect to the ODBC driver from remote machines. You connect to each ODBC data source as a virtual MySQL or SQL Server database, communicating through the MySQL or TDS (SQL Server) protocols. ODBC remoting is managed through the CData SQL Gateway application. The remoting feature is only available in the Windows edition.
Execute Queries on a Linked Server
See Execute Queries on a Linked Server for information on executing queries to the Sage 200 linked server from any tool that can connect to SQL Server.
Connect from MySQL Workbench
See Connect from MySQL Workbench for information on configuring ODBC remoting and accessing Sage 200 as a virtual MySQL database in MySQL Workbench.