Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to query data from Oracle, MySQL, and MSSQL?

Peter CheungFeb 5 2015 — edited Feb 6 2015

For an environment consisting of Oracle 11g/12c enterprise edition, MySQL 5.7 community edition, and MSSQL 2008/2012 stanard/enterprise edition, is there any major issue using DG4ODBC to query data from all 3 platforms?

Is there other free alternatives?

If the queried data is mostly contained in MySQL or MSSQL, will it be more efficient to query from MySQL or MSSQL?

If yes, any suggestion of how to do it in those platforms? I know MSSQL can use linked server but it is quite slow.

This post has been answered by Mkirtley-Oracle on Feb 6 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 6 2015
Added on Feb 5 2015
7 comments
1,944 views