-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial

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
Change the font size
Change margin width
Change background colour