Chapter 5. Working with Databases
Databases and database systems hold the vast majority of data processed by ODI around the world, so it's appropriate that we start our Purchase Order example by performing some basic work using databases.
Our overall example scenario involves uploading information concerning Purchase Order processing into a data mart and we'll begin by moving data from a customer data system's database into our data mart. To do this we'll be performing the following tasks:
Take a quick overview of the physical layout of our source and target systems and the requirements for our first data integration task
Configure data servers, Physical Schemas, and Logical Schemas for our target and source systems and link them to a Context using the Topology Navigator
Use the Designer Navigator to create models based on the Logical Schemas and reverse-engineer the metadata from the physical systems in our environment
Create a new project in the Designer Navigator and import the Knowledge Modules...
