Master Data Services Database

APPLIES TO: yesSQL Server (Windows only) noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

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

See Also

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