MySQL DataController

The MySQL Datacontroller storage engine for the MySQL relational database management system is a storage engine which allows a user to create a table that is a local representation of a foreign (remote) table.The foreign table can be located into another storage engine like Oracle or Microsoft SQL Server (MSSQL). To create a Federated table, one has to specify a URL in the "CONNECTION" string: create table foo ( id int, bar varchar(255), dt date)ENGINE=DATACONTROLLER CONNECTION='oracle://username:password@hostname:1521/SID/foo' The connection URL is in the format of:

MySQL DataController

The MySQL Datacontroller storage engine for the MySQL relational database management system is a storage engine which allows a user to create a table that is a local representation of a foreign (remote) table.The foreign table can be located into another storage engine like Oracle or Microsoft SQL Server (MSSQL). To create a Federated table, one has to specify a URL in the "CONNECTION" string: create table foo ( id int, bar varchar(255), dt date)ENGINE=DATACONTROLLER CONNECTION='oracle://username:password@hostname:1521/SID/foo' The connection URL is in the format of: