| title | Master Data Services Database | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/01/2017 | ||
| ms.prod | sql-server-2016 | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | article | ||
| helpviewer_keywords |
|
||
| ms.assetid | 5f590cc1-6ec2-4b8c-a598-03de0f6051a0 | ||
| caps.latest.revision | 6 | ||
| author | sabotta | ||
| ms.author | carlasab | ||
| manager | jhubbard |
The database contains all of the information for the [!INCLUDEssMDSshort] system. It is central to a [!INCLUDEssMDSshort] deployment. The [!INCLUDEssMDSshort] database:
-
Stores the settings, database objects, and data required by the [!INCLUDEssMDSshort] 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.
Create a Master Data Services Database
Database Object Security (Master Data Services)
Database Logins, Users, and Roles (Master Data Services)