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

INTEGRATING MASTER DATA SERVICES INTO THE ENTERPRISE

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:

    Hi,

    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]
    ,[OldCode]
    ,[NewValue]
    ,[NewCode]
    FROM [MDM].[mdm].[tblTransaction]

    Thanks & Regards,

    Andrew

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>