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 executing the code and checking some key metrics
Moving the inventory data: Including some aggregation and enrichment achieved through the use of a an ODI lookup, followed by checking some of the execution metrics
