How can I open a connection between MySQL database and Oracle database?
You can solve this problem via an ODBC- and/or JDBC-compliant Data Virtualization Platform. Here’s how it works, bearing in mind that you have ODBC-access available to both Oracle and MySQL Database Management Systems (DBMS):
- You attach MySQL instance to the Data Virtualization Platform
- You attach Oracle instance to the Data Virtualization Platform
- You can then perform your Data Manipulation (DML) operations on Data managed by either DBMS as though they are local tables in the Data Virtualization Layer.
Data Virtualization Platform Solution
Our Virtuoso Multi-Model Database Management and Virtualization Platform is an example of a Data Virtualization solution that operates in the manner described above.