Entities (Master Data Services)
Applies To: SQL Server 2016 Preview
Entities are objects that are contained in Master Data Services models. Each entity contains members, which are the rows of master data that you manage.
Models can contain as many entities as you want to manage. Each entity should group a similar kind of data. For example, you might want an entity for all of your corporate accounts, or an entity for your master list of employees.
Typically, there are one or more central entities that are important to your business, and to which other objects in the model relate. For example, in a Product model, you could have a central entity called Product and entities called Subcategory and Category that relate to the Product entity. However, you do not need to have a central entity. Depending on your needs, you might have several entities that you consider to be of equal importance.
You can think of an entity as a table that contains master data, where the rows represent members and the columns represent attributes.
You populate the entity with a list of master data that you want to manage.
Entities can be used to build derived hierarchies, which are level-based hierarchies based on multiple entities. For more information, see Derived Hierarchies (Master Data Services).
Entities can also be enabled to contain explicit hierarchies (ragged structures based on a single entity) and collections (one-off combinations of subsets of members). For more information, see Explicit Hierarchies (Master Data Services) and Collections (Master Data Services).
When users are assigning attributes to the members in an entity, you can have them choose from a constrained list of values. To do this, you use an entity to populate the list of values for the attribute. This is called a domain-based attribute. For more information, see Domain-Based Attributes (Master Data Services).
A base entity is a starting point for users when navigating objects in the model. A base entity determines the layout of the screen when a user opens the Explorer functional area and clicks Explorer on the menu bar. To specify an entity as a base entity, navigate to the System Administration functional area. On the Model View page, drag the entity from the tree control on the right to the name of the model in the tree control on the left.
You can give users permission to an entity, which includes related model objects. For more information, see Entity Permissions (Master Data Services).
The following example shows an entity that has these attributes: Name, Code, Subcategory, StandardCost, ListPrice, and FilePhoto. These attributes describe the members. Each member is represented by a single row of attribute values.
In the following example, the Product entity is the central entity. The Subcategory entity is a domain-based attribute of the Product entity. The Category entity is a domain-based attribute of the Subcategory entity. StandardCost and ListPrice are free-form attributes of the Product entity, and FilePhoto is a file attribute of the Product entity.
This is an example based on the Master Data Services user interface (UI). The hierarchical tree structure shows relationships between entities and domain-based attributes. It is intended to show relationships rather than represent levels of importance.
Create a new entity.
Specify that an entity can contain explicit hierarchies and collections.
Change the name of an existing entity.
Delete an existing entity.
Assign permission to entities.