Is it possible to connect a SQL Server Database using the Federated Engine in MySQL? I have reviewed the documentation and it appears that the Federated Engine only connects natively to MySQL. I also found this article:
You can use the SQL Gateway to configure a MySQL remoting service and set up federated tables for SQL Server data. The service is a daemon process that provides a MySQL interface to the CData ODBC Driver for SQL Server: After you have started the service, you can create a server and tables using the FEDERATED Storage Engine in MySQL. You can then work with SQL Server data just as you would local MySQL tables.
Can anyone suggest a solution or alternative? Thank you.
No, as stated in the manual
13.7.3. Limitations of the FEDERATED Storage Engine
The following items indicate features that the FEDERATED storage engine does and does not support:
The remote server must be a MySQL server.
http://download.nust.na/pub6/mysql/doc/refman/5.0/en/federated-limitations.html