Migrating your legacy ETL pipelines to run in the cloud – automatically

For data warehouse migration projects, companies are already faced with an array of complex questions, tasks and decisions to address. Where will I migrate to? How do I jump-start the migration effort?  How long will this take, and how long will this cost?

For companies reliant on third-party ETL tools, another question comes up – what do I do with my legacy ETL pipelines?

Extract, Transform, and Load (ETL) code has been the way developers move and prepare data from one or more sources for years. When looking at the day-to-day workings of any large enterprise, you will find 10s or 100s of thousand ETL pipelines behind the scenes that represent the glue of how information flows.

Writing ETL code is relatively simple. Plus, it’s useful in answering almost any business question (i.e. Are my sales up or down? What’s the trends with service calls? How are different manager’s spending vs budget? Etc.). With the proliferation of commercial and open-source tools available, it’s no wonder why most companies have created a large inventory of ETL pipelines.

The issue is, when migrating from an on-premise data warehouse to a cloud-native equivalent, it’s difficult to simply unplug and repoint legacy ETL pipelines.

For one thing, commercial ETL vendors don’t have an easy button. Companies are blocked in their data warehouse to cloud migration efforts when stuck on older versions of their tools – be it Informatica, DataStage, or others. While some of these vendors offer modern, cloud-based ETL versions, companies do not want to increase the risk of their migration projects by including an ETL version upgrade at the same time. So, what’s the best solution?

ETL Migration to the cloud

First, we leverage SHIFT™ CRAWLER to automatically scan the vast inventory of legacy ETL pipelines to uncover the lineage and source-to-target data flow to find out:

By defining the lineage and inventory of all in-scope pipelines, we provide customers with quick, actionable insights to plan their migration path to the cloud, without risk of impacting business operations or other dependant systems.

Plan &


Then, we leverage SHIFT™ TRANSLATOR  to translate all of the legacy ETL code to run natively against the cloud target. Specifically, SHIFT™ TRANSLATOR will automatically:

By automating this process, the SHIFT™ Migration Suite provides customers with an end-to-end automated solution to get legacy ETL pipelines running on the cloud fast, efficiently, and without impacting current business processes.

Learn more about end-to-end automated solution to get legacy ETL pipelines running on the cloud fast

Receive a complimentary Analyzer Report