Data Integration Using DTS

The scenario described in this chapter focuses on using data integration as a tool for providing application integration in the enterprise. Data tables are imported from DB2 on an AS/400 system and exported to SQL Server on Windows 2000. Once the data is stored in SQL Server, it can be easily accessed for analysis, projections, and custom reports. SQL Server supports a variety of query features for generating queries including Query Analyzer, English Query, and Analysis Services (OLAP). DTS can also be used to export data directly to Excel files or other formats. While this chapter has focused on importing data from DB2 to SQL Server, DTS supports transfer between any heterogeneous data sources using OLE DB or ODBC. The scenario could as easily be revised to provide data integration with Oracle, Sybase, Informix, or any data source supported by an OLE DB Provider or ODBC Driver. Combining SQL Server's Data Transformation Services with OLE DB and ODBC (database middleware) offers a powerful framework for data integration in the enterprise.

Previous Next