Ask the Expert

Integrating MySQL into Oracle

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

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

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: