introduction
Raven 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.
Supported Data Warehouse Sources
Supported ETL
Supported Target Cloud
features raven 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 statement and clauses
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
here’s how raven works
FAQs
What are the benefits of using Raven?
Raven can save upto 60-70% of redundant code conversion time and cost. It reduces the error and risk involved in manual conversion
What type of codes does Raven Support?
Raven supports complex SQL including Stored Procedures, Bteq, incomplete SQL statements code, embedded SQL, DDLs, Macros and Views definition, various ETLs codes and other types of codes that are required to translate during the cloud migration process.