The UK's oldest automotive association, RAC provides more than 7 million members with a comprehensive range of services, from roadside assistance to financing, insurance, and travel information. To protect its century-old brand and improve its services, RAC wanted to integrate all of its customer data in a single database.

Challenges

  • Consolidate information from 14 different data sources
  • Create a single, integrated view of customer relationships
  • Give end users right-time access to data without IT intervention
Informatica's PowerCenter ETL tool has been a technological cornerstone of RAC's Data Warehouse project; it has provided efficient extraction of disparate data sources, the application of complex business rules in the transformation mappings, and highly performant loading of the transformed data into the target database.
— Andrew Urbanski
Data Architect
RAC

Results

  • Shortened reporting time from days to minutes
  • Raised travel insurance renewal rate from 5% to 25%
  • Targeted cross-sell and upsell opportunities more accurately
  • Improved customer service for competitive advantage

Technologies Used

  • Accesses, integrates, and delivers any and all data quickly and cost-effectively, without hand coding.