ETL migration

{openAudit} automates the analysis of legacy ETL platforms to prepare their modernization (reverse engineering), starting by identifying real usage. Dependencies, business rules, and transformations are then automatically reconstructed in SQL, before conversion to modern technologies.

Two destinations for the generated SQL

Market platforms. The generated SQL is compatible with modern databases (BigQuery, Azure SQL) or with dbt and equivalents.

An open SQL ETL. The converted processes can also be run in {oa-tbx}, an open SQL ETL orchestrated by Airflow, the leading open source scheduler.

Discover migration to an open SQL ETL →

To go further

Discover our technical articles on ETL migration: DataStage, Talend, Informatica, SSIS, dbt, SQL…