Streamlining Manufacturing Reports
summary
Prototype consolidates on‑prem IBM Db2 per‑plant data (30–500 GB) into AWS using DMS to an Amazon Aurora Serverless v2 Postgres replica, then ingests into Amazon Redshift via federated queries with a Lambda triggered by EventBridge every five minutes. Data products are materialized views refreshed for analysts, visualized in Amazon QuickSight, and monitored with CloudWatch. Built during a four‑day AWS Data Lab Build Lab, the solution works for a single plant and is packaged to scale across 40 factories via the Digital Production Platform.
AI-written summary · about
chapters (6)
- 0:00Introduction and team
- 3:57Project background
- 11:19AWS Data Lab planning
- 18:51Architecture building phase
- 33:21Scaling across factories
- 38:45Q&A and summary
related talks
09mFrom Factory Floor to Cloud — Scaling Manufacturing Data on
43mData warehousing reinvented for today's needs
01h 01mData integration at scale: Strategies to unlock SAP and mainframe
28mTurn Data Into Insights
27mModernize Your Data Warehouse
10mBuilding a Data Platform at Assembly Payments
53mBusiness transformation through data and ML
52mResilient SAP side-by-side shop floor integration at Volkswagen