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

Login

By submitting you agree to receive email communications from
TechTarget and its partners. Privacy Policy Terms of Use.

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

Dozens more answers to tough Oracle questions from Brian Peasland are available.
The Best Oracle Web Links: tips, tutorials, scripts, and more.
Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.

More News and Tutorials

Articles

Related glossary terms

Terms for Whatis.com - the technology online dictionary

This was first published in May 2003

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Back to top

More from Related TechTarget Sites

Data Management
Business Analytics
SAP
SQL Server
Java
Data Center
Content Management
Financial Applications

Data Management
- Wikibon analyst scopes big data market, predicts explosive growth
  
  Big data technologies challenge the status quo. In this Q&A;, analyst Jeff Kelly sorts through the issues and sees big-time growth in new methods.
- Gartner Magic Quadrant finds rising demand for data warehouse services
  
  A look at the latest Gartner Magic Quadrant for Data Warehouse Database Management Systems and more data management news from around the Web.
- Business capability model helps data pros sell MDM, Gartner says
  
  Data management pros need business buy-in to get funding for MDM initiatives. Modeling business capabilities can help, according to a Gartner analyst.
Business Analytics
- Wixom: BI applications need visual appeal
  
  Business intelligence teams should upgrade their visual design skills to create winning applications for BI users, says IT professor Barbara Wixom.
- Business intelligence program needs long-term tending to fully blossom
  
  The evolution of Quicken Loans' business intelligence strategy from static reporting to self-service BI holds useful lessons for other organizations.
- O'Reilly Strata conference tackles big topics in data science, Hadoop
  
  The O'Reilly Strata conference was the place to be to learn about the role of the data scientist and big data technologies.
SAP
- Getting the right team is critical for advancing SAP mobility
  
  Getting the most out of an SAP mobile center of excellence depends on a range of factors, including who's on the team, writes Michael Bestvina.
- Middleware tools for integrating SAP, third-party software growing
  
  Middleware options for integrating SAP and non-SAP software are increasing. Choosing the right one depends on a range of factors, say experts.
- SAP Financials OnDemand gets updates, questions
  
  SAP announces new improvements to SAP Financials OnDemand amid low adoption numbers.
SQL Server
- SQL Server big data technologies should be a major DBA focus
  
  Microsoft platform architect Mark Kromer says in this Q&A; that DBAs need to start focusing on SQL Server big data technologies to stay up-to-date.
- Six top SQL Server 2012 management tools you should know about
  
  Read this tip from Basit Farooq to learn which time-saving and job-improving SQL Server 2012 management tools you need to know about.
- Legacy file systems, away: Dealing with an unsupported file system
  
  When the City of Aurora, Colo. heard that its legacy file system would no longer be supported, it had to act fast.
Java
- Public cloud vs private cloud vs hybrid cloud
  
  As an enterprise architect, you already know you're going to adopt cloud architecture. Will it be public cloud, private cloud or hybrid cloud?
- Meet the challenges involved in migrating to the cloud
  
  Migrating to the cloud doesn't have to be scary. The challenges of getting from service-oriented to as-a-service can be overcome one by one.
- Key benefits of architecting loosely coupled SOA-based resolutions
  
  Service-oriented architectures (SOA) experience the most benefits when architects use loose coupling to build their solutions.
Data Center
- Q&A;: Markley looks to lighten load as an IaaS provider
  
  Interest in cloud continues to gain traction, so how does a small infrastructure services provider compete with the Amazon Web Services of the world?
- Big data analytics software for intelligence community goes commercial
  
  IT shops that need to analyze huge volumes of data can look to a newly available big data analytics tool that was previously reserved for the intelligence community.
- Recycling servers: Exploring the biodegradable server
  
  Steve Bigelow weighs in on a question about the potential of fully recycling servers with biodegradable chassis.
Content Management
- Chief content officer can create value from content management noise
  
  The Google Reader RSS controversy could give chief content officers an opportunity to see what matters in content management and what doesn't.
- Rich media flood pushes digital asset management strategy to forefront
  
  Without an effective plan for managing digital assets, the increasing digital content collected by organizations could end up being a real headache.
- Avoid the pitfalls of cloud collaboration management
  
  Analyst Tim Walters explains how to build a strong case for cloud collaboration management and how to avoid problems that pop up along the way.
Financial Applications
- Ceridian Dayforce drives employee self-service at nonprofit
  
  Lutheran Homes of Michigan ramped up self-service with Ceridian's Dayforce HCM software, though it had to standardize payroll processes along the way.
- CPM suite adding more BI, tax functions according to Magic Quadrant
  
  In part two of this Q&A;, a co-author of the 2013 Gartner Magic Quadrant for CPM describes where BI and CPM might overlap.
- Is IT really getting ready for a third platform?
  
  IDC's claim that a new social-mobile-big data infrastructure is replacing PCs might be more wish than reality.

All Rights Reserved,Copyright 2003 - 2013, TechTarget