InsightWorker Logo
  • contact@verticalserve.com

AWS → OCI Migration (DAGs · Stored Procs · DDLs)

Translate Airflow + Redshift to Oracle ADW + OCI Object Storage with mapping rules and a change report.

← All use cases
Migration
Insurance, Banking, Healthcare migrations
AirflowRedshiftOracle ADWOCI

The problem

  • Hand-rewrite each operator (S3 → OCI, Redshift → Oracle SQL, etc).
  • Manually port stored procedures — types, functions, dialect quirks.
  • Re-author CREATE TABLE DDLs with Oracle types and tablespaces.
  • Spreadsheet-tracked diff sessions to find drift between source and target.
  • Days-to-weeks per DAG family, brittle, reviewer-heavy.

How InsightWorker handles it

1
Scaffold an app with /app create — generates scope, plan, mappings, input/, output/. /app create
2
dag-migration-compare skill applies operator + type mappings to every DAG file. dag-migration-compare skill
3
Translate DAG factory configs, variables.json, DDLs, and stored procedures. filesystem · oracle
4
Generate change_report.md — every line of drift accounted for. edit_file · git_diff
5
MODE 1 fresh-convert · MODE 2 detect-and-sync ongoing changes from source. git_status · file watch

Screenshots

Redshift DAG and stored procedure inputs loaded for translation

Redshift DAG and stored procedure inputs loaded — InsightWorker begins parsing the source schema and task graph.

User specifies DDL conversion scope and target Oracle ADW dialect

User specifies the DDL conversion scope, mapping rules, and target Oracle ADW dialect before translation begins.

Data type mapping applied across Redshift to Oracle conversion

Data type mapping applied — Redshift-specific types resolved to Oracle ADW equivalents with the full conversion delta logged.

Translated Oracle ADW DDL and stored procedures with change report

Translated Oracle ADW DDL and stored procedures delivered with a complete change report ready for review and sign-off.

Sample prompt

"Convert this Redshift Airflow DAG and its 14 stored procedures to Oracle ADW on OCI."
Deliverables: dag_code/ · variables_updated.json · stored_procs/ · table_ddls/ · mappings/ · change_report.md
Prefer the browser?
Run this in InsightStudio — no CLI install for the user.

Authors publish the app once with iw app publish; business users open it in the marketplace and click Run. Your worker box does the execution.

Visit InsightStudio →

Try this use case yourself

Free trial available — CLI, Desktop, VS Code, and the new --worker mode for InsightStudio. See download for details.

Download Free Trial