Example migration journey · Insurance

IBM Netezza and DataStage to Databricks for an insurer

An end-of-life appliance and hundreds of DataStage jobs feeding actuarial and claims reporting.

Cover illustration: IBM Netezza and DataStage to Databricks for an insurer

Example journey. This page shows how we run this type of migration. It is not a named client result. References from comparable projects are available on request.

In brief

This example journey shows how we would move an insurer from IBM Netezza and DataStage to Databricks: catalogue and rank workloads, convert SQL and procedures, rebuild DataStage jobs as tested pipelines, reconcile actuarial and claims reports, then add claims document AI.

TypeExample migration journey
IndustryInsurance
MigrationIBM
TechnologiesLakeBridge, Lakeflow Declarative Pipelines, Agent Bricks, Unity Catalog

Starting point

An insurer runs its warehouse on IBM Netezza with DataStage ETL. The appliance is reaching end of life, licences are costly, and adding claims document AI is not practical on the current stack.

How we would approach it

  • Assess: catalogue Netezza objects and DataStage jobs, and rank them by business value.
  • Convert: convert SQL and stored procedures, and rebuild DataStage jobs as tested declarative pipelines.
  • Reconcile: validate actuarial and claims reports with finance and actuarial owners.
  • Extend: once migrated, add claims document extraction with Agent Bricks on the same platform.

Value the insurer should expect

  • Exit from appliance renewal and ETL licence costs.
  • Pipelines as code, with version control and tests.
  • A direct path to claims triage and document AI.

What to measure

Licence and infrastructure cost, job failure rates, time to change a pipeline, and claims-reporting freshness.

Read the full IBM Netezza, Db2 and DataStage to Databricks guide →

FAQ

Frequently asked questions

Is this a real client project?

It is an example journey that shows our method. References from comparable projects are available on request.

Can Cognos stay in place?

Yes. Cognos can connect to Databricks SQL during and after the migration.

More migration journeys