Master Data Services Overview (MDS)
Applies to: SQL Server (all supported versions) - Windows only Azure SQL Managed Instance
This topic describes the key data organization and management features of Master Data Services.
Master Data Services enables you to manage a master set of your organization's data. You can organize the data into models, create rules for updating the data, and control who updates the data. With Excel, you can share the master data set with other people in your organization.
For a description of the Master Data Services architecture, see the Master Data Services -- The Basics article on simple-talk.com. For information about the new features in SQL Server, see What's New in Master Data Services (MDS)
For instructions on how to install Master Data Services, set up the database and Website, and deploy the sample models, see Master Data Services Installation and Configuration.
In Master Data Services, the model is the highest level container in the structure of your master data. You create a model to manage groups of similar data, for example to manage online product data. A model contains one or more entities, and entities contain members that are the data records. An entity is similar to a table.
For example, your online product model may contain entities such as product, color, and style. The color entity may contain members for the colors red, silver, and black.
Models also contain attributes that are defined within entities. An attribute contains values that help describe the entity members. There are free-form attributes and domain-based attributes. A domain-based attribute contains values that are populated by members from an entity and can be used as attribute values for other entities.
For example, the product entity might have free-form attributes for cost and weight. And, there is a domain-based attribute for color that contains values that are populated by the color entity members. This master list of colors is used as attribute values for the Product entity .
Derived hierarchies come from the relationships between entities in a model. These are domain-based attribute relationships. In the product model for example, you can have a color derived hierarchy that comes from the relationship between the color and product entities.
Once you've defined a basic structure for your data, you can start adding data records (members) by using the import feature. You load data into staging tables, validate the data using business rules, and load the data into MDS tables. You can also use business rules to set attribute values.
The following table outlines the key Master Data Services tasks. Unless otherwise noted, all of the following procedures require you to be a model administrator. For more information, see Administrators (Master Data Services).
You might want to complete the following tasks in a test environment and use the sample data provided when you install Master Data Services. For more information, see Deploying Models (Master Data Services).
|Create a model||When you create a model, it is considered VERSION_1.||Models (Master Data Services)
Create a Model (Master Data Services)
|Create entities||Create as many entities as you need to contain your members.||Entities (Master Data Services)
Create an Entity (Master Data Services)
|Create entities to use as domain-based attributes||To create a domain-based attribute, first create the entity to populate the attribute value list.||Domain-Based Attributes (Master Data Services)
Create a Domain-Based Attribute (Master Data Services)
|Create attributes for your entities||Create attributes to describe members. A Name and Code attribute are automatically included in each entity and cannot be removed. You might want to create other free-form attributes to contain text, dates, numbers, or files.||Attributes (Master Data Services)
Create a Text Attribute (Master Data Services)
Create a Numeric Attribute (Master Data Services)
Create a Date Attribute (Master Data Services)
Create a Link Attribute (Master Data Services)
Create a File Attribute (Master Data Services)
|Create attribute groups||If you have more than four or five attributes for an entity, you might want to create attribute groups. These groups are the tabs that are displayed above the grid in Explorer and they help ease navigation by grouping attributes together on individual tabs.||Attribute Groups (Master Data Services)
Create an Attribute Group (Master Data Services)
|Import members for your supporting entities||Import the data for your supporting entities by using the staging process. For the Product model, this might mean importing colors or sizes. You can also create members manually.
Note: Users can create members in Master Data Manager if they have a minimum of Update permission to an entity's leaf model object and access to the Explorer functional area.
|Overview: Importing Data from Tables (Master Data Services)
Create a Leaf Member (Master Data Services)
|Create and apply business rules to ensure data quality||Create and publish business rules to ensure the accuracy of your data. You can use business rules to:
Set default attribute values.
Change attribute values.
Send email notifications when data doesn't pass business rule validation.
|Business Rules (Master Data Services)
Create and Publish a Business Rule (Master Data Services)
Validate Specific Members against Business Rules (Master Data Services)
Configure Email Notifications (Master Data Services)
Configure Business Rules to Send Notifications (Master Data Services)
|Import members for your primary entities and apply business rules||Import the members for your primary entities by using the staging process. When done, validate the version, which applies business rules to all members in the model version.
You can then work to correct any business rule validation issues.
|Validation (Master Data Services)
Validate a Version against Business Rules (Master Data Services)
Validation Stored Procedure (Master Data Services)
|Create derived hierarchies||Derived hierarchies can be updated as your business needs change and ensure that all members are accounted for at the appropriate level.||Derived Hierarchies (Master Data Services)
Create a Derived Hierarchy (Master Data Services)
|If needed, create explicit hierarchies||If you want to create hierarchies that are not level-based and that include members from a single entity, you can create explicit hierarchies.||Explicit Hierarchies (Master Data Services)
Create an Explicit Hierarchy (Master Data Services)
|If needed, create collections||If you want to view different groupings of members for reporting or analysis and do not need a complete hierarchy, create a collection.
Note: Users can create collections in Master Data Manager if they have a minimum of Update permission to the collection model object and access to the Explorer functional area.
|Collections (Master Data Services)
Create a Collection (Master Data Services)
|Create user-defined metadata||To describe your model objects, add user-defined metadata to your model. The metadata might include the owner of an object or the source the data comes from.|
|Lock a version of your model and assign a version flag||Lock a version of your model to prevent changes to the members, except by administrators. When the version's data has validated successfully against business rules, you can commit the version, which prevents changes to members by all users.
Create and assign a version flag to the model. Flags help users and subscribing systems identify which version of a model to use.
|Versions (Master Data Services)
Lock a Version (Master Data Services)
Create a Version Flag (Master Data Services)
|Create subscription views||For your subscribing systems to consume your master data, create subscription views, which create standard views in the Master Data Services database.||Overview: Exporting Data (Master Data Services)
Create a Subscription View to Export Data (Master Data Services)
|Configure user and group permissions||You cannot copy user and group permissions from a test to a production environment. However, you can use your test environment to determine the security you want to use eventually in production.||Security (Master Data Services)
Add a Group (Master Data Services)
Add a User (Master Data Services)
When ready, you can deploy your model, with or without its data, to your production environment. For more information, see Deploying Models (Master Data Services).