Automated Code/Schema Translation

Migrating to the cloud or modern data platforms doesn’t end with simply transferring the data.

In addition to large data volumes, companies have developed monolithic applications, queries and reporting pipelines within their legacy data warehouse solutions over time – all core to their business.

When considering migration, having to rebuild or rewrite these code elements manually leads to high costs, high risk, and delayed timelines, which often result in project failures. Further, the manual identification and migration of application code, including SQL, Stored Procedures, Orchestration/ETL logic and Schemas is complicated, painful, time-consuming and error-prone.

Making the shift to modern technologies should be easy, efficient, and fast.

Client Use Case

A large global retailer tasked Next Pathway to assist in migrating a legacy Teradata EDW environment to the cloud. The challenge? Figuring out how to rewrite the 8 million-plus lines of application code – including SQL, Stored Procedures and Schemas – to run in the next-gen cloud environment.

Next Pathway used SHIFT to automatically translate the 8 million lines of code to the cloud-native dialect, with an automation rate of 98%, in just 90 minutes. This accelerated the end to end migration timeline by 87%, and streamlined all testing and deployment activities along the way.

“Our organization needed a solution to efficiently handle migrating high volume EDW workloads to the cloud. Past efforts with manual translation and development only saw our costs soar, and timelines further delayed.

By automating the code migration piece with Next Pathway’s SHIFT, we saw resourcing and operational expenses reduce by at least 50%.”

— a global retailer

Benefits SHIFT™ offers over manual migration:









Simplify and Accelerate

Next Pathway’s patent-pending SHIFT™ EDW Code Translation Engine transforms your legacy warehouse workloads to an optimized version best suited for your target platform with speed, reliability, and no manual coding required.

It simplifies and accelerates the migration process by:

  • Automatically translating legacy SQL, Stored Procedures, Schema, Orchestration/ETL logic and other code to the equivalent dialect best suited for the target environment – be it Cloud, Big Data or other platform.
  • Syntactic and Semantic-based translation to achieve higher automation rates, and support for various procedural scripts and commands.
  • Assessing the legacy EDW environment and categorizing code elements by complexity, data type and other attributes.
  • Accelerating testing cycles through built-in data validation and unit testing
  • Integrating with any third-party testing and deployment frameworks

The SHIFT™ Migration Process

Shift Diagram

Fast. Reliable. Automated.

SHIFT™ replaces manual migration with powerful automation to accelerate the process, reduce the effort and save time. It provides:

Automation of code/schema translation up to 90%, drastically reducing your overhead costs and speeding up your migration project.

Removes the need for developers with knowledge of both source and target languages; finding good developers can be hard enough.

Continuous learning to improve automation. SHIFT™ learns as more code is run through the engine; increasing automation rates throughout your project.

Watch the video to learn more

Play Video
Download the SHIFT™ Brochure

Key Features

  • One-click migration
  • Developer UI to translate, review and deploy
  • Detailed migration reports for various project stages
  • Monitoring, data lineage, audit logs
  • Extensible, repeatable, verifiable
  • Data structure optimizations
  • Data quality transformations
  • Rules-based translation engine
  • Automated unit testing module


SHIFT™ currently supports the following:
Sources: Netezza, Teradata, Greenplum, DB2, MS SQL Server, SAP, Postgres, Stored Procedures, DataStage, Talend, Pentaho
Targets: Apache Hive, Spark Scala, Snowflake, BigQuery

Absolutely! SHIFT’s continuous learning functionality allows us to quickly add capabilities for other source and target systems. Please contact us to find out more.

SHIFT™ supports translation for SQL, but also stored procedures and common ETL tool languages.

No, in addition to migrating your code, SHIFT provides migration pipeline with automated unit testing and data quality assurance functionalities which streamlines your migration project end-to-end.

SHIFT™ is a tool that our consultants use to expedite migration-based engagements. However, license agreements are possible to allow for extended use of the tool by our clients.
Contact us to find out more.

Get in touch to discuss how SHIFT can accelerate your project