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 ...

Get Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial