• Utham Kumar Anugula Sethupathy

The transition to omni-channel retailing has driven a critical need for real-time data synchronization, cross-channel inventory visibility, and dynamic analytics. However, many large-scale retailers continue to rely on legacy enterprise resource planning (ERP) systems—such as SAP ECC and Oracle E-Business Suite—that are inherently ill-equipped for real-time data exchange and modern analytics integration. This paper presents a comprehensive industry case study from early 2019 that demonstrates how a North American retailer integrated its legacy ERP system with cloud-native analytics platforms to enable unified, near-real-time retail operations. The study explores a hybrid architecture comprising ETL pipelines, change data capture streams, and Azure-based data lake and visualization layers. Integration patterns leveraged include nightly batch exports for historical data and Apache Kafka streams for inventory deltas and event-based updates. Microsoft Power BI dashboards provided multi-tier visibility into product availability, stock movement, and store-level KPIs. The implementation supported over 10 million daily records and achieved a 75% reduction in inventory data latency, 40% reduction in stockout incidents, and a 90% improvement in data-driven decision-making across operations and merchandising. This paper contributes to the limited corpus of real-world ERP modernization literature within the retail sector. It offers practical guidance for integrating legacy systems with next-generation analytics tools without requiring full ERP replacement. Lessons learned from this deployment are applicable to IT and transformation leaders in retail and adjacent industries undertaking similar modernization efforts in the face of aging system architectures.

ERP modernization; SAP ECC integration; Power BI; Azure Data Lake; Apache Kafka; omni-channel retail; retail analytics; data lakes; inventory visibility; legacy systems; change data capture (CDC); cloud-native analytics; real-time dashboards; hybrid integration architecture; enterprise data platforms.

"Integrating Legacy ERP with Modern Analytics for Omni-Channel Retail Management", International Journal of Emerging Technologies and Innovative Research (www.jetir.org), ISSN:2349-5162, Vol.6, Issue 9, page no.357-368, September 2019, Available :http://www.jetir.org/papers/JETIR1912290.pdf

"Integrating Legacy ERP with Modern Analytics for Omni-Channel Retail Management", International Journal of Emerging Technologies and Innovative Research (www.jetir.org | UGC and issn Approved), ISSN:2349-5162, Vol.6, Issue 9, page no. pp357-368, September 2019, Available at : http://www.jetir.org/papers/JETIR1912290.pdf