Next Pathway Extends Capabilities of SHIFT

The capabilities of Next Pathway Inc.'s automated code translation tool, SHIFTTM Translator, have been extended to tackle the most difficult component of a cloud migration - translating complicated ETLs (extract, transform, load) to execute in cloud native settings.

SHIFTTM Translator, which is part of the SHIFTTM Migration Suite, automates the translation of complex workloads to the cloud, including SQL, Stored Procedures, ETL, and other code types from a variety of older source and target platforms. All code types, including ETL, DDL/DML, Views/Materialized Views, Stored Procedures, Dynamic SQL, Embedded SQL, Scripting Frameworks, Proprietary Functions, and more, can benefit from its syntax and semantic-based translation capability.

Complex ETL workflows have been substantially invested in by businesses. These institutional assets may be preserved and modernized while transporting old data warehouses and data lakes to the chosen cloud target, such as Snowpark, AWS Glue Studio, and Azure Data Factory, using the latest release of SHIFT Translator. Companies can also free themselves from costly, rigid ETL license schemes that don't adapt charges depending on usage and limit computational horsepower.

Complexity has been handled.

ETLs are data integration pipelines that aggregate data from various sources into a single database. They're necessary for driving analytics and AI modeling, as well as making data more interesting and actionable.

When migrating old data warehouses and data lakes to the cloud, these ETLs create particular issues because they don't run natively in the cloud.

Next Pathway and SHIFT Translator perform their magic here. The code, including complicated ETLs, may be instantly translated to run in native cloud settings thanks to Next Pathway's breakthrough technology. The SHIFT Translator engine's increased capabilities preserve all of the years of code in these old ETLs and relocate the logic to the cloud.

Snowpark, Snowflake's developer tool for information management chores; Azure Data Factory (ADF), Microsoft's data integration service; and Amazon Glue, AWS' data integration service are all supported by Next Pathway.

Informatica Power Center, IBM DataStage, Microsoft SSIS, and Talend Data Fabric are examples of legacy ETLs that may now be smoothly migrated to a cloud-native destination and maintained and extended.

SHIFT Translator facilitates a fundamental shift from the ETL approach – which is emblematic of legacy, on-premise systems – to an ELT (extract, load, transform) model, which fully utilizes the cloud's boundless computation and transformational capabilities.

All data — structured, unstructured, or semi-structured — can be efficiently and cost-effectively extracted and loaded into block storage in the cloud destination using cloud-based solutions. Organizations can then manipulate the data without restriction, provisioning and executing transformations and analytics. With the data integration features of their selected cloud target platform, they can manage their data flow and pipelines.

There's no need to rewrite or repoint ETLs any longer. Instead, firms can free themselves from costly old ETL contracts and go to the cloud.

Unlike its rivals, who provide manual services to rewrite or repoint current ETLs to the cloud target, Next Pathway deconstructs the foundation of each ETL, regardless of vendor, and automatically converts the ETL logic to function in cloud-native environments.

Organizations are aware of the difficulties in converting complicated ETLs to the cloud. Leaders reported their two main worries in Next Pathway's Q1 2022 poll are moving current ETL processes to new cloud-native ELT tools and the need for automation to migrate ETL jobs to the cloud.

SHIFT Translator, the latest release from Next Pathway, overcomes both of these issues.