Case Study: a leading national retailer modernizes data migration and accelerates ETL with rSTAR and Google BigQuery

a leading national retailer completes BigQuery migration 50% faster with rSTAR

The customer, a leading national retailer, faced a significant challenge when vendor support for its 25-year-old Sailfish data warehouse was ending. They needed to quickly migrate massive volumes of human resources, supply chain, and financial data to a modern platform despite having lost critical data maps and documentation due to years of system changes and staff turnover. The retailer partnered with vendor rSTAR to undertake this complex migration using Google BigQuery.

rSTAR used its Accelerators for Data Migration and Modernization to reverse engineer the entire legacy system, mapping thousands of tables, views, and scripts. This solution streamlined 90% of the schema, ETL, and data migration tasks, modernizing processes for cloud compatibility. The migration was completed 50% faster than estimated by other vendors, resulting in a powerful, scalable data backbone built for analytics and real-time reporting with minimal business disruption.