Oldcastle's Real-Time ERP Analytics on AWS Aurora & QuickSight

Bridging ERP Data to Real-Time Insights

The article presents a compelling case study of Oldcastle successfully overcoming the limitations of traditional cloud ERP reporting by integrating Infor with Amazon Aurora and Amazon QuickSight. The key innovation lies in leveraging Infor Data Fabric Stream Pipelines for real-time data ingestion, minimizing latency and enabling immediate operational visibility. The architecture's robust design, including the use of NLB, RDS Proxy, and Aurora's PostgreSQL compatibility with JSONB support, demonstrates a sophisticated approach to handling high-frequency streaming data and complex analytics. The seamless integration of QuickSight dashboards within the Infor OS via API Gateway offers a prime example of enhancing user experience by keeping analytics within familiar workflows, a critical factor for adoption in enterprise environments. The emphasis on scalability, high availability (Multi-AZ Aurora), and security further solidifies its enterprise-grade nature.

However, while the article highlights the benefits, a deeper dive into the specific challenges encountered during the configuration of Infor Data Fabric Stream Pipelines and the RDS router setup would have been beneficial for readers facing similar integration complexities. The cost implications of maintaining such a real-time streaming architecture, especially with high transaction volumes, are not explicitly detailed, which is a crucial consideration for businesses evaluating similar solutions. Additionally, while demand forecasting and ML capabilities are mentioned as future possibilities enabled by this architecture, the article focuses primarily on the data streaming and visualization aspects. Expanding on the initial steps or a pilot for AI/ML integration would have provided a more complete picture of the 'AI capabilities' aspect mentioned in the introduction. The reliance on Infor-specific features like Data Fabric Stream Pipelines also means that the direct applicability of this exact blueprint to non-Infor ERP systems might require significant adaptation, though the underlying AWS principles remain transferable.

Key Points

• Oldcastle integrated Infor Cloud ERP with AWS services (Amazon Aurora, Amazon QuickSight) to achieve real-time operational reporting.
• Key challenge: Traditional cloud ERP reporting limitations hindering real-time data access and complex analysis.
• Solution: Leveraged Infor Data Fabric Stream Pipelines for real-time data ingestion, minimizing latency.
• Architecture utilizes Amazon Aurora PostgreSQL for data storage, RDS Proxy for connection management, and ELB for secure Infor connectivity.
• Amazon QuickSight provides interactive dashboards and pixel-perfect reports, embedded within Infor OS via API Gateway for a seamless user experience.
• Achieved over 50 complex dashboards in 8 months, enabling faster data-driven decision-making and improved business processes.
• Architecture supports over 100 concurrent users processing millions of transactions daily with high availability and scalability.

---

📖 Source: Real-time analytics: Oldcastle integrates Infor with Amazon Aurora and Amazon Quick Sight