Unisys and Microsoft have dispelled the perception that for high performance ETL, the only alternative is a UNIX-based solution. With SQL Server 2005 Integration Services, Microsoft and Unisys deliver an optimized ETL solution that will support even the most demanding enterprise Business Intelligence (BI) initiatives. They conducted a series of real ETL (Extraction, Transformation and Load) tests with Microsoft SQL Server 2005 Integration Services (SSIS, formerly known as DTS). Performance tests compared throughput, scalability and performance on both 32- and 64-bit processor configurations on a Unisys ES7000. SSIS demonstrated parallelism and the ability to utilize all available CPUs in multiple aggregation, parallel lookup and transformation testing.
Read the rest of this entry »

• 0 Comments

Unisys and Microsoft collaborated on a proof of concept to demonstrate that the Microsoft SQL Server 2005 product suite will support even the most demanding enterprise business intelligence initiatives. The proof of concept shows that SQL Server 2005 can deliver the same or better results for a high-performance enterprise-class data warehouse than the more-costly alternatives.
Read the rest of this entry »

• 0 Comments