United RentalsUnited Rentals

United Rentals, Inc. is the largest equipment rental company in the world, with an integrated network of 1,029 rental locations in 49 states and every Canadian province. The company’s approximately 14,900 employees serve construction and industrial customers, utilities, municipalities, homeowners and others.


The challenge

United Rentals was using IBM InfoSphere to support ELT (extract, load and transfer) by loading data into a landing area where stored procedures were written, which then loaded the data into a Teradata data warehouse. These initial data warehouse development efforts, while successful, proved too expensive and cumbersome.

The company was also experiencing performance issues with its legacy system, which provided summarized cubes (instead of transaction-level data). Hundreds of the cubes were not integrated.

As the company’s data volumes grew, its Teradata data warehouse was increasingly critical to providing timely data analysis and reports. The rental giant knew it needed to improve its current analytics and reporting capabilities as well as introduce automation that would eliminate much of the labor-intensive hand-coding of its Teradata enterprise data warehouse. 


The solution

United Rentals selected WhereScape® automation for Teradata to automate the development, deployment and operation of the company’s Teradata data warehouse. Using WhereScape’s rapid prototyping capabilities and an iterative process, United Rentals can quickly understand its data, align with business users and deliver data warehouse solutions more rapidly.  


The results

With optimized code automatically and consistently generated by WhereScape RED, United Rental has experienced enhanced performance of its Teradata data warehouse. The rental company also appreciates that WhereScape RED® automatically produces metadata-based documentation for end users and technical staff. Finally, the company is seeing 75 to 80% productivity gains from its automated, repeatable, and documented data warehouse development environment.

United Rentals

We estimate the development lifecycle is 20-25% of what it was previously when we were hand coding.

– United Rentals, Inc.