Use Cases

The migrations enterprise data teams ship with OpenOntos.

Each wedge is pre-modelled in the planner. Pick one, point it at your real source, and review the artifacts.

Oracle→Snowflake

Finance warehouse to Snowflake

Ontology entities

CustomerAccountOrderInvoicePayment

Generated: Bronze + Silver SCD2 + Gold marts (ar_aging, payment_velocity), Airflow DAG.

Discuss this wedge
SQL Server→Microsoft Fabric

Operational store to Lakehouse

Ontology entities

ProductInventoryShipmentReturn

Generated: OneLake shortcuts, Lakehouse SQL endpoints, Fabric pipelines, Direct Lake gold.

Discuss this wedge
Teradata→BigQuery

Decommission Teradata

Ontology entities

Customer 360CampaignTouchpointConversion

Generated: Partitioned + clustered Gold, BQX, INFORMATION_SCHEMA reconciliation, Composer DAG.

Discuss this wedge
SAP ECC→Databricks

SAP modules to Lakehouse

Ontology entities

VBAKVBAPKNA1MARA

Generated: Delta Bronze with CDC, Unity Catalog grants, PySpark Silver, Workflows DAG.

Discuss this wedge
Informatica / SSIS→Modern lakehouse

Retire legacy ETL

Ontology entities

Mappings inventoryLineageSchedules

Generated: Workflows imported, ontology re-derived, native code re-emitted on chosen target.

Discuss this wedge
On-prem warehouse→Cloud + reconciliation

Cloud lift with parity proof

Ontology entities

Source-of-truth tablesAggregatesReports

Generated: Per-batch row count + checksum + key aggregate reconciliation, AI Health Analysis.

Discuss this wedge