Finance & Data ISV In Development Design complete → connector build (GP first)
🧬

Legacy Dynamics to Fabric

Your GP, SL, AX or NAV data in Microsoft Fabric — with a governed semantic model and an AI layer on top. No ERP migration required first.

Request Early Access → Talk to us

Product overview

Finance leadership perspective

Why you do not have to migrate before you get value from your ERP data

Impact

Before & after

Reporting on legacy ERP data
Before
Extracts and spreadsheets
After
Governed semantic model
Copilot and AI over your ledger
Before
Out of reach
After
Fabric data agents
Prerequisite for value
Before
Migrate the ERP first
After
Stay where you are
Overview

What it does

Most finance teams running a legacy Dynamics ERP are told the same thing: migrate first, get value later. We think that is backwards. This accelerator lands your on-premises GP, SL, AX or NAV data into Microsoft Fabric, builds a dimensional model your finance team recognises, and prepares it properly for AI — so Copilot and Fabric data agents can answer questions against your actual ledger. Your ERP keeps running exactly as it is.

Sources
Dynamics GP Dynamics SL Dynamics AX Dynamics NAV
Capabilities

What you get

  • Readiness assessment before anything is quoted
  • Mirroring into OneLake, with the landing mechanism handled for you
  • Cross-company consolidation across multiple company databases
  • Dimensional GL, AR, AP and inventory models
  • AI preparation layer — business names, descriptions, verified answers
  • Health monitoring, because legacy schemas change under you

Why this is not a weekend project

The parts that break

Pointing Fabric mirroring at a legacy Dynamics database sounds simple and is not. These are the failure modes we build around — each one is documented by Microsoft, and each one lands hardest on exactly these schemas.

Missing primary keys

Change data capture requires a declared primary key on every mirrored table. Legacy schemas are full of unique clustered indexes that are not primary key constraints.

Silent duplicate rows

Case-insensitive character keys can duplicate on mirroring. GP's keys are exactly this shape. It fails quietly — no error, just wrong numbers.

Table count ceilings

There is a cap on tables per mirrored database, and overflow is silent. A curated manifest per module beats "mirror everything".

Update churn

GP ships several all-inclusive updates a year that alter tables, and schema changes break mirroring. That needs monitoring and an automated re-enable path, not a phone call.

One database per company

Multi-company GP means one mirrored item per company plus the system database. Consolidation is mandatory, not a nice-to-have.

Dropped data types

Certain legacy column types are dropped silently in transit. Note and comment tables are the usual casualties.

Buyer

Who deploys this

CFO Financial Controller Finance Systems Manager Head of Data ERP Manager

Typically a finance organisation that has decided, deliberately, not to migrate yet — and is tired of hearing that nothing can improve until it does.


Pricing

Starts with an assessment

We do not quote a platform before we have looked at your estate. The engagement opens with a short, paid readiness assessment — primary key coverage, collation, table counts, unsupported data types — which tells us both whether this will work and what it will take. No published rate card.

📋

Request a readiness assessment

Tell us which ERP you run and roughly how many companies. We will come back with scope and price.

Request Assessment →

In development • Early access by invitation • No public rate card


Principles

How we work on production finance systems

Read, don't rewrite

Your ERP is the system of record and stays that way. We read from it. We do not become a dependency in your close.

Numbers are deterministic

A language model may explain a figure. It never computes one. Every number traces back to a query you can run yourself.

Your DBA is in the room

Anything touching your production database is agreed in advance, in writing, with the person responsible for it.

Get Access

Stop waiting for the migration

Early access is opening for a small number of GP estates first, then SL and AX.

Request Early Access →