SQL Server Master Data Services (MDS)

SQL Server Master Data Services (MDS) is the SQL Server solution, which can be used by organizations to discover and define non-transactional lists of data, with the goal of compiling maintainable master lists. You can use MDS to manage any subject domain, create hierarchies, define granular security, log transactions, manage data versioning, and create business rules.

MDS includes:

  • Configuration Manager
  • Master Data Manager (a web application you use to perform administrative tasks)
  • MDSModelDeploy.exe tool (to create and deploy packages of your model objects and data)
  • Master Data Services web service (to extend or develop custom solutions for Master Data Services
  • Master Data Services Add-in for Excel (to manage data and create new entities and attributes)
%d bloggers like this: