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


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


Contact Info

Saksoft Limited, SP Infocity, Block A, 2nd Floor, #40 Dr. MGR Salai, Kandanchavadi, Perungudi, Chennai - 600096, India

Phone: +91 44 2454 3500

Fax: +91 44 2454 3510


Go to Top