« Applying parallel concepts to application development | Main | expressor exhibits at PASS Summit 2009 »
October 29, 2009
American Tower turbocharges complex data warehousing application with expressor
American Tower operates thousands of communications sites across the US for the wireless and broadcast industries. The company uses Microsoft Windows throughout the organization, is a heavy user of Microsoft SQL Server as well as Oracle and has adopted many of the Microsoft productivity tools -- including SQL Server Integration Services (SSIS).
American Tower is satisfied with SSIS overall, but recently recognized that it could not meet all of the data loading performance or complex data transformations required for their data warehouse application. For example, it took SSIS several hours to load 200 GB of data into the SQL Server data warehouse, in part because the target database was forced to execute lengthy stored procedures to transform the data before landing it.
As a result, American Tower began evaluating ETL / data integration tools from other vendors, but like many medium-sized businesses, the company had a limited budget for new IT solutions. This eliminated vendors with offerings whose price tags reached into the hundreds of thousands of dollars - such as Informatica - and quickly narrowed down the field to the affordable expressor semantic data integration system.
In a rigorous proof of concept test, expressor significantly reduced American Tower's data loading times. In addition, expressor's ultrafast parallel data processing engine and its flexible datascript scripting language enabled expressor to perform the required complex data transformations in a single process.
Other factors that convinced American Tower to migrate its data warehouse application to expressor included:
- the ability of expressor's smart semantics to create a common set of business definitions from disparate data sources and definitions
- the fact that expressor is built on an enterprise-wide metadata repository
- the fact that expressor's tool set is built around Microsoft Office and .Net, which made it easy for the company to get up to speed and fit expressor into their existing IT environment.
American Tower's experience shows that expressor is an excellent fit for any business seeking to upgrade to a true enterprise-class, Microsoft-friendly ETL / DI solution for their ever-growing data volumes and complex data integration requirements.
Michael Waclawiczek, VP Marketing
Posted by expressor software at October 29, 2009 2:45 PM
Twitter 
LinkedIn 
YouTube