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 ...
Get Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
