ERP Integrations  /  Microsoft Dynamics

Microsoft Dynamics analytics
for manufacturers.

Marquis IQ connects to every version of Microsoft Dynamics, from modern D365 Finance & Operations environments to legacy GP deployments running on-premises. One analytics platform, regardless of which version you're running or how many you've inherited across acquisitions.

Marquis IQ — Microsoft Dynamics Connections
D365 Finance & Operations Cloud Microsoft Fabric / Synapse
D365 Business Central Cloud PrecisionPoint certified
Dynamics GP / Great Plains On-Prem ODBC / ADF extraction
Dynamics NAV On-Prem Web API / ODBC
Dynamics AX 2009 On-Prem ODBC / ADF extraction
Dynamics CRM / D365 CE Cloud TIBCO / Scribe replication
6
Dynamics versions
covered
GP → D365
Any mix, one
unified dataset
Days
Typical connection
timeline
0
Custom dev required
from your IT team
The version-sprawl problem

Not every plant got the memo about D365.

Microsoft Dynamics isn't one system, it's a family spanning a decade of product decisions, acquisitions, and cloud migrations. The legacy plant might still run GP. The new acquisition came with Business Central. Corporate standardized on D365 F&O in 2021, but three sites never migrated.

Generic BI tools treat each Dynamics version as a separate integration project. Marquis was built from the start to understand the entire Microsoft Dynamics family, connecting every version into one unified analytics layer, so your finance team sees one number, not three conflicting exports.

Corporate HQ
D365 Finance & Operations, migrated 2021
Cloud
Plant A. Original Site
Dynamics GP 2018, still running on-prem
On-Prem
Plant B (2022 Acquisition)
Business Central, came with the deal
Cloud
Plant C. Distribution
Dynamics NAV 2015, migration pending
On-Prem
Marquis IQ connects all four
One consolidated Dynamics dataset
All versions. One analytics layer. Zero manual reconciliation.
Certified connectors

Every version of Microsoft Dynamics. One certified connection each.

Each connector is schema-mapped to that specific version of Dynamics, not a generic extract that loses the context of how that ERP actually stores your data.

D365 Finance & Operations
Cloud

The modern, cloud-native Dynamics ERP for mid-market and enterprise manufacturers. Marquis connects via Microsoft Fabric and Azure Synapse, native integration built on Microsoft's own data infrastructure, not a third-party workaround.

D365 Business Central
Cloud

The cloud ERP most commonly inherited through PE acquisitions of smaller manufacturers. Marquis uses a PrecisionPoint certified replication connector, the standard for Business Central data extraction, maintained to handle Microsoft's frequent update cadence.

Dynamics GP / Great Plains
On-Premises

The legacy workhorse still running at thousands of manufacturing sites. GP's on-premises SQL Server database is deeply familiar to our team, we extract directly using ODBC and Azure Data Factory with full understanding of GP's table structure and company database model.

Dynamics NAV
On-Prem / Hybrid

The predecessor to Business Central, still common in mid-market manufacturing environments that haven't migrated. Marquis connects to NAV via Web Services API for newer versions or direct ODBC extraction for older deployments, version-aware by design.

Dynamics AX 2009
On-Premises

AX 2009 is the legacy enterprise ERP that preceded D365 F&O, and it's still running at manufacturing sites that haven't completed migrations. Marquis connects to AX 2009 via ODBC and Azure Data Factory with schema knowledge specific to AX's data model and dimension structure.

Dynamics CRM / D365 CE
Cloud

Customer Engagement data from Dynamics CRM and D365 CE feeds Marquis IQ's Sales analytics, customer pipeline, activity history, and account data joined to actual order and revenue records from your ERP. Connected via TIBCO/Scribe replication for reliable, incremental sync.

Running GP at one plant and D365 BC at another?

That's common in PE portfolios. Marquis connects both.

Most analytics tools treat a GP instance and a Business Central instance as two completely separate integration projects. They are, the schemas are different, the extraction methods are different, the update cadences are different.

Marquis maintains version-specific connectors for each, then maps both to a common data model. The result: one AR aging report, one inventory position, one revenue view, regardless of which Dynamics version each site runs.

No manual reconciliation between sites, data comes in clean from each system and merges automatically
New acquisitions running any Dynamics version connect in days, not months of custom integration work
No migration pressure, sites stay on their current Dynamics version while the portfolio runs on clean, unified data
Site 1. Dynamics GP 2018
ODBC extraction On-premises SQL Server Incremental sync
Site 2. D365 Business Central
PrecisionPoint connector Cloud-native Incremental sync
Marquis IQ
One unified analytics layer
across both sites
Why Marquis for Dynamics

Certified means we know the schema.

Anyone can write a query against a Dynamics database. Knowing which tables matter, how GP stores multi-company data, or how D365 F&O structures financial dimensions, that's the work that took years to build.

Native Fabric for D365 F&O
We connect D365 Finance & Operations through Microsoft Fabric and Azure Synapse Link, the architecture Microsoft built for analytics. Not a third-party API workaround that breaks with every release.
PrecisionPoint for Business Central
Business Central's cloud update cadence means connectors break constantly. PrecisionPoint is the certified standard for BC data replication, we maintain it through every Microsoft update so your data doesn't stop when BC releases a wave.
Deep GP schema knowledge
Dynamics GP's SQL Server database has a non-obvious structure, company databases, intercompany transactions, and GL detail live in tables that look nothing like the front-end reports. We've mapped them. We know where the data actually lives.
Version-aware, always
GP and D365 F&O are not the same ERP with a version number difference. NAV and Business Central share a lineage but have completely different data models. Our connectors know the difference and handle each correctly.

We closed a week faster in the first quarter after go-live. The reconciliation work that used to take three people ten days just… went away. Having GP and Business Central in one place changed everything for our finance team.

— CFO, PE-owned specialty manufacturer
Running Dynamics GP and D365 Business Central across four sites

Running Dynamics? Let's show you the platform.

Tell us which version, or versions, you're on. We'll walk through exactly how Marquis connects to your environment and what analytics are available from day one.

We'll tell you honestly how long connection takes for your specific Dynamics version.