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

Summary

We have now completed the third incremental solution to the Order Processing example scenario. You should now be more comfortable with creating interfaces while simultaneously being exposed to selected new features of ODI 11g.

In this chapter, we started by using Topology Navigator to create a physical Data Server pointing to our SQL Server database server. We then created the required Physical and Logical schemas.

In Designer Navigator, we used the newly created Logical Schema to create a new Model and initiate a reverse-engineering process to retrieve the SQL Server datastores we were interested in, namely, SALES_PERSON_MASTER and REGIONS. Using those datastores we designed two interfaces to load the Sales data from SQL Server to our Oracle ...

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