Real-time migration from on-premise to cloud

Home » Case Studies » Application Services » Real-time migration from on-premise to cloud

Real-time migration from on-premise to cloud

Case Studies

Client Overview

A leader in operating a global network of multipurpose liner and dry bulk services and providing bulk logistics solutions

Business Challenge

  • Enable real-time data migration from on-premise data centre to AWS (cloud environment data lake)

  • Build datamart over data lake leveraging complex transformation logic to make the resultant data instantly available for the end user

Business Solution

  • Data load scenarios covering:

    • Source – RDBMS Data load through transformation
    • Web-service – Data load through transformation with Lambda
  • Set up AWS Services (DMS, RDS, Glue Lambda) and verified data load

  • Configured S3 Bucket and Redshift

  • Facilitated creation of target tables & views

  • Leveraged transformation logic using Glue

Business Benefits

  • Achieved real-time data migration from on-premise to cloud environment (data lake)

  • Instant end user access to data

Environment

  • Amazon S3, Amazon DMS, Amazon RDS, AWS Glue, AWS Lambda, Amazon Redshift, Python/Scala/Java, SparkSQL, AWS API Gateway

2020-04-24T13:03:05+05:30
Go to Top