Q

Integrating MySQL into Oracle

Can you tell me how I can integrate MySQL database tables (customer, inventory) into the Oracle inventory table...

schema?

The term "integrate" can mean many things. Do you want to move the data from MySQL into Oracle? Or do you want Oracle to be able to access the data from MySQL directly?

If you want to move the data, then dump the data as a comma delimited file, one for each table. Then use Oracle's SQL*Loader to load the data into Oracle. Or, you would write a Perl program to do a pull-push operation using DBI.

If you want to access the data directly, then you'll want to set up an Oracle Transparent Gateway to the MySQL database. Then set up an Oracle database link to the Transparent Gateway. You'll be able to query the MySQL data directly in Oracle across the database link just as if it were another Oracle database.

For More Information


This was last published in May 2003

Dig Deeper on Oracle database design and architecture

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close