Database Migration to Cloud Platform

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.
210-340-0098

5750 Epsilon

San Antonio, Texas 78249

STAY CONNECTED

Copyright © . Y&L Consulting. Inc.
All Rights Reserved.

Privacy | Terms of Service
Copyright . Y&L Consulting. Inc. All Rights Reserved.
Privacy | Terms of Service