Don’t let master data become the “Master of Disaster” – Introduction to MDM/MDS


Don’t let master data become the “Master of Disaster” – Introduction to MDM/MDS


What is Master Data Management (MDM)

Master data represents the business objects which are agreed on and shared across the enterprise. It can cover relatively static reference data, transactional, unstructured, analytical, hierarchical and meta data.

Let me start by telling you what it is not. Master Data Management (MDM) is not a pure technological solution. It’s not a quick, pre-developed GUI to maintain data. To ensure sanitized master data, you need to include fundamental changes which are required in business processes. Often, the most complex master data management challenges are more policy related than technical (and policy is politically sensitive).

What is important to note, is that MDM consists of both creating and maintaining your master data. Creating a sanitized, consistent master data set is a waste of investment in function of time, money and effort, if the solution does not include tools and processes to this master data through updates. To do so, a Data Governance structure is usually set up (really mastering the Data) as part of a Master Data Management program. This process involves the roles of Data Owners, Data Architects and a Data Steward.

In order to implement a successful MDM program, it is important that the focus on people, processes and technology is in balance. Also archiving and keeping track of historical data needs to be part of the Master Data Architecture.

What is this master data?

Each organization holds master data, basic information consisting of customers, products, employees, processes, etc. This master data is essential for an organization in order to guarantee an optimum functioning of the organization. Most of the time, this master data is stored in different (duplicated) ways and systems. Every system has its own version of the truth, in totally incompatible ways. This makes it impossible to combine all data, and have a 360° view on the data. There are also other types of data that don’t fit in the existing systems, like configurations, pictures, logos, PDFs, etc. Usually, these are stored somewhere locally in each division.

Depending on the type and structure of the organization, the purpose, sources and targets of specific data, the same data can be master data for one company, and non-master data for another company.


Why Master Data Management?

Organizations are engaged in business intelligence, (re-)designing their systems, optimizing business processes, creating a single view of the customer and complying with external regulations. An adequately equipped MDM for this, is an crucial prerequisite. For that reason, MDM has gained a lot of importance within many large and medium-sized organizations.


The MDM process

Managing master data involves a whole process, which can be facilitated by specific technology. If we take this to the Microsoft SQL Server Stack, we are talking about MDS of course, but also SSIS, SSRS and DQS.
Here is an overview of what this process can look like:

Important in the whole process is also that:

  • A data steward is responsible for data management at a higher level. This person needs to have adequate business knowledge and connectivity.
  • The process is managed, monitored and supported by a technical team.
  • Source systems are able to get an additional Column (MDS_ID) that can be updated by the feedback system of MDS.
  • Source systems are really the sources of the system and have their own Interface (GUI) for managing their own data. The systems need to be able to operate independently from each other and from MDS. It’s not MDS’s target to create extra constraints between different applications. The goal is to get added value from applications that (re-)use the same data and reports, or execute other data requests over different applications.



    1. MDM is not a tool. It involves people, processes and technology.
    2. MDM/MDS can bring a lot of added value to your business.
    3. MDM/MDS can avoid duplicated key data, therefor simplifying data management.
    4. Consider the following when you start an MDM project within your company:
      • What is the purpose/target of it (business)?
      • What is the added value (business)?
      • Which technology are we going to use to support this process: in House / External (technical)
      • Do we have someone that will/can manage our master data (business)
      • Which extra skills / trainings do we need to foresee (technical)?
Group of computer programmers working in the office. Focus is on blond woman showing something to her colleague on PC.
Updating your Azure SQL server OAuth2 credentials in Power BI via PowerShell for automation purposes
The better way to update OAuth2 credentials in Power BI is by automating the process of updating Azure SQL Server...
Under (memory) pressure
A few weeks ago, a client asked me if they were experiencing memory pressure and how they could monitor it...
Managing files from other devices in a Fabric Lakehouse using the Python Azure SDK
In this blogpost, you’ll see how to manage files in OneLake programmatically using the Python Azure SDK. Very little coding...
Database specific security in SQL Server
There are many different ways to secure your database. In this blog post we will give most of them a...
SQL Server security made easy on the server level
In this blog, we’re going to look at the options we have for server level security. In SQL Server we...
Microsoft SQL Server history
Since its inception in 1989, Microsoft SQL Server is a critical component of many organizations' data infrastructure. As data has...