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 live online training, plus books, videos, and digital content from nearly 200 publishers.