Example: Working with SQL Server
This chapter builds upon the incremental example scenario created in Chapter 5, Working with Databases, and Chapter 6, Working with MySQL. It is best to read through those chapters first.
Overview of the task
We will be accomplishing the following tasks in this chapter:
Expand the ODI Topology to enable access to a SQL Server database
Revisit the reverse-engineering process to create a model based on the SQL Server source database and also to complete the model of our PO processing system target data mart
Prepare to move the Sales data by creating interfaces that enrich and transform the source Sales Division data
Check ODI interface execution using Operator Navigator, viewing the execution status along with sampling portions of the SQL code generated and run by ODI
Integrating the Sales data
In this example, we will be populating the Sales Person data to the data mart. This new data mart supporting our PO processing example needs the Sales Person data to accurately...
