+45 XP

Master Data Management in practice: styles, tools, and the Golden Record

Ask five data practitioners what Master Data Management means and you'll get five different answers. Ask them which MDM tool to use and you'll get a 90-minute debate.

MDM is one of the most misunderstood disciplines in data management, and one of the highest-ROI investments a CDO can make when done correctly.

What MDM is (and isn't)

Master Data Management is the discipline of creating and maintaining a single, authoritative, consistently defined version of an organization's most critical data entities, typically customer, product, supplier, and location.

What MDM is NOT:

  • It's not a database or a system (though it uses both)
  • It's not the same as Data governance (though governance is essential to MDM)
  • It's not a one-time project (it's an ongoing operational capability)
  • It's not only about customer data (though that's the most visible use case)

The core deliverable of MDM is the Golden Record: a single, authoritative record for each real-world entity, synthesized from multiple source systems, cleansed, deduplicated, and enriched.

When a retailer has 47 million customer records spread across their CRM, loyalty program, e-commerce platform, and in-store POS, with 15% duplication, the Golden Record identifies and merges duplicates into 40 million unique, authoritative customer profiles. Every downstream system then works from the Golden Record.

The four MDM implementation styles

Registry style: The MDM hub doesn't store master data, it stores cross-references between source systems. Each source system keeps its own data; the hub maps "CRM customer #12345" to "loyalty customer #67890" to "billing customer #A4412". Lowest implementation effort, but the master data still lives in silos.

Consolidation style: Source systems remain authoritative, but data is periodically consolidated into the MDM hub for analytics and reporting. Good for read-only use cases; doesn't solve real-time data consistency problems.

Coexistence style: The MDM hub and source systems coexist, with changes synchronized bidirectionally. More complex to implement but gives you both a master view and operational system consistency.

Centralized (hub-and-spoke) style: The MDM hub becomes the system of record. All source systems write to and read from the hub. Maximum data consistency; maximum implementation complexity and organizational change required.

Which style is right for you depends on your integration architecture, organizational appetite for change, and use cases. Most organizations start with Registry and migrate toward Coexistence as maturity grows.

Data Architecture Strategies: Master Data Management

Watch on YouTube

Knowledge check

1. What best describes the 'Golden Record' as the core deliverable of MDM?

2. A company needs both a master view of its data AND real-time consistency in its operational systems, and is willing to accept more integration complexity. Which MDM style fits best?

3. Why is it incorrect to think of MDM as simply 'a database or a system'?

MULTIPLE CHOICE

4. Select ALL statements that are TRUE about what MDM is or isn't.

Select all the correct answers.

MULTIPLE CHOICE

5. Select ALL correct statements comparing MDM implementation styles.

Select all the correct answers.

MDM in practice: the retailer case

A major European fashion retailer had accumulated 47 million customer records from 8 different systems over 10 years: two e-commerce platforms, a loyalty program, a wholesale portal, four regional POS systems, and a legacy catalog database.

Their problems were severe:

  • The same customer appeared an average of 2.7 times across systems
  • Different systems had different spellings of the same customer name
  • Loyalty points couldn't be correctly allocated
  • Marketing was spending 25% of its budget on duplicated contacts
  • Customer lifetime value calculations were systematically understated because purchases were split across duplicate records

Their MDM program (18 months, Reltio platform) consolidated 47M records into 17.5M Golden Records. The immediate outcomes:

  • Marketing waste reduced by €4.2M annually
  • CLV modeling became accurate for the first time (actual LTV was 31% higher than previously measured, because purchases were now correctly consolidated)
  • Customer service resolution time improved as agents could see the complete customer history for the first time

Tool selection: the short version

The major MDM platforms: Informatica MDM (enterprise, complex implementations), Reltio (cloud-native, strong for customer data), Stibo Systems (strong for product data), SAP MDG (best if you're an SAP shop), Talend (open-source heritage, now part of Qlik).

Selection criteria: What is your primary use case (customer vs. product vs. supplier MDM)? What is your existing technology ecosystem? What is your integration architecture? How much organizational change can you manage in Year 1?

Don't select an MDM tool before answering these questions. The tool is the last decision, not the first.

Frequently asked questions

What is Master Data Management, in plain terms?

Master Data Management is the discipline of creating and maintaining a single, authoritative, consistently defined version of an organization's most critical data entities: customer, product, supplier, location. It is not a database or a tool, even though it relies on both, and it is not a one-off project but an ongoing operational capability. Its core deliverable is the Golden Record, one authoritative record per real-world entity, built from multiple source systems after cleansing, deduplication and enrichment.

What's the difference between MDM and data governance?

Data governance defines the rules, ownership and definitions that apply to data; MDM is the operational capability that produces and maintains a single authoritative version of critical entities like customer or product. Governance is a prerequisite for MDM, because without agreed definitions and owners there is no basis for deciding which value wins in a Golden Record. They are complementary, not interchangeable.

Which of the four MDM implementation styles should I choose?

The four styles are Registry (the hub stores only cross-references between source systems), Consolidation (data is periodically consolidated into the hub for analytics), Coexistence (hub and source systems synchronized bidirectionally) and Centralized hub-and-spoke (the hub becomes the system of record). The right choice depends on your integration architecture, your use cases and how much organizational change you can absorb. Most organizations start with Registry and migrate toward Coexistence as maturity grows.

Do I need to pick an MDM tool before starting the project?

No, the tool is the last decision, not the first. Answer four questions beforehand: what is the primary use case (customer, product or supplier MDM), what is your existing technology ecosystem, what is your integration architecture, and how much organizational change can you manage in Year 1. Selecting a platform before these answers locks you into an implementation style you may not want.

How do the main MDM platforms compare: Informatica, Reltio, Stibo, SAP MDG, Talend?

Informatica MDM targets enterprise, complex implementations. Reltio is cloud-native and strong on customer data. Stibo Systems is strong on product data. SAP MDG is the natural fit if you already run SAP. Talend comes from an open-source heritage and is now part of Qlik. The deciding factor is your primary entity (customer, product or supplier) and your existing ecosystem, not a feature-by-feature comparison.

What business impact can a customer MDM program actually deliver?

A major European fashion retailer consolidated 47 million customer records from 8 systems into 17.5 million Golden Records over an 18-month program on the Reltio platform. The outcomes: €4.2M in annual marketing waste removed, accurate CLV modeling for the first time (actual LTV was 31% higher than previously measured, because purchases were finally consolidated), and faster customer service resolution since agents could see complete customer history. Before the program, the same customer appeared an average of 2.7 times across systems.

What to do, from this lesson

These actions are compiled in the role's Playbook.

  • Launch MDM on your highest-pain domain, choosing tools last
See the full action playbook →

Related articles

Recent articles from the blog that build on this lesson.