OraFAQ Forum: Server Administration » what is the procedure to select mysql database data from oracle 11g

Home » RDBMS Server » Server Administration » what is the procedure to select mysql database data from oracle 11g (oracle 11g, Redhat 5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

what is the procedure to select mysql database data from oracle 11g [message #621885]

Tue, 19 August 2014 07:26

morad_dba
Messages: 93
Registered: June 2008

Member

Dear all,

what procedure i can follow to configure database connectivity so that i can select mysql database data from oracle 11g in linux?

please tell me what package i can download?

regards,
Morad.

Report message to a moderator

Re: what is the procedure to select mysql database data from oracle 11g [message #621886 is a reply to message #621885]

Tue, 19 August 2014 07:42

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

Oracle Gateway.

Unless you use the Gateway for ODBC, it will entail additional licensing

If you use the Gateway for ODBC, it is free but you will also need an ODBC driver for the target database.

I believe that Oracle Gateway for ODBC is installed in your ORACLE_HOME by default.

If you have an MOS account, see note 1083703.1

If not, start googling, based on the clues I've given above.

See http://docs.oracle.com/cd/E11882_01/server.112/e11050/admin.htm#HETER004

Also, you will need to create a db link in the source (oracle) database.

[Updated on: Tue, 19 August 2014 07:43]

Report message to a moderator