Export (0) Print
Expand All

Master Data Services


Applies To: SQL Server 2016

Master Data Services (MDS) is the SQL Server solution for master data management. Master data management (MDM) enables you organization to discover and define non-transactional lists of data, and compile maintainable, reliable master lists. This article briefly describe the MDS components and provides links to additional information.

For information about the new features in SQL Server 2016, see What's New in Master Data Services (MDS).


  • To download SQL Server 2016 Release Candidate (RC3), go to Evaluation Center.

  • Have an Azure account? Then go Here to spin up a Virtual Machine with SQL Server 2016 already installed.

You can use Master Data Services to manage any domain; it's not specific to managing lists of customers, products, or accounts. Master Data Services includes the following components and tools:

  • Master Data Services Configuration Manager, a tool you use to create and configure Master Data Services databases and web applications.

  • Master Data Manager, a web application you use to perform administrative tasks (like creating a model or business rule), and that users access to update data.

  • MDSModelDeploy.exe, a tool you use to create packages of your model objects and data so you can deploy them to other environments.

  • Master Data Services web service, which developers can use to extend or develop custom solutions for Master Data Services.

  • Master Data Services Add-in for Excel, which you use to manage data and create new entities and attributes.

Browse Content by Area

Small File Folder IconMaster Data Services Overview

Small File Folder IconMaster Data Services Features and Tasks

Small File Folder IconTechnical Reference (Master Data Services)

Small File Folder IconDeveloper’s Guide (Master Data Services)

Community Additions

© 2016 Microsoft