United Rentals was looking to improve its current analytics and reporting capabilities as well as introduce new functionality that would eliminate much of the labor-intensive hand-coding of its Teradata enterprise data warehouse. In addition United Rentals was starting to experience performance issues with its legacy system which provided summarized cubes, not transaction level data, and hundreds of cubes were not integrated.
United Rentals started its development process with IBM InfoSphere to support its ELT (extract, load and transfer) processes. The company loaded data into a landing area where stored procedures were written to load the data into Teradata. Our initial data warehouse development efforts, while successful, proved too expensive and cumbersome.
As our data volumes grew, our Teradata data warehouse was increasingly critical in providing timely data analysis and reports. United Rentals selected WhereScape RED to ensure the structure of our data continues to meet our evolving business needs.
WhereScape’s automated rapid prototyping and iterative process enables us to quickly understand our data, get aligned with our business users, and build our Teradata data warehouse more rapidly. WhereScape’s architecture and automation features enhance the underlying performance of Teradata to consistently develop optimized ELT code with ease, with the added benefit of metadata-based documentation automatically produced for our end-users and technical staff. We are delighted with the productivity afforded by WhereScape RED, and the more automated, repeatable and documented development environment it supports.
United Rentals, Inc. is the largest equipment rental company in the world, with an integrated network of over 580 rental locations in 48 states, 10 Canadian provinces and Mexico. The company’s approximately 8,600 employees serve construction and industrial customers, utilities, municipalities, homeowners and others. The company offers for rent approximately 2,700 classes of equipment with a total original cost of $3.8 billion. United Rentals is a member of the Standard & Poor’s MidCap 400 Index and the Russell 2000 Index® and is headquartered in Greenwich, Conn, USA.
We estimate the development lifecycle is 20-25% of what it was previously when we were hand coding.