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,
REGIONS. Using those datastores we designed two interfaces to load the Sales data from SQL Server to our Oracle ...