Client
A trusted global IT service provider with over 20 years of experience specializing in Infor Lawson and CloudSuite ERP systems.
Business Challenge
- Scalability limitations in the RDS Aurora database hindered APIX’s ability to support growing business needs.
- High operational costs associated with the existing RDS Aurora setup.
- Need for improved optimization of data management capabilities to enhance performance.
- Requirement to enable APIX to generate reports more effectively based on historical data
Approach
- Delivered a fully integrated AWS-native data and analytics platform for real-time decision-making and operational optimization.
- Designed the platform using AWS Well-Architected Framework principles to ensure a secure and robust data foundation.
- Built a scalable data lake using AWS Glue as the cornerstone for data integration and management.
- Migrated historical data from RDS Aurora tables to an S3 data lake using AWS Lake Formation, leveraging virtually limitless storage for cost-effective reporting and historical analysis.
- Maintained metadata in AWS Glue Catalog and enabled serverless, interactive querying of S3 data with AWS Athena.
- Replaced stored procedures with Athena Saved Queries to simplify maintenance, enable easier development and version control, and support flexible, SQL-based ad-hoc queries.
- Implemented AWS CloudWatch metrics for monitoring Glue jobs, Lambda functions, and network performance, with alerts for quick responses to latency and throughput issues.
Technology Components
Transformational Effects
- Reduced operational costs by 30% using AWS Lambda for serverless data processing
- Decreased data processing time by 40% using AWS Athena for faster insights.
- Saved licensing costs by migrating from RDS Oracle to an AWS-managed data lake.
- Achieved cost savings with AWS Lake Formation by eliminating complex ETL pipelines.
