Share via


System Settings (Master Data Services)

For all Web applications and Web services associated with a Master Data Services database, you can configure system settings.

Many of these settings can be configured in Master Data Services Configuration Manager on the Database page. Others can be configured in the System Settings table (mdm.tblSystemSetting) in the Master Data Services database.

The settings can be grouped in the following categories:

  • General Settings

  • Version Management Settings

  • Staging Settings

  • Explorer Settings

  • Business Rule Settings

  • Notification Settings

  • Security Settings

  • Not Used

General Settings

Configuration Manager Setting

System Setting

Description

Web application time-out

InactiveTimeOut

The number of seconds of inactivity before Master Data Manager returns to the home page. The default value is 900 seconds (15 minutes).

Database time-out

DatabaseTimeOut

The number of seconds the Master 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. The default value is 3600 seconds (60 minutes).

Server time-out

ServerTimeOut

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. The default value is 120000 seconds (2000 minutes).

Number of rows per batch

RowsPerBatch

The number of records to retrieve in each batch by the Web service. The default value is 50.

ApplicationName

The text that is displayed in event logs. The default value is MDM.

SiteTitle

The text that is displayed in the Master Data Manager Web browser's title bar. The default value is Master Data Manager.

Version Management Settings

Configuration Manager Setting

System Setting

Description

Copy only committed versions

CopyOnlyCommittedVersion

In Master Data Manager, determines whether users can copy model versions with a status of Committed, or versions with any status. The default value is Yes or 1, which indicates that users can copy Committed versions only. Change to No or 2 to allow users to copy all versions.

For more information, see Versions (Master Data Services).

Staging Settings

Configuration Manager Setting

System Setting

Description

Log all staging transactions

StagingTransactionLogging

Determines whether or not transactions are logged when staging records are loaded into the Master Data Services database. The default value is Off or 2. Change to On or 1 to turn on logging.

Staging batch interval

StagingBatchInterval

In the Master Data Manager Integration Management functional area, the number of seconds after you select Process unbatched data that your batch is processed. The default value is 60 seconds (1 minute).

For more information, see Importing Data (Master Data Services).

Explorer Settings

Configuration Manager Setting

System Setting

Description

Number of members in the hierarchy by default

HierarchyChildNodeLimit

In 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. The default value is 50.

Show names in hierarchy by default

ShowNamesInHierarchy

In the Master Data Manager Explorer functional area, determines the default setting that is selected when you view hierarchies.

The default value is Yes or 1, which indicates that the name and code of each member are displayed. Change to No or 2 to display the code only.

Number of domain-based attributes in list

DBAListRowLimit

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. The default value is 500. If more than 500 members exist, a searchable dialog is displayed instead.

DataExportRowCountLimit

In the Master Data Manager Explorer functional area, the maximum number of rows that can be exported to Microsoft Excel. The default value is 10,000.

GridFilterDefaultFuzzySimilarityLevel

In the Master Data Manager Explorer functional area, the level of similarity used when comparing data to the filter criteria. The default value is 0.3. Set the value closer to 1 to return a match that is closer to the search criteria. Set to 1 for an exact match.

Business Rule Settings

Configuration Manager Setting

System Setting

Description

Number to increment new business rules by

BusinessRuleDefaultPriorityIncrement

In the Master Data Manager System Administration functional area, the number the priority of each new business rule is incremented by. The default value is 10.

Number of members to apply business rules to

BusinessRuleRealtimeMemberCount

In the Master Data Manager Explorer functional area, the maximum number of members in the grid to apply business rules to at one time. The default value is 500.

For more information, see Business Rules (Master Data Services).

Notification Settings

Configuration Manager Setting

System Setting

Description

Master Data Manager URL for notifications

MDMRootURL

The URL for the Master Data Manager Web application, which is used in the link in e-mail notifications, for example http://constoso.com.

Notification e-mail interval

NotificationInterval

The frequency, in seconds, that e-mail notifications are sent. The default value is 120 seconds (2 minutes).

Number of notifications in a single email

NotificationsPerEmail

The maximum number of validation issues that will be listed in a single notification e-mail. Additional issues, if they exist, are not included in the e-mail. The full list of validation issues is available on the Review Validation Issues page in Master Data Manager.

NoteNote
This system setting is available after you upgrade the Master Data Services database following the installation of the SQL Server 2008 R2 Master Data Services June Update from the Microsoft Support Web site.

Default e-mail format

EmailFormat

The format for all e-mail notifications. The default value is HTML or 1. The database setting of 2 indicates Text.

NoteNote
You can override this for an individual user in Master Data Manager, by changing and saving the E-mail format on the user's General tab.

Regular expression for e-mail address

EmailRegExPattern

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

EmailProfilePrincipalAccount

Displays the Database Mail account to use when sending e-mail notifications. The default profile is mds_email_user.

Database Mail profile

DatabaseMailProfile

The Database Mail profile to use when sending e-mail notifications. The default value is blank.

ValidationIssueHTML

In HTML format, the text of the e-mail users get when a business rule fails validation.

ValidationIssueText

In plain text format, the text of the e-mail users get when a business rule fails validation.

VersionStatusChangeText

In plain text format, the text of the e-mail users get when the status of a version changes. Only users with Update permission to the entire model receive this e-mail.

VersionStatusChangeHTML

In HTML format, the text of the e-mail users get when the status of a version changes. Only users with Update permission to the entire model receive this e-mail.

For more information, see Notifications (Master Data Services).

Security Settings

Configuration Manager Setting

System Setting

Description

SecurityMemberProcessInterval

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. The default value is 3600 seconds (60 minutes).

For more information, see How To: Immediately Apply Member Permissions (Master Data Services).

Not Used

The following settings in the System Settings table are not used.

  • SecurityMode

  • MDSHubName

  • ApplicationLogging

  • ReportServer

  • ReportDirectory

  • BusinessRuleEngineIterationLimit

  • BusinessRuleExtensibility

  • AttributeExplorerMarkAllActionMemberCount

Change History

Content update

Added row to the Notifications section about the NotificationsPerEmail system setting.