系统设置 (Master Data Services)System Settings (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 数据库相关联的所有 Web 应用程序和 Web 服务,您都可以配置系统设置。For all web applications and web services associated with a Master Data ServicesMaster Data Services database, you can configure system settings.

其中的许多设置都可在 Master Data Services 配置管理器Master Data Services Configuration Manager“数据库” 页上进行配置。Many of these settings can be configured in Master Data Services 配置管理器Master Data Services Configuration Manager on the Database page. 其他配置可以在 Master Data ServicesMaster Data Services 数据库的系统设置表 (mdm.tblSystemSetting) 中进行配置。Others can be configured in the System Settings table (mdm.tblSystemSetting) in the Master Data ServicesMaster Data Services database.

这些设置可分为以下几类:The settings can be grouped in the following categories:

常规设置General Settings

配置管理器设置Configuration Manager Setting 系统设置System Setting 描述Description
数据库连接超时Database connection time-out DatabaseConnectionTimeOutDatabaseConnectionTimeOut Master Data ServicesMaster Data Services 数据库允许连接完成所花的秒数。The number of seconds the Master Data ServicesMaster Data Services database allows for a connection to complete. 如果连接未在该时间内完成,则会取消连接并返回错误。If the connection does not complete within this time, the connection is cancelled and an error is returned. 默认值为 60 秒(1 分钟)。The default value is 60 seconds (1 minute).
数据库命令超时Database command time-out DatabaseCommandTimeOutDatabaseCommandTimeOut Master Data ServicesMaster Data Services 数据库允许命令完成所花的秒数。The number of seconds the Master Data ServicesMaster Data Services database allows for a command to complete. 如果命令未在该时间内完成,则会取消命令并返回错误。If the command does not complete within this time, the command is cancelled and an error is returned. 默认值为 3600 秒 (60 分钟) 。The default value is 3600 seconds (60 minutes).
Web 服务超时Web service time-out ServerTimeOutServerTimeOut ASP.NET 允许用在完成 主数据管理器Master Data Manager 页请求上的秒数。The number of seconds ASP.NET allows for a 主数据管理器Master Data Manager page request to complete. 如果请求未在该时间内完成,则会取消请求并返回错误。If the request does not complete within this time, the request is cancelled and an error is returned. 默认值为 120000 秒(2000 分钟)。The default value is 120000 seconds (2000 minutes).
客户端超时Client time-out ClientTimeOutClientTimeOut 主数据管理器Master Data Manager 返回主页前处于非活动状态的秒数。The number of seconds of inactivity before 主数据管理器Master Data Manager returns to the home page. 默认值为 300 秒(5 分钟)。The default value is 300 seconds (5 minutes).
每批的行数Number of rows per batch RowsPerBatchRowsPerBatch Web 服务要在每批中检索的记录数。The number of records to retrieve in each batch by the web service. 默认值为“50” 。The default value is 50.
ApplicationNameApplicationName 显示在事件日志中的文本。The text that is displayed in event logs. 默认值为 MDMThe default value is MDM.
SiteTitleSiteTitle 显示在 主数据管理器Master Data Manager Web 浏览器标题栏中的文本。The text that is displayed in the 主数据管理器Master Data Manager web browser's title bar. 默认值为 “主数据管理器”The default value is Master Data Manager.
日志保留期(天)Log retention in Days LogRentionDaysLogRentionDays 在多少天后日志将被删除。The number of days after which the logs will be deleted. 默认值为 -1,表示系统不会清除日志表。The default value is -1 and indicates the log tables will not be cleaned.

如果值为 0,则日志表只会保留当天的数据。If the value is 0, log tables retain only today's data. 前几天的数据日志都将被截断。Data logs for the previous days are truncated.

如果值大于 0,系统会保留值所指定的天数的日志数据。If the value is greater than 0, the log data is retained for the number of days specified by the value.

版本管理设置Version Management Settings

配置管理器设置Configuration Manager Setting 系统设置System Setting 描述Description
仅复制提交的版本Copy only committed versions CopyOnlyCommittedVersionCopyOnlyCommittedVersion 主数据管理器Master Data Manager中,确定用户是只能复制状态为 “已提交” 的模型版本,还是可以复制任何状态的版本。In 主数据管理器Master Data Manager, determines whether users can copy model versions with a status of Committed, or versions with any status. 默认值为 “是”“1”,表示用户只能复制 “已提交” 版本。The default value is Yes or 1, which indicates that users can copy Committed versions only. 更改为 “否”“2” 将允许用户复制所有版本。Change to No or 2 to allow users to copy all versions.

有关详细信息,请参阅版本 (Master Data Services)For more information, see Versions (Master Data Services).

暂存设置Staging Settings

配置管理器设置Configuration Manager Setting 系统设置System Setting 描述Description
记录所有临时事务Log all staging transactions StagingTransactionLoggingStagingTransactionLogging 仅适用于 SQL Server 2008 R2。Applies to SQL Server 2008 R2 only. 确定在临时记录加载到 Master Data ServicesMaster Data Services 数据库时是否要将事务记入日志。Determines whether or not transactions are logged when staging records are loaded into the Master Data ServicesMaster Data Services database. 默认值为 “关闭”“2”The default value is Off or 2. 更改为 “打开”“1” 可启用日志记录。Change to On or 1 to turn on logging.
临时批处理间隔Staging batch interval StagingBatchIntervalStagingBatchInterval 主数据管理器Master Data Manager “集成管理” 功能区域,从您选择 “开始批处理” 到处理您的批次之间相隔的秒数。In the 主数据管理器Master Data Manager Integration Management functional area, the number of seconds after you select Start Batches that your batch is processed. 默认值为 60 秒(1 分钟)。The default value is 60 seconds (1 minute).

有关详细信息,请参阅 概述:从表导入数据 (Master Data Services)For more information, see Overview: Importing Data from Tables (Master Data Services).

资源管理器设置Explorer Settings

配置管理器设置Configuration Manager Setting 系统设置System Setting 描述Description
层次结构中的默认成员数Number of members in the hierarchy by default HierarchyChildNodeLimitHierarchyChildNodeLimit 在 “资源管理器”功能区域,显示“...更多...”之前每个层次结构中显示的最大成员数主数据管理器Master Data ManagerIn the 主数据管理器Master Data Manager Explorer functional area, the maximum number of members that are displayed in each hierarchy node before ...more... is displayed. 可以单击“...更多...”以显示下一组成员。You can click ...more... to show the next group of members. 默认值为“50” 。The default value is 50.
默认显示层次结构中的名称Show names in hierarchy by default ShowNamesInHierarchyShowNamesInHierarchy 主数据管理器Master Data Manager “资源管理器” 功能区域,确定查看层次结构时选择的默认设置。In the 主数据管理器Master Data Manager Explorer functional area, determines the default setting that is selected when you view hierarchies.

默认值为 “是”“1”,表示显示每个成员的名称和代码。The default value is Yes or 1, which indicates that the name and code of each member are displayed. 更改为 “否”“2” 可仅显示代码。Change to No or 2 to display the code only.
列表中基于域的属性的数目Number of domain-based attributes in list DBAListRowLimitDBAListRowLimit 在 的“资源管理器”主数据管理器Master Data Manager 功能区域,双击网格中基于域的属性值时显示在列表中的属性数。In the 主数据管理器Master Data Manager Explorer functional area, the number of attributes that are displayed in a list when you double-click a domain-based attribute value in the grid. 默认值为“50” 。The default value is 50. 如果存在的成员超过 50,则会改为显示一个可搜索对话框。If more than 50 members exist, a searchable dialog is displayed instead.
GridFilterDefaultFuzzySimilarityLevelGridFilterDefaultFuzzySimilarityLevel 主数据管理器Master Data Manager “资源管理器” 功能区域,使用 “匹配” 筛选条件时使用的相似性级别。In the 主数据管理器Master Data Manager Explorer functional area, the level of similarity used when using the Matches filter criteria. 默认值为“0.3” 。The default value is 0.3. 设置的值越接近 1 ,返回的匹配项就越接近搜索条件。Set the value closer to 1 to return a match that is closer to the search criteria. 设置为 1 表示完全匹配。Set to 1 for an exact match.

用于 Excel 的外接程序设置Add-in for Excel Settings

配置管理器设置Configuration Manager Setting 系统设置System Setting 描述Description
在网站主页上显示 Excel 外接程序文本Show Add-in for Excel text on website home page ShowAddInTextShowAddInText 主数据管理器Master Data Manager 主页上,显示一个链接方便用户下载 用于 Excel 的外接程序Add-in for ExcelOn the 主数据管理器Master Data Manager home page, show a link for users to download the 用于 Excel 的外接程序Add-in for Excel.
网站主页上 Excel 外接程序的安装路径Add-in for Excel install path on website home page AddInURLAddInURL 主数据管理器Master Data Manager 主页上,如果显示指向 用于 Excel 的外接程序Add-in for Excel 的链接,用户单击该链接时转到的位置。On the 主数据管理器Master Data Manager home page, if the link to the 用于 Excel 的外接程序Add-in for Excel is displayed, the location users go to when they click the link.

业务规则设置Business Rule Settings

配置管理器设置Configuration Manager Setting 系统设置System Setting 描述Description
将新业务规则递增的数字Number to increment new business rules by BusinessRuleDefaultPriorityIncrementBusinessRuleDefaultPriorityIncrement 主数据管理器Master Data Manager “系统管理” 功能区域,将每个新业务规则的优先级递增的数字。In the 主数据管理器Master Data Manager System Administration functional area, the number the priority of each new business rule is incremented by. 默认值为“10”。The default value is 10.
要将业务规则应用到的成员数Number of members to apply business rules to BusinessRuleRealtimeMemberCountBusinessRuleRealtimeMemberCount 主数据管理器Master Data Manager “资源管理器” 功能区域,要将业务规则应用到的网格中最大成员数。In the 主数据管理器Master Data Manager Explorer functional area, the maximum number of members in the grid to apply business rules to. 用于 Excel 的外接程序Add-in for Excel中,要将业务规则应用到的活动工作表中最大成员数。In the 用于 Excel 的外接程序Add-in for Excel, the maximum number of members in the active worksheet to apply business rules to. 默认值为 10000The default value is 10000.
首先执行业务规则用户脚本Business Rule User Script Execute First BusinessRuleUserScriptExecuteFirstBusinessRuleUserScriptExecuteFirst 通常情况下,业务规则操作按以下顺序执行:“默认值”、“更改值”、“验证”、“外部操作”、“用户定义的操作脚本”。Normally, business rule action executes with sequence "Default Value", "Change Value", "Validation", "External Action", "User Defined Action Script". 如果将此设置更改为 1,则业务规则操作首先执行“用户定义的操作脚本”。If this setting is changed to 1, "User Defined Action Script" will be the first step for business rule action execution. 此设置为隐藏设置。This setting is a hidden setting. 默认值为 0The default value is 0.

有关详细信息,请参阅业务规则 (Master Data Services)For more information, see Business Rules (Master Data Services).

通知设置Notification Settings

配置管理器设置Configuration Manager Setting 系统设置System Setting 描述Description
用于通知的主数据管理器 URLMaster Data Manager URL for notifications MDMRootURLMDMRootURL 主数据管理器Master Data Manager web 应用程序的 URL,在电子邮件通知的链接中使用,例如 https://constoso/mdsThe URL for the 主数据管理器Master Data Manager web application, which is used in the link in email notifications, for example https://constoso/mds.
通知电子邮件间隔Notification email interval NotificationIntervalNotificationInterval 发送电子邮件通知的频率(以秒为单位)。The frequency, in seconds, that email notifications are sent. 默认值为 120 秒(2 分钟)。The default value is 120 seconds (2 minutes).
单个电子邮件中的通知数Number of notifications in a single email NotificationsPerEmailNotificationsPerEmail 将在单个通知电子邮件中列出的验证问题的最大数目。The maximum number of validation issues that will be listed in a single notification email. 如果存在其他问题,则这些问题将不包括在该电子邮件中,但可以在 主数据管理器Master Data Manager中进行查看。Additional issues, if they exist, are not included in the email, but are available in 主数据管理器Master Data Manager.
默认电子邮件格式Default email format EmailFormatEmailFormat 所有电子邮件通知的格式。The format for all email notifications. 默认值为 HTML1The default value is HTML or 1. 数据库设置 2 表示 “文本”The database setting of 2 indicates Text.

注意:可以在 主数据管理器Master Data Manager中为单个用户替代此设置,只需在用户的“常规” 选项卡上更改和保存“电子邮件格式” 即可。Note: You can override this for an individual user in 主数据管理器Master Data Manager, by changing and saving the Email format on the user's General tab.
用于电子邮件地址的正则表达式Regular expression for email address EmailRegExPatternEmailRegExPattern 在 " 主数据管理器Master Data Manager 用户和组权限 " 功能区域中,用于验证在用户的 " 常规 " 选项卡上输入的电子邮件地址的正则表达式。有关正则表达式的详细信息,请参阅 MSDN library 中的 正则表达式语言元素In the 主数据管理器Master Data Manager User and Group Permissions functional area, the regular expression used to validate the email address entered on a user's General tab. For more information about regular expressions, see Regular Expression Language Elements in the MSDN library.
数据库邮件帐户Database Mail account EmailProfilePrincipalAccountEmailProfilePrincipalAccount 显示发送电子邮件通知时要使用的数据库邮件帐户。Displays the Database Mail account to use when sending email notifications. 默认配置文件为 mds_email_userThe default profile is mds_email_user.
数据库邮件配置文件Database Mail profile DatabaseMailProfileDatabaseMailProfile 发送电子邮件通知时要使用的数据库邮件配置文件。The Database Mail profile to use when sending email notifications. 默认值为空。The default value is blank.
ValidationIssueHTMLValidationIssueHTML 业务规则验证失败时电子邮件用户收到的 HTML 格式的文本。In HTML format, the text of the email users get when a business rule fails validation.
ValidationIssueTextValidationIssueText 业务规则验证失败时电子邮件用户收到的纯文本格式的文本。In plain text format, the text of the email users get when a business rule fails validation.
VersionStatusChangeTextVersionStatusChangeText 版本的状态更改时电子邮件用户收到的纯文本格式的文本。In plain text format, the text of the email users get when the status of a version changes. 只有对整个模型拥有 “更新” 权限的用户才会收到此电子邮件。Only users with Update permission to the entire model receive this email.
VersionStatusChangeHTMLVersionStatusChangeHTML 版本的状态更改时电子邮件用户收到的 HTML 格式的文本。In HTML format, the text of the email users get when the status of a version changes. 只有对整个模型拥有 “更新” 权限的用户才会收到此电子邮件。Only users with Update permission to the entire model receive this email.

有关详细信息,请参阅通知 (Master Data Services)For more information, see Notifications (Master Data Services).

安全设置Security Settings

配置管理器设置Configuration Manager Setting 系统设置System Setting 描述Description
SecurityMemberProcessIntervalSecurityMemberProcessInterval 主数据管理器Master Data Manager “用户和组权限” 功能区域,应用 “层次结构成员” 选项卡上设置的用户和组权限的频率(以秒为单位)。In the 主数据管理器Master Data Manager User and Group Permissions functional area, the frequency, in seconds, that user and group permissions set on the Hierarchy Members tab are applied. 默认值为 3600 秒 (60 分钟) 。The default value is 3600 seconds (60 minutes).

性能设置Performance Settings

配置管理器设置Configuration Manager Setting 系统设置System Setting 描述Description
启用性能改进设置Enable performance improvement setting PerformanceImprovementEnablePerformanceImprovementEnable 我们默认启用此设置(设置为 1),使加载权限相关页面具有良好的性能。We default to enable this setting (Set to 1) that load permission related page will have a good performance. 但在此情况下,创建/修改实体、属性、用户或组性能不佳。But in this situation create/modify entities, attributes, users, or groups will have a low performance. 为避免这种情况,可以禁用此设置(设置为 0)。To avoid this, you can disable this setting (Set to 0). 随后更改此设置。After change this setting. 必须运行命令“EXEC [mdm].[udpPerformanceToggleSwitch];”,以确保视图和数据正确无误。You must run command "EXEC [mdm].[udpPerformanceToggleSwitch];" to make sure that the view and data is correct.

有关详细信息,请参阅立即应用成员权限 (Master Data Services)For more information, see Immediately Apply Member Permissions (Master Data Services).

未使用Not Used

不使用系统设置表中的以下设置。The following settings in the System Settings table are not used.

  • SecurityModeSecurityMode

  • MDSHubNameMDSHubName

  • ApplicationLoggingApplicationLogging

  • ReportServerReportServer

  • ReportDirectoryReportDirectory

  • BusinessRuleEngineIterationLimitBusinessRuleEngineIterationLimit

  • BusinessRuleExtensibilityBusinessRuleExtensibility

  • AttributeExplorerMarkAllActionMemberCountAttributeExplorerMarkAllActionMemberCount

另请参阅See Also

数据库对象安全性 (Master Data Services)Database Object Security (Master Data Services)