How Oldcastle Built Real-Time ERP Analytics with AWS

In this video, we explore how Oldcastle APG, one of North America's largest suppliers of construction materials, transformed their enterprise analytics and AI capabilities. When migrating from on-premises systems to Infor Cloud ERP on AWS, Oldcastle faced a critical challenge: maintaining complex, real-time operational reporting for hundreds of users across their finance, customer service, logistics, and manufacturing teams. Discover how Oldcastle collaborated with AWS Solutions Architects to build a scalable, real-time data streaming architecture that seamlessly integrates Infor ERP with AWS native services. *Key Technologies & Architecture Highlights:* *Infor Data Fabric Stream Pipelines:* Captures and processes data events instantly upon data modification without waiting for batch processing. *Amazon Aurora PostgreSQL:* Provides highly available, multi-AZ data storage for incoming operational streaming data. *Amazon RDS Proxy & Network Load Balancers:* Manages database connection pooling, load distribution, and automatic failovers to handle high-frequency streaming. *Amazon QuickSight:* Powers interactive, pixel-perfect dashboards with SPICE caching to deliver subsecond response times on massive datasets. *Amazon API Gateway:* Securely embeds QuickSight analytics directly into the Infor OS so users never have to switch systems. *The Impact:* By eliminating the delays of traditional batch reporting, Oldcastle deployed over 50 complex dashboards in just eight months. Today, the architecture efficiently processes millions of transactions daily and supports over 100 concurrent users without performance degradation, giving decision-makers immediate visibility into business operations. Read the full deep-dive on the AWS Architecture Blog: [Real-time analytics: Oldcastle integrates Infor with Amazon Aurora and Amazon Quick Sight](https://aws.amazon.com/blogs/architec....