Navo Jet

Introduction

Navo Jet automatically converts code workloads (SQL, ETL, Scripts) of the on-prem system – Teradata, Netezza, Oracle, etc to the cloud-native technologies – Google BigQuery, Azure Synapse, Snowflake, AWS Redshift during the cloud migration process.

It rapidly transforms codes of diverse length and complexities within minutes and also optimizes them to save execution time and cost.

https://navoinfo.com/wp-content/uploads/2022/12/jet-fighter-plane-flying-illustration_183875-783-640x320.webp

Features eagle leverages

Automated SQL & ETL Conversion

Lineage Aware Data Model

Support non-ANSI compliant constructs, function & clauses

SQL, expression and workflow Optimizations

Smart emulations for incomplete SQL

SQL Code Translation

Automated Translation of complex SQL codes and scripts
Smart emulations for unsupported or deficient SQL clauses in the target SQL-like language
Capability to convert embedded SQL, incomplete SQL statements, and heavily parameterized SQL code
Translation support for Database specific utilities like Load-Store Utility, Bteq, Macros, Stored Procedures.
Support for DDL definitions of various objects such as macros, stored procedures, view definitions, utility materialized view definitions etc.

ETL/ELT conversion

Converts the ETL into ELT based scripting as per target cloud environment
Support for custom expression written in ETL
Capable of converting Non-SQL components in ETL workflows
Numerous polyfills for unsupported functions

Code Optimization

Consistency and syntactically optimized generated code and scripts
Cost and Time savings due to SQL, expression, workflow and target-aware optimizations.
Complete data lineage awareness during code conversion
Removes redundancy across jobs

Value proposition

Accuracy with consistent formatting

Reduced cloud migration time, costs, and efficiency

Reduced errors in translated codes

Investing time & resources in critical parts of migration