Case Study

Recovering a Multi-Million Dollar Dynamics 365 Investment

A vendor built the core of this company’s platform, delivered it as a locked package, and never handed over the source. For six years nobody could open it or change it safely. MDPSync recovered the whole thing, then cataloged every asset across three connected Dynamics 365 systems. In days, not months.

By Michael Pierce · MDPSync · 2026

Dynamics 365 Business Central ArcGIS AI-Assisted Recovery
3
Dynamics Tenants Audited
6
Years Locked Out
236
Custom Tables Cataloged
900+
Workflows & Flows Captured
100%
Of the Locked Solution Recovered
1
Week, Not Months
The Challenge

A Platform They Paid For but Could Not Open

The client operates the same line of business in three states, each state on its own Microsoft Dynamics 365 system with its own Business Central accounting and its own ArcGIS mapping integration. The three systems hold the inventory, the contracts, the work orders, the billing, and the state reporting. If one of them failed in a way nobody could fix, the business in that state would stop with it.

A decade of rotating vendors and consultants built these systems, and each left a layer behind. One state program arrived as what Microsoft calls a managed solution, a locked package that runs fine but cannot be opened, read, or safely changed without the original source files. The vendor never handed those files over, and then the vendor was gone. For six years every change inside that package meant hiring expensive consultants to build workarounds beside it, because nobody could touch the thing itself.

What survived on the client’s own equipment was a scattering of old project folders, several partial copies of what might be source code, with no record of which copy matched what production was running. There was no catalog of what the three systems contained and no way to rebuild any of them. Nothing anywhere said what all that money had bought.

The Toolkit

An AI That Reads the Live System Directly

The traditional approach to a recovery like this is a team of consultants clicking through admin screens for months, writing down what they see. MDPSync connected an AI directly to the systems instead, so it could read every table, workflow, and line of configuration straight from the source and hold all three systems in view at once.

Every claim the AI made was checked against the live environment or the recovered files before it was written down. The tools below are how it reached the systems. None of them required installing anything into the client’s environments, and the entire audit was read-only by design.

Dataverse MCP

A live connection that lets the AI query the Dynamics 365 database directly, reading tables, fields, and records the way an administrator would, without guesswork.

Power Platform CLI

Microsoft’s own command-line tools, used to export solutions from each environment and unpack them into readable files a person can review and version.

Browser-Based Extraction

Where no API exists, a Chrome extension let the AI work through the same admin portals a human would use, pulling flow definitions and accounting configuration page by page.

Decompilation

Compiled code components that had no source anywhere were pulled out of the live systems and turned back into readable code, then test-compiled to prove the result builds and runs.

Version-Controlled Repositories

Everything recovered or extracted landed in Git repositories the client owns, one per state program, so every future change can be reviewed, compared, and rolled back.

Independent Second Passes

Each system was audited twice, the second pass run fresh on the assumption that a single reading finds what it goes looking for. On two of the three systems, the second pass produced the largest finding.

How It Fit Together

One Architect, One AI, Three Systems

Figure 1: The recovery pipeline THE TEAM THE TOOLS THE SYSTEMS THE RESULT One Architect + Claude AI read-only, verified Dataverse MCP live database reads Power Platform CLI solution export & unpack Chrome Extension admin portal extraction Archive Recovery old project copies, decompiling State Program A Dynamics 365 · BC · ArcGIS locked managed solution State Program B Dynamics 365 · BC · ArcGIS State Program C Dynamics 365 · BC · ArcGIS 3 Owned Repositories every asset as readable source All three systems were read together, which is what made the cross-tenant problems visible The recovery pipeline: one architect directing an AI through four extraction methods, against three production tenants, into three repositories the client owns.
The Platform

What One State Program Looks Like

Each state runs a stack like this one. Dynamics 365 is the hub, holding a custom data model of dozens of tables and over a hundred automated flows. Business Central runs the orders, invoicing, and payments. ArcGIS keeps the map in sync through a message queue.

Multiply this by three states, add a decade of vendors each building their own way, and note the warning box in the corner: credentials and connections shared across all three programs, so a problem in one state was a problem in every state. This is the map the client never had. Producing it was the first deliverable of the audit.

Architecture diagram of one state sign program: Dynamics 365 at the hub with ArcGIS integration, Business Central, Azure services, and third-party connectors One program’s full architecture, mapped during the audit. Click to enlarge.
The Discovery

Recovery from Two Directions at Once

The missing knowledge came back from two directions. The first was recovery: tracking down the vendor’s original source files in old project copies that survived on the client’s own equipment, covering the custom code, the report designs, and the accounting extensions. The second was capture: pulling the current definition of everything straight out of the three live systems and comparing the two, item by item, to establish what still matches, what has drifted, and what was never in the vendor’s files at all.

Across the three systems the audit cataloged 236 custom tables, more than 700 classic workflows and business rules, over 260 modern automated flows, every custom web page and script, every report, every security role, and every compiled code component. Some pieces existed nowhere in the vendor’s files and had to be pulled from the live systems, including a 65-page order-submission script and screens still being updated the month before.

Then each system was audited a second time, independently, without reference to the first pass. On two of the three systems the second pass produced the single largest finding of the whole engagement. Reading the three tenants side by side also surfaced problems no single-system audit could have seen, because the evidence lived in the differences between them.

What We Found

Six Years of Accumulated Risk, Made Visible

The systems were healthy and no data had been lost. Under that surface sat problems that had been running silently for years, invisible because nobody could read the systems well enough to see them.

Everything Ran Twice

One program carried 27 pairs of identical automation routines, both copies switched on, running the same logic twice on every transaction since 2022. Another had a background routine registered twice since 2020. Nobody had noticed.

One Credential, Three States

The credential connecting the systems to the mapping platform turned out to be a single shared value used by all three programs, stored as plain readable text. A leak in any one state would expose the other two. Only reading all three systems together made this visible.

The Vendor Still Held the Keys

The connection carrying orders into billing signed in under accounts created by the departed consulting firm. If one of those accounts were disabled during routine cleanup, order billing would stop. Three outside firms still held administrator access nobody had reviewed.

Every finding was written up with its evidence, its risk, and its rollback plan. The zero-risk fixes were applied in production the same day they were confirmed and verified afterward. Everything else went into a ranked follow-up list waiting on the client’s go-ahead, so nothing changed without a decision and none of it depends on anyone’s memory.

What They Own Now

In Full Control for the First Time

The locked box is open. Every asset across all three systems now exists as readable, editable source in repositories the client controls, verified against production. The recovered code was test-compiled to prove it builds and runs rather than merely looking right. The program that arrived locked can be rebuilt from the client’s own files for the first time since the day it was delivered.

That catalog is now the foundation for everything that comes next: standing up a clean development environment from owned source, merging the three tenants’ overlapping pieces deliberately instead of by accident, replacing the locked managed solution with an unlocked one, and a modernization roadmap already scoped and sequenced. Work that would have taken a traditional consulting team months of rediscovery now starts from a repository instead of an interview. For six years this client paid outside firms to work around their own platform. Now they can change it.

Assets Protected

If the worst happened to production, everything needed to stand the platform back up is in hand.

Faster Development

Changes can be planned against the real system, reviewed before they ship, and rolled back if they go wrong.

Lower Costs

No more paying consultants to rediscover the system before every change. The knowledge is written down and stays current.

Streamlined DevOps

Versioned source, repeatable builds, and a catalog that can be refreshed on a schedule instead of going stale.

The Math

Days, Not Months. A Fraction of the Cost.

A traditional recovery engagement for three enterprise tenants means a team of specialists on site for months, interviewing whoever remembers the most and clicking through admin screens one at a time. The rediscovery phase alone routinely runs six months or more before anyone touches a fix.

MDPSync delivered the complete audit, the recovery, and the ranked modernization roadmap in about a week, because the AI reads the systems directly instead of scheduling meetings with them. The client’s multi-million dollar platform investment is secured, and the roadmap it unlocked is measured in weeks, not months.

Traditional Consulting Engagement
6–12 Months
Solution Architect Dynamics Consultant BC Consultant GIS Specialist Business Analyst Project Manager
$400K – $900K
AI-Assisted Recovery with MDPSync
Days
One Architect + AI
A fraction of the cost

Take Back Control of Your Platform

If a vendor built your Dynamics, Business Central, or GIS systems and you no longer control the source, you are one departure away from the situation this client was in. Tell us what you are running and we will tell you what it takes to own it again.


Or call us directly: 703.996.3037