Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1589
  • Last Modified:

how to query oracle from mysql

Greetings,
I would like to create a link in my mysql instance to allow me to perform select statements against oracle.  What I am going to do is create a user in oracle with select privledges only, and in stored procedures I am going to perform said select statements as source data from oracle and land them in mysql.

Thanks much
0
Evan Cutler
Asked:
Evan Cutler
  • 3
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
from what I know, this is not possible.
you can (using federated engine tables) query remote mysql tables, but not other database engines.

the other way round would work, using oracle odbc db link gateways:
http://docs.oracle.com/cd/B28359_01/gateways.111/b31042/configodbc.htm
0
 
Evan CutlerVolunteer Chief Information OfficerAuthor Commented:
ok...how about the reverse....can I cannect to mysql tables remotely and push?
like this?

1. create oracle username.
2. Give username select privs on my other schemas
3. create dblink to Mysql
4. drop into Mysql???

Thanks
0
 
DavidSenior Oracle Database AdministratorCommented:
I can't jump into this yet, but provide the versions please.  Always a help.
0
 
Evan CutlerVolunteer Chief Information OfficerAuthor Commented:
Thanks...
mysql 5.0.95-5.el5_9  on red hat
oracle 11g on red hat
0
 
Evan CutlerVolunteer Chief Information OfficerAuthor Commented:
Thank you very much.  While I couldn't work the solution I needed.  I added this to my knowledge base and asked my DBAs to research this as a resolution.  If I have any further questions, I'll let you know.

Evan
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now