-1

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.

Dale K
  • 25,246
  • 15
  • 42
  • 71
Ziyodullo
  • 13
  • 1
  • Where did you find that article? – Bill Karwin Jun 16 '23 at 22:43
  • @BillKarwin looks like https://www.cdata.com/kb/tech/sql-odbc-mysql-federated-tables.rst it's about https://www.cdata.com/sqlgateway/ which has a free trial download so assume costs $ – ysth Jun 16 '23 at 22:45
  • Okay that sounds like it's some kind of proxy that serves the MySQL protocol. So one would not be connecting directly to Microsoft SQL Server, but eventually the proxy does provide access to the SQL Server as if it is another MySQL server. Still, this is clearly not a feature of MySQL by itself. – Bill Karwin Jun 16 '23 at 22:51

1 Answers1

0

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

nbk
  • 45,398
  • 8
  • 30
  • 47