A leading Chemical manufacturer had different databases and needed a central source of truth. Collating business intelligence reports from different databases was challenging and time-consuming. The client also wanted to decrease hardware maintenance costs and wanted to add a disaster recovery environment.
Y&L Development:
- Implemented SAP BW on HANA platform and hosted it on the AWS cloud.
- Performed hardware sizing for hosting the solution on the cloud.
- Collated the information from Oracle and MS sequel serer databases into a Business Warehouse on HANA data lake.
- Set up disaster recovery with SAP certified AWS instance using SAP HANA DB tool.
- AWS Infrastructure monitoring was done using AWS CouldWatch.
Results:
- 90% reduction in report generation time.
- 26% decrease in total cost of operations with a could solution.
- 55% lesser costs due to cloud disaster recovery set-up.
- Ensured high availability with automated back-up and disaster recovery system.