Master Data Services Database

Applies to: SQL Server - Windows only Azure SQL Managed Instance

The database contains all of the information for the Master Data Services system. It is central to a Master Data Services deployment. The Master Data Services database:

• Stores the settings, database objects, and data required by the Master Data Services system.

• Contains staging tables that are used to process data from source systems.

• Provides a schema and database objects to store master data from source systems.

• Supports versioning functionality, including business rule validation and e-mail notifications.

• Provides views for subscribing systems that need to retrieve data from the database.

In This Section

• Leaf Member Staging Table (Master Data Services)

• Consolidated Member Staging Table (Master Data Services)

• Relationship Staging Table (Master Data Services)

• Staging Process Errors (Master Data Services)

See Also

Create a Master Data Services Database
Database Object Security (Master Data Services)
Database Logins, Users, and Roles (Master Data Services)