New DI Performance World Record

SAS and Sun Microsystems Inc., smashed the competition, setting a new world-record benchmark for the extraction, transformation and loading (ETL) of massive volumes of data into a data warehouse. 

The results of these benchmarks revealed that the powerful SAS Enterprise Data Integration Server on the Sun SPARC processor can outperform any other vendor's tools by more than 250 percent in throughput testing, based on published results.

The test of SAS Enterprise Data Integration Server for ETL involved the throughput of 3.9 terabyte (trillion bytes) in one hour, representing 81.2 GB/Hour/CPU – a world record based on published benchmarks. The test was performed using a Sun Microsystems Sun Fire E25K domainable server running UltraSPARC IV+ processors (dual-core CPU), the Solaris 10 operating system and Sun StorEdge SAM-FS/QFS shared file system.

Flexible, reliable, agile
SAS' capabilities for ETL are a key component of SAS Data Integration, which offers a comprehensive, universal data integration solution that includes technologies for connectivity and metadata, data cleansing and enrichment, ETL, migration and synchronization, data federation and master data management. These capabilities provide organizations with the flexibility, reliability and agility to respond quickly to new data integration requirements, consolidate vendors, standardize on one integration solution for both operational and business intelligence applications, and reduce the overall cost of data integration.

"Today's organizations are struggling with ever-increasing amounts of data that cannot be extracted and loaded using the ETL technologies that have served them well in the past. As a result, many organizations are looking for ways to speed the ETL process, including buying more powerful hardware at great cost," says Allan Russell, Senior Vice President of Strategy for SAS International.

"This second benchmark on Sun hardware platforms offers an appealing alternative by demonstrating that SAS can prolong the life of an enterprise's hardware now and also minimize the upgrades required in the future," says Russell. "If companies are considering addressing poor performance through hardware upgrades, this benchmark clearly shows that SAS has a lot to offer in keeping investment costs to the minimum."

SAS and Sun Microsystems set a new record, outperforming all other data integration tools by more than 250 percent.