Case Study: SM Retail achieves 400-500% faster data availability with Attunity Replicate

SM Retail Achieves 400 – 500% Improvement in Data Availability with Vertica and Attunity Replicate

SM Retail, the leading department store group in the Philippines, needed faster, more reliable reporting and ETL performance to support daily inventory and sales analysis. Its previous enterprise data warehouse could not meet SLAs, with critical reports often arriving after 11 a.m. or never finishing, limiting timely decision-making. SM Retail used Attunity Replicate alongside Vertica and Manthan Systems to modernize its analytics environment.

Attunity Replicate automated real-time data extraction and loading into Vertica, dramatically improving data availability and usability. The result was a 400–500% improvement in data availability, report completion times dropping from 6–8 hours to under 30 minutes, and some reports shrinking from minutes to seconds. SM Retail also gained earlier access to inventory KPIs and faster analytics, with retail-specific ETL running 100 times faster.

SM Retail

Stephen Yap

Senior Vice President of Information Technology Services