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 data mart. While setting up the interfaces, we saw several ways to create mappings in ODI—using the Automatic Mapping feature, by dragging-and-dropping source columns into the target columns and using the Expression Editor. We then had a look...
