Reduce overall migration efforts and improve time to market for data modernization from legacy system to cloud

In legacy data analytics platforms, data sourced from enterprise applications, like those in finance, marketing, and logistics, were mostly confined to structured data. As data sources became varied, however, data volume increased multi-fold and need for velocity increased drastically. Data-platform modernization is now highly desired to get maximum insight from data produced all around the enterprise. But migration from a traditional, expensive data storage platform to a modern, real-time data analytics platform within a timely manner brings lot of challenges.

HCLTech’s ADvantage Migrate is a one-stop solution that helps enterprises modernize their entire data and analytics landscape. The solution assists in unified analytics and governance, amplified human output, and faster business outcomes by leveraging automation with the following pre-engineered products.
Gateway Suite: A web-based application deployed on AWS is designed to automatically scan source and target tables, transformation rules, and related metadata. It extracts logic from existing extract-transform-load (ETL) or data pipeline jobs, and catalogs the ETL jobs based on the associated source and target tables. It also does the conversion from legacy database scripts to modern data warehouses.
Sketch: A web-based, rapid-data, pipeline-development and deployment application runs on top of Apache Spark, deployed on AWS, accelerates data availability and accessibility. It provides different types of Sketch recipes to capture, curate, prepare, and distribute data with pre-built data-pipeline patterns covering around 80% data-pipeline requirements. It is based on configuration with a rich standard functional library to support most of scenarios.
Gatekeeper: A web-based application deployed on AWS for automated data testing. Achieve zero touch automated data reconciliation and continuous testing post-migration. Gatekeeper offers extensive coverage of testing scenarios.
ADvantage Migrate for Application Databases is a version of the solution catering to modernization of application databases. It addresses specific aspects of moving OLTP databases to the cloud, such as complex data dependencies, integrations with and dependencies on multiple systems, data migration strategies for lean downtimes or zero downtimes, and treatment of business logic in database code. Hence the pre-engineered products are also available tailored to these aspects: DBmGateway is a module of Gateway Suite for accelerating database conversion and Sketch Lite is a version of Sketch that runs on JVMs, more suited for migrating lower volumes of data that require simple data transformations or validations.

AWS Partner Network | Competency


Australia, Austria, Belgium, Brazil, Canada, Denmark, Finland, France, Germany, India, Ireland, Italy, Japan, Jordan, Luxembourg, Netherlands, New Zealand, Portugal, Poland, Saudi Arabia, Singapore, South Africa, Spain, Sweden, Switzerland, United Arab Emirates, United Kingdom, United States


Accelerated Data Modernization

Reduce effort by 40% and improve time to market for data modernization solutions


Minimize cost and reduce complexity by migrating to a consumable and steady system


ETL Modernization

Modernize data-processing (ETL) tools and processes

Reporting and Analytics

Modernize business intelligence (BI) tools and reports

Application Database Modernization

Modernize application databases to the right-fit database on the cloud

  • How it works
  • With the growing need to reduce infrastructure costs, and access flexibility and elasticity to scale the IT systems, data modernization initiatives can prove to be a game changer for enterprises. It can help streamline existing operations, respond effectively to changing market landscapes, provide personalized services, and even generate new revenue streams.
  • Key activities
  • 1) Sketch: Apache Tomcat server and MongoDB

    Provision and set up Apache Tomcat (Tomcat) web server and MongoDB to install Sketch UI

    2) Sketch: Set up SPARK Cluster

    Provision spark cluster as per data volume, and install Sketch config file and libraries on AWS

    3) Sketch: UI triggers CI/CD process

    Sketch UI needs access to AWS CI/CD services to generate pipeline for ingest, curate, and load, using Apache Spark

    4) Gateway Suite: Pre-requisites Setup

    Set up metadata on MySql DB, Tomcat , GIT, and Jenkins on AWS

    5) Gateway Suite: Setup and configuration

    Generate metadata master tables, place application properties file in Tomcat, and enable code versioning repository

    6) Gateway Suite: Get started

    Create admin and other users, and start Gateway web UI, mapping manager, ETL and DB code

  • Customer contribution
  • AWS account

    AWS account to deploy and configure the ADvantage Migrate platform

    Identity and access

    Customer to provide access with adequate permissions to run the tools on their environment

    Final signoff

    Customer to verify solution by generating data-analytics pipelines; signoff to be provided post-implementation

  • About this consultant
  • HCL Technologies is a next-generation global technology company that helps enterprises reimagine their business for the digital age. HCL technology products and services are built on extensive experience with innovation, a strong culture of invention and risk-taking, and a relentless focus on customer relationships. HCLTech also takes pride in its many diversity, social responsibility, sustainability, and education initiatives. Through its worldwide network of R&D facilities and co-innovation labs, global delivery capabilities, and over 176,000+ ‘Ideapreneurs’ across 50 countries, HCLTech delivers holistic services across industry verticals to leading enterprises, including 250 of the Fortune 500 and 650 of the Global 2000.
    Enterprises across industries stand at an inflection point today. In order to thrive in the digital age, technologies such as analytics, cloud, IoT, and automation occupy center stage. In order to offer enterprises the maximum benefit of these technologies to further their business objectives, HCLTech offers an integrated portfolio of products and services through three business units. These are IT and Business Services (ITBS), Engineering and R&D Services (ERS), and Products and Platforms (P&P).
    ITBS enables global enterprises to transform their businesses via the following:
    • Digital Foundation, a modernized infrastructure stack built around hybrid cloud, software-defined networks, the digital workplace, and other elements; 
    • Digital Business, a combination of application services and consulting capabilities; and 
    • Digital Operations, a three-pronged setup for modernized and efficient operations at the enterprise level.
  • Architecture diagram

AWS Partner Highlights

HCL Technology’s AWS validated qualifications, customer references, and office locations.

AWS Migration Competency Details

HCL Technology has demonstrated deep AWS technical expertise and proven customer success.

Explore icon
Explore all Consulting Offers

Browse our portfolio of Consulting Offers to get AWS verified help with solution deployment.

Learn more 
Build icon
Deploy a solution yourself

Browse our library of AWS self-deploy solutions to common architectural problems.

Learn more 
Find an APN Partner icon
Find an AWS Partner

Engage with AWS Partners for secure, innovative, and cost-effective custom solutions that leverage the power and scalability of AWS services to meet your needs.

Learn more