Data warehouse migration
For IT and BI managers and CTOs at mid-size and large companies
Older data warehouses on Teradata, Vertica, Oracle (Exadata), Netezza or Informatica often cost a lot in licences and tie you to one vendor. We help you move to open tools you control, so you can change supplier when you want to.
We don't promise it will be free. Running costs, cloud and engineering still cost money, so we measure on your own data before talking about savings.
What a migration covers
A migration is more than copying tables. All of this has to move and work the same way afterwards:
- The data in the tables, with the dependencies between them.
- Loads and data pipelines (ETL).
- SQL: the logic that reports and other systems rely on.
- Access rights: who may see what.
- Response-time requirements, measured against your real workload.
How it works
- DiscoveryWe map what exists, how much data there is and what depends on what: tables, loads, dependencies, SQL, response-time requirements and licences.
- Five-year business caseWhat you pay today, what the new setup costs and what the move costs, including the risks.
- Proof of concept on your dataWe convert a sample of SQL and pipelines and benchmark against your real workload. You decide after the test.
- Migration in stagesOne area at a time: data, pipelines and access rights are moved, and results are reconciled against the old system.
- Parallel run and cutoverBoth systems run side by side until you switch, with a way back if something goes wrong.
What you get
- A review of your data warehouse: tables, loads, dependencies, SQL, response-time requirements and licences.
- A five-year cost estimate: what you pay today, what the new setup costs and what the move costs.
- A test on real data and real queries before you decide.
- A migration where we check that the numbers match, with a parallel run until you are confident.
From and to
We migrate from
- Teradata
- Vertica
- Oracle (Exadata)
- Netezza
- Informatica
To open tools
- dbt Core
- Airflow
- PostgreSQL
Where it fits
- ClickHouse
- Apache Iceberg with Trino
- Python
- AWS
We choose by your workload and requirements, not from a fixed package.
Pricing
- Mapping, cost case, test and migration in stages
- fixed price after a short call
The first call is free. You always get a written price before we start.
Frequently asked questions
- Which data warehouses can you move from, and to what?
- From Teradata, Vertica, Oracle (Exadata), Netezza or Informatica to open tools you control: dbt Core, Airflow and PostgreSQL, and where it fits ClickHouse, Apache Iceberg with Trino, Python and AWS. The move is done in stages, with a parallel run until you are confident.
- Will leaving our old data warehouse be cheaper?
- We don't promise it will be free. We make a five-year cost estimate and measure on your own data before talking about savings. You get a fixed price after a short call.
- What does a migration cost?
- You get a fixed price after a short call. It covers mapping, cost case, test and migration in stages. The first call is free.
- Do we have to move everything at once?
- No. The move is done in stages, one area at a time, and results are reconciled against the old system.
- What happens if something goes wrong at cutover?
- Both systems run side by side until you switch, with a way back if something goes wrong.
Contact
Email us and tell us briefly about your data warehouse and what you want to achieve, and we'll get back to you. The first call is free.