Bug #83224 Linked Servers of MS SQL; CONNECT Storage Engine of MariaDB; or Oracle Database
Submitted: 30 Sep 2016 11:22
Reporter: Juan Telleria Email Updates:
Status: Open Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any
Tags: feature request

[30 Sep 2016 11:22] Juan Telleria
Nowadays, most data necessary isn't in our servers, and it is hosted in other RDBMS making FEDERATED engine unuseful, that is why I would like to suggest the possibility to add one (or all :-D) of the following features to MySQL: 

a) MS SQL like "Linked Servers", which support ODBC connections. This would enable to connect MySQL to other RDBMS (Such as SQL Server) to obtain data in an easy way. 

b) A CONNECT Storage Engine like the one of MariaDB. 

c) Or ODBC connecting capabilities such as the ones of "Oracle Database Gateway". 

Thank you :-)

How to repeat:
Implementing those new storage engines of MariaDB such as CONNECT is a new feature that has not been previously suggested.