Compare Microsoft MDS

Microsoft SQL Server Master Data Services and Lima master data

Master Data Services is the master-data feature that shipped free with SQL Server and that many mid-market teams started on; Microsoft removed it from SQL Server 2025 and supports it on SQL Server 2022 and earlier.

MICROSOFT MDSyour systemscopy into Microsoft MDSmatch and steward therepublish to a warehouseconsumers read copiesLIMA MASTER DATAyour systemsread in placegolden viewgrids · pivots · APIs · agentswrite-back, confirmedthe dashed return is the acknowledged write-back to the system that owns the record
Where the rows live, in one picture. Microsoft MDS's lane follows its own documentation; Lima's lane is the master-data design.
9
questions
method
4
numbered sources
dated source
September 17
checked
dated source
2
'when to choose' sections
method
The nine questions

Microsoft MDS and Lima master data, side by side

Every Microsoft MDS cell carries its source number; the sources are listed at the foot of the page.

QuestionMicrosoft MDSLima master data
Where the master data livesModels, entities and hierarchies are stored in a SQL Server database; subscription views expose them to consumers [1].Golden records are governed views over the sources, read in place through the federated engine, and materialised only where latency needs it, in your lake, under the same keys. The transactions sit in the same bed, so a merged customer and its orders change together.
Reaching SAP, Oracle and the lakesLoads through staging tables and the Excel add-in; integration through SQL and the service API [1].SAP S/4HANA and ECC through released read interfaces and change capture; Oracle Fusion through REST and BI Cloud Connector extracts, E-Business Suite through JDBC and open interfaces; Snowflake, Databricks and Fabric read in place; Salesforce, ServiceNow and Workday through their APIs. Write-back through BAPIs, IDocs, REST and web services, acknowledged and logged.
Golden record: matching and survivorshipBusiness rules and matching through Data Quality Services on the same server; survivorship is manual or rule-driven per attribute [1].Strong keys first (VAT ID, DUNS, GTIN, manufacturer part number), then standardised attribute and address matching, with a language model for the hard pairs; two thresholds per rule (review, merge); survivorship per field by source rank, recency, verification and steward override; unmerge restores the sources; every value keeps its source, rule and time.
Hierarchies and reference dataDerived and explicit hierarchies, collections; versions of a model [1].Levels and several hierarchies per entity, kept as versions with validity dates and validated against the facts they aggregate; reference data and crosswalks kept as small domains with the same history, rules and security.
Rules, security and auditModel, entity, attribute and member permissions; transaction log per version [1].Column, row and business rules in one language, evaluated on save and on demand, including rules over aggregates and across tables; twelve security layers for read, write and delete; an append-only audit trail with point-in-time reads and logged reads of sensitive columns.
APIs and data servicesA SOAP service API and subscription views for SQL access [1].REST, SOAP, SQL (JDBC and ODBC), events and an agent endpoint over one policy engine; the golden-record lookup answers with the record, the cross-reference and live related facts; page sizes and rate limits published per endpoint.
Analytics: pivots, measures, transactionsAbsent inside the product; reporting through SQL Server tooling [1].Pivots on any hierarchy level with time on the columns and measures in the cells; calculated measures; data entry with disaggregation by weights, equal shares or a time profile; drill-down from a cell to the transactions and to the source row; charts beside grids; natural-language and SQL querying.
Pricing unit and trialFree with SQL Server 2022 and earlier; removed in SQL Server 2025; Profisee's Application Edition markets a one-click upgrade path and Semarchy lists MDS as deprecated [1][2][3].Platform capacity tiers (32C to 128C); domains, records, attributes and users included; the price is written before the work starts; a guided first domain on your data in one day; the showcase estate for demonstrations; a self-service sandbox tier is a decision pending (see the review notes).
Analyst placements 2025–26Absent from the 2026 Gartner MQ for MDM Solutions [4].Analyst evaluation is the purpose of this page set; placements to date: none. The platform pages are organised on Gartner's eight mandatory features and four implementation styles so a briefing lands in the right market.
When to choose them

When Microsoft MDS is the better choice

Keep MDS while SQL Server 2022 is in support and the model is small and stable, and plan the move before the database platform moves to SQL Server 2025. The migrate pages describe the path, with history carried across [1].

What Lima adds

When Lima master data is the better choice

Lima suits the enterprise whose master data should be governed on the rows in place across SAP, Oracle, the CRM and the lakes, with the transactions in the same bed: the golden record and its orders in one query, rules over totals, pivots on golden dimensions with data entry and disaggregation, drill-downs to the source row, and a headless lookup that answers with live related facts. Twelve security layers and an append-only audit trail apply to every door, and the price is written before the work starts.

The domain catalogue shows thirty domains with, for each, the objects read in place in SAP S/4HANA, Oracle Fusion, Salesforce, Workday, ServiceNow, Snowflake and Databricks and the interface used for the write-back.

Sources

Checked on September 17, 2026

Facts change; re-check the sources at each review and re-date the page.

  1. Microsoft Learn: Master Data Services overview (removed in SQL Server 2025), checked Sep 17 2026 — https://learn.microsoft.com/en-us/sql/master-data-services/master-data-services-overview-mds
  2. Profisee pricing page (Application Edition, MDS migration), checked Sep 17 2026 — https://profisee.com/pricing/
  3. Semarchy blog: top MDM solutions compared, updated Apr 13 2026 — https://semarchy.com/blog/top-master-data-management-solutions-compared/
  4. Spotlight mirror of the 2026 Gartner MQ for MDM Solutions: vendors, Apr 6 2026 — https://research.oz.spotlightar.com/reports/magic-quadrant-master-data-management-solutions-2026/leaders

See your first domain built on your data

Bring two systems that hold the same customers, suppliers or materials. In one working day we connect them, run the match on live rows, review the queue with your steward and publish the first golden view with its API.