O'Reilly logo

Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial by Peter C. Boyd-Bowman, Bernard Wheeler, David Hecksel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using MySql with ODI

Building on the Data Topology steps we performed in the previous chapter, we'll be completing this exercise in a number of steps as follows:

  • Adding the MySQL JDBC driver: To enable ODI Studio to access the MySQL schema and data
  • Expanding the Topology: To add the MySQL server and schema to ODI's metadata
  • Reverse-engineering revisited: To create a model based on the MySQL schema that we can use for our source data and also to complete the model of our PO Processing System data mart target
  • Preparing to move the product data: By creating an interface that enriches the base product data from the source by joining some source datastores
  • Using simulation and execution: To examine the generated code before it is executed, and then actually ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required