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

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 ...

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