You should now be starting to feel comfortable with some of the common activities in ODI. After first installing a third-party JDBC driver (MySQL), you were presented with two examples which led us through a series of activities representing many of the most frequently performed tasks within ODI.

Following those examples, we built several topology entries for data servers and physical schemas and linked them to logical schema names via contexts. We then used those logical schemas to reverse-engineer physical, vendor-specific metadata into a logical, platform-independent data model.

We then created a new project folder and imported the specific Knowledge Modules that would be needed based upon the interface requirements. We then built two ...

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

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.