-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial

So far, we have seen how ODI can simplify and expedite data integration challenges when using Oracle and MySQL databases. But what if your company has a site license for Microsoft SQL Server? Or what if the majority of your database administrators and data architects are from a SQL Server database background? Not to worry! ODI supports Microsoft SQL Server as a first class database technology.
As we have seen in the previous chapters, ODI is effective at abstracting away the nuances of a given database technology and virtually eliminating the hand coding of SQL as compared to a traditional ETL project approach. Using our Purchase Order example, we'll be covering the following topics in this chapter:
Provide a third (Oracle, MySQL, and now SQL Server) exposure of going through the process of working with ODI to create and test integration interfaces
Define a SQL Server Data Server using Topology Navigator
Introduce the Expression Editor and learn how...
Change the font size
Change margin width
Change background colour