Interacting with Master Data Services (MDS)

There are five different way to interact with Master Data Services (MDS) to do things such as create a model, load data into MDS, manage business rules, versioning, etc.

More info:

Comparison of Master Data Services Functionality in Web Interface versus Excel Add-In


About James Serra

James currently works for Microsoft specializing in big data and data warehousing using the Analytics Platform System (APS), a Massively Parallel Processing (MPP) architecture. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence/MDM architect and developer, specializing in the Microsoft BI stack. He is a SQL Server MVP with over 25 years of IT experience.
This entry was posted in MDS/MDM, SQLServerPedia Syndication. Bookmark the permalink.

One Response to Interacting with Master Data Services (MDS)

  1. Andrew says:


    I’m looking at implementing a MDM solution. Part of the requirements is full change tracking. The value held within the table is similar to hash tag i.e. E34DBF05-8CF0-427F-A0D0-A6ED936751DD (held within OldValue and NewValue) is there a way to extract the physical values?

    SELECT [OldValue]
    FROM [MDM].[mdm].[tblTransaction]

    Thanks & Regards,


Leave a Reply

Your email address will not be published. Required fields are marked *