India’s Leading Logistics Company Migrated SAP Data Analytics Workloads on AWS to Improve Consignment Level Business Insights
Introduction
India’s Leading Logistics Company is an Indian courier delivery services company and it handles 12 million shipments every month. India’s Leading Logistics Company’s journey through the years has been full of milestones, growth and pushing the boundaries often. With many firsts to its credit, India’s Leading Logistics Company has constantly strived to not just grow as an organization but also set an industry benchmark.
Challenges
India’s Leading Logistics Company wanted to build SAP Data Analytics on AWS, since they were facing challenges mentioned below:
- SAP Hybris had limitations on generation of certain drill down reports
- Complex GUI Hybris model views and
- Consignment level data development require more hardware and licenses from SAP
- Complexity on maintenance and monitoring of the SAP
- Expensive Integration with different application to SAP HANA
Searce Solution
Searce conducted a Well-Architected Review of their Overall architecture that ensures that the overall architecture follows the Best Practices of the Industry which are also recommended by AWS. The Searce solution involved:
- Deployed Glue ETL pipelines to extract data from SAP BRIM/HANA and load into Redshift by using BODS
- Design DW schema as per AWS Redshift best practices to reduce the complexity
- Deployed transformation jobs to process data, created OLAP models for slice and dice of the data
- Integrated Redshift data with Tableau dashboards
- Provision to on-board new data-pipelines with few easy steps
- Converted SAP Hybris data model to Redshift compatible queries
Business Impact
The Searce solution enabled the organization to resolve their existing issues and boost their business with:
- Cost Savings: SAP Licensing & infrastructure cost saved
- Self Service Reporting: Automated revenue calculations using RedShift Snapshots to streamline month end closing
- Accelerate Response Times for granular view of shipment status
- Hours to Minutes: Drilldown data (Consignment level) gets populated on Tableau faster than SAP HANA. Drilldown query performance reduced from hours to minutes
- Near Real Time report for faster consumer resolution
The successful implementation of SAP data analytics on AWS, optimized resources and maximized cost savings by reducing licensing, maintenance and infrastructure costs of their SAP system. Additionally, analytics workloads are way faster than SAP systems for advanced businesses Intelligence queries which helped India’s Leading Logistics Company to get competitive advantage and drive better business outcomes.
Industry: Logistics
Workload: AWS Networking Components, Amazon S3, AWS Lambda, AWS Glue, Amazon Redshift
more case studies
Driving Logistics Innovation with Searce & Google Cloud
Yaantra partners with Searce & Google Cloud to help consumers with a single window stopover for smart gadgets in India
