Case Study: Construction
100 TB Unified, Decisions Simplified
Unified 15 years, 27 databases, 53 companies—mission-critical ERP migration delivered.
About the Client
Born from a mission to redefine construction in the Middle East, the company has become the force behind many of the region’s most ambitious industrial and commercial landmarks. Their reputation rests on speed, innovation, and a relentless focus on quality and sustainability.
The Challenges
- Legacy ERP ceilings – CMiC and NAV 2009 could not deliver modern analytics, mobility, or scalability.
- Massive migration scope – 15 years of transactional history and heavy customisations spread across 27 live databases.
- Data complexity – nearly 100 TB spanning three countries and 53 companies, each with different dimensional structures.
- Mandatory consolidation – Business Central’s single-database requirement demanded flawless merging of disparate schemas.
Our Solution
| Pillar | Key Actions |
|---|---|
| Comprehensive data migration | Extracted, cleansed, and transformed 15 years of history—including all custom tables—and loaded it into Business Central. |
| Unified database architecture | Merged 27 NAV databases into one modern schema, resolving dimensional mismatches and duplicate keys. |
| CMiC integration | Kept project-cost, procurement, and sales workflows flowing by integrating CMiC with the new ERP via secure APIs. |
| Tool & report pack modernisation | Re-engineered legacy NAV tools/reports to run natively in Business Central without loss of functionality. |
| Rigorous testing & cut over | Executed multiple dry-runs, volume/performance tests, and user-acceptance cycles to ensure a smooth go-live. |
Business Outcomes
- Single source of truth –unified data model enables consolidated P&L and project dashboards at the click of a button.
- Faster close & reporting –month-end processes compressed from double-digit days to single-digit.
- Reduced manual effort – elimination of data silos and spreadsheet reconciliations frees finance and IT capacity for strategic work.
- Hardened security – role-based access and field-level permissions now span all 53 entities, supporting audit-ready compliance.
- Scalable platform – Business Central’s SaaS architecture positions the client to roll out Power BI, Copilot, and future acquisitions with minimal friction.
What’s Next
With core financials and operations on a single platform, the client is piloting AI-driven procurement forecasts and real-time project P&L dashboards, while planning a phase-two rollout of Power Apps for field-based quality inspections.
Why Korcomptenz?
- Deep construction expertise – understanding of CMiC and industry-specific cost controls.
- Proven mega-migration playbook – methodology honed on multi-terabyte, multi-entity migrations.
- End-to-end accountability – strategy, data, integration, change management, and post-go-live optimisation under one roof.
Ready to build your own single source of truth?
Book a 30-minute assessment with our Dynamics 365 experts
Customer appreciation
“Korcomptenz turned an overwhelming 100-terabyte puzzle into a strategic asset. Today we surface project-cost insights in minutes instead of weeks, and our IT team can finally focus on innovation rather than maintenance.”
– Group Finance Director.