Chapter 4. ODI Sources, Targets, and Knowledge Modules

We know that the primary use of ODI is to move and transform data from one place to another. So in this chapter we'll be delving a bit deeper into the activities and concepts governing the definition and use of source and target datastores and the mechanisms used to move data between them.

First of all we'll take a look at how you define and configure data servers and schemas and how to reverse-engineer them into ODI models to provide sources and targets for interface flows. Then we'll have a look at some simple, but common interface flow examples, and finally we'll revisit Knowledge Modules and the roles they play in data flows. The activities and concepts we'll be covering in this chapter include the following:

• Defining Physical Schemas using the Topology Navigator and linking them to Logical Schema names via Contexts

• Reverse-engineering metadata from database and database-like systems into ODI models using Designer Navigator

• Reverse-engineering...