Utilities
Data warehouse migration for utilities
Utilities run warehouse logic that feeds operations, finance and regulatory reports, so every converted object has to be shown to match the original. Novuz converts that logic by fixed rules inside your own environment and produces a reconciliation report for every object. A Fortune 500 natural gas utility runs Novuz, moving SQL Server to PySpark and Iceberg. For NERC CIP and SOX change-control evidence, see /for-audit.
The problem
Why are utility warehouse migrations hard to sign off?
Because the logic carries numbers other people rely on. Stored procedures, SSIS packages and schedules feed operational dashboards, finance close and regulatory reporting, and much of it was written by people who have left. A migration is thousands of changes at once, and each one needs a record of what changed, who approved it and proof that the result matches.
Evidence
What evidence does Novuz give a utility’s change control?
Evidence per change, for every object:
- what each object became;
- the rule version that converted it;
- any resolver proposal, with the engineer who approved it;
- a reconciliation report on the same inputs.
Novuz does not certify compliance; your own controls do. It produces the evidence per change, and your compliance team maps it to the requirements that apply to you.
Where it runs
Can it run inside our network?
Novuz runs as a Docker container or VM inside your own cloud account or data center. It needs no outbound connection and can run air-gapped, so code and data stay inside your environment, under your access and logging controls.
How to start
How should a utility start?
Move one domain first, in 5 to 6 weeks, with the reconciliation threshold written into the First Domain charter: 95% of in-scope objects by default. If it is missed at the readout, after the cure period and the charter’s exclusions, the fee is waived or credited in full.
Next question
Where to read next
For NERC CIP and SOX change-control evidence, see the audit page.
FAQ
Frequently asked questions
Does Novuz work with utilities?
Yes. A Fortune 500 natural gas utility runs Novuz, moving SQL Server to PySpark and Iceberg. Customers are described, not named, until each gives written permission.
Can Novuz run with no outbound internet connection?
Novuz runs as a Docker container or VM inside your own cloud account or data center. It needs no outbound connection and can run air-gapped, so code and data stay inside your environment, under your access and logging controls.
Does Novuz certify regulatory compliance?
Novuz does not certify compliance; your own controls do. It produces the evidence per change, and your compliance team maps it to the requirements that apply to you.
Sources and further reading
- Microsoft Lifecycle, SQL Server 2016: extended support ended in July 2026
- Microsoft Lifecycle, SQL Server 2017: extended support ends in October 2027
- McKinsey & Company, "Tech debt: Reclaiming tech equity," October 2020: CIOs estimate tech debt at 20 to 40 percent of the value of their technology estate, and 60 percent say it has risen
Written by Debjani Dhar, Co-founder and CEO, Novuz · Technical review: Ted Ghose, Co-founder and CTO, Novuz
Last reviewed:
Find out what your logic debt is costing you.
Every object counted, lineage, dead code and a fixed price in three business days. $3,000, credited.
Not sure which door? The scorecard takes ten minutes and tells you.