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 first published in May 2003

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close