In this independent report, Forrester provides an objective assessment of SQL Server 2005 Integration Services, the new Microsoft tool for data extraction, transformation, and load (ETL). The report highlights enterprise-class features, superior price/performance ratio, advanced functionality beyond traditional ETL, and the scalable architecture of SQL Server 2005 Integration Services.
| • | Enterprise–Class ETL at Mainstream Price: The enterprise features of SQL Server 2005 Integration Services—collaborative development, dedicated administration and scalability—put it squarely in the enterprise arena with a strong price/performance ratio. |
| • | Beyond ETL: SQL Server 2005 Integration Services goes beyond traditional ETL to provide advanced functionality related to data quality, data profiling, text mining, and Enterprise Information Integration. |
| • | Scalability and Reliability: SQL Server 2005 Integration Services, with its data–flow pipeline, multithreaded architecture, parallel data transformation engines, and check–pointing, supports enterprise ETL requirements of delivering huge volumes of data on time. |
Included in this document:
| • | What is Integration Services and why should anyone care? |
| • | SQL Server Integration Services takes a giant step towards enterprise ETL |
| • | Migration from Data Transformation Services to SQL Server Integration Services |
| • | Recommendations |
| • | Supplemental material |
Note: This document is presented in Adobe's Portable Document Format (.pdf). You will need Adobe Acrobat Reader to view it.