Validation (Master Data Services)
Applies to: SQL Server (all supported versions) - Windows only Azure SQL Managed Instance
In Master Data Services, data is validated to ensure its accuracy. Some validation occurs automatically, and other validation is based on business rules that are created by administrators.
When Data Validation Occurs
Validation occurs at different times, and is displayed differently in the Master Data Services web application.
|Validation Type||Standards Determined by||When it Occurs||Displayed in the MasterData Manager web UI as||Displayed in the Add-in for Excel as||Is Data Saved to the MDS Repository?|
|Business rule validation||An MDS administrator||Automatically when a user adds or edits data.
Manually when a user applies business rules.
Manually when an administrator in the Version Management functional area of the Master Data Manager web application validates a version against business rules.
|Data type and content validation||An MDS administrator, when creating model objects (for example, an attribute's length or data type)||Automatically when a user adds or edits data||Input Errors||InputStatus||No|
|Data type and content validation||SQL Server or Master Data Services||Automatically when a user adds or edits data||Input Errors||InputStatus||No|
|Create business rules and publish them, so that data is validated against them.||Create and Publish a Business Rule (Master Data Services)|
|Validate a version of data against business rules. Administrators only.||Validate a Version against Business Rules (Master Data Services)|
|Validate specific subsets of data against business rules. All users with permission to the Explorer functional area.||Validate Specific Members against Business Rules (Master Data Services)|
|Validate specific subsets of data against business rules. All users with permission to the Explorer functional area and using the Add-in for Excel.||Apply Business Rules (MDS Add-in for Excel)|