Validation (Master Data Services)

Applies to: SQL Server - 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.	Validation Errors	ValidationStatus	Yes
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

Related Tasks

Task Description	Topic
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)

See Also

Business Rules (Master Data Services)