O'Reilly logo

Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial by Peter C. Boyd-Bowman, Bernard Wheeler, David Hecksel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Reverse-engineering metadata into ODI models

Before we can access and integrate data with ODI Designer, we need to create "models" based on the Logical Schema definitions we have in the topology. ODI models are abstracted to be independent of the physical data server type (database, file, JMS queues and topics, and so on), so they will have a common look and feel despite having dramatically different physical representations. This greatly simplifies their use as sources and targets and is a major benefit of using ODI.

Although we can manually create an ODI model, including its datastore definitions, constraints, and relationships, the normal and recommended method of creating models is by reverse-engineering the structural metadata directly from ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required