创建实体 (Master Data Services)Create an Entity (Master Data Services)

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) - 仅限 Windows 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) - Windows only 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance

Master Data ServicesMaster Data Services中,创建一个实体以便包含成员及其属性。In Master Data ServicesMaster Data Services, create an entity to contain members and their attributes.

先决条件Prerequisites

若要执行此过程:To perform this procedure:

创建实体To create an entity

  1. 主数据管理器Master Data Manager中,单击 “系统管理”In 主数据管理器Master Data Manager, click System Administration.

  2. 在“管理模型” 页上,从网格中选择要为其创建实体的模型,然后单击“实体” 。On the Manage Model page, from the grid, select the model that you want to create entity for and then click Entities.

  3. 在“管理实体” 页上,单击“添加” 。On the Manage Entity page, click Add.

  4. 在“名称” 框中,键入实体的名称。In the Name box, type the name of the entity.

  5. 根据需要,在“说明” 字段中,键入实体说明。Optionally, in the Description field, type the entity description.

  6. 根据需要,在“临时表名称” 框中,键入临时表的名称。Optionally, in the Name for staging tables box, type a name for the staging table.

    如果不填写此字段,则会使用实体名称。If you do not complete this field, the entity name is used.

    提示

    使用模型名称作为临时表名称的一部分,例如 Modelname_Entityname。Use the model name as part of the staging table name, for example Modelname_Entityname. 这便于在数据库中查找表。This makes the tables easier to find in the database. 有关临时表的详细信息,请参阅概述:导入表中数据 (Master Data Services)For more information about the staging tables, see Overview: Importing Data from Tables (Master Data Services).

    提示

    若要使用临时表的默认命名,但另一模型中有同名实体,MDS 会自动将标识符(例如 _1、_2)追加到临时表名称中。If using the default naming for Staging tables, MDS will automatically append identifiers (e.g. _1, _2) to the staging table names if an entity with same name exists in another Model.

  7. 对于“事务日志类型”字段,请在下拉列表中选择事务日志类型。For the Transaction Log Type field, choose the transaction log type in the drop-down list.

    有关详细信息,请参阅更改实体事务日志类型 (Master Data Services)For more information, see Change the Entity Transaction Log Type (Master Data Services)

  8. 可选。Optional. 选中 “自动创建代码值” 复选框。Select the Create Code values automatically check box. 有关详细信息,请参阅 )(Master Data Services 自动创建代码 For more information, see Automatic Code Creation (Master Data Services).

  9. 可选。Optional. 选择“启用数据压缩” 复选框。Select the Enable data Compression checkbox. 默认情况下,系统将打开行压缩。By default the row compression is turned on. 有关详细信息,请参阅 Data CompressionFor more information , see Data Compression.

  10. 单击“保存”。Click Save.

网格列Grid Columns

对于创建的每个实体,系统都会在网格中添加一行(其中包含十三列)。For each created entity, a row with thirteen columns is added to the grid. 下面介绍了这些列。The following are the columns.

“属性”Name 说明Description
状态Status 实体状态。The entity status. 单击“保存” 时,将显示下图,指示实体正在更新。When you click Save the following image is displayed that indicates that the entity is updating.

用于更新状态的图标Icon for updating status

如果在创建或编辑实体时出错,将显示下面的图像。If there are errors when creating or editing an entity, the following image is displayed.

错误状态图标Icon for error status

如果状态为“正常”,则将显示下面的图像。If the status is OK, then the following image is displayed.

!["正常" 状态图标](../master-data-services/media/mds-statusicon-ok.png ""正常" 状态图标")Icon for OK status
nameName 实体名称。The entity name.
描述Description 实体说明。The entity description.
临时表Staging Table 用于存储数据的表的前缀名称。The prefix name of the table that is used for storing data.
事务日志类型Transaction Log Type 实体的事务日志类型。The transaction log type of the entity.
自动创建代码Automatic Code Creation 指定是否启用自动代码创建。Specifies whether automatic code creation is enabled.
数据压缩Data Compression 指定是否为实体启用数据压缩。Specifies whether data compression is enabled for the entity.
是否是同步目标Is Sync Target 指定实体是否为同步关系的目标。Specifies if the entity is the target of a sync relationship.
是否已启用层次结构Is Hierarchy Enabled 指定是否为显式层次结构启用了实体。Specifies if the entity is enabled for explicit hierarchies. 如果为实体创建了至少一个显式层次结构,则此列将显示“是”。This column shows Yes if at least one explicit hierarchy is created for the entity.
创建者Created By 创建实体的用户的用户名。The username of the user who created the entity.
创建时间Created On 创建实体的日期和时间。The date and time when the entity was created.
更新者Updated By 上次更新实体的用户的用户名。The username of the user who last updated the entity.
更新时间Updated On 上次更新实体的日期和时间。The date and time when the entity was last updated.

后续步骤Next Steps

另请参阅See Also

实体 (Master Data Services) Entities (Master Data Services)
显式层次结构 (Master Data Services) Explicit Hierarchies (Master Data Services)
编辑实体 (Master Data Services) Edit an Entity (Master Data Services)
删除实体 (Master Data Services)Delete an Entity (Master Data Services)