Master Data Services
E56729
Master Data Services is a SQL Server component for managing, governing, and maintaining consistent master data across an organization’s systems and applications.
Statements (53)
| Predicate | Object |
|---|---|
| instanceOf |
SQL Server component
→
master data management solution → |
| allows |
definition of collections of members
→
definition of derived hierarchies → definition of domain-based attributes → definition of entities and attributes → definition of explicit hierarchies → definition of validation rules → role-based security → |
| availableIn |
SQL Server 2012
→
SQL Server 2014 → SQL Server 2016 → SQL Server 2017 → SQL Server 2019 → |
| designedFor |
centralizing master data definitions
→
ensuring consistency of key business data → managing master data across multiple systems → supporting data governance processes → |
| developedBy |
Microsoft
→
|
| hasComponent |
MDS Excel add-in
→
MDS configuration manager → MDS database → MDS web application → |
| integratesWith |
Microsoft Excel
→
SQL Server Integration Services → SQL Server Reporting Services → other line-of-business applications → |
| introducedIn |
SQL Server 2008 R2
→
|
| partOf |
Microsoft SQL Server
→
|
| runsOn |
Microsoft SQL Server Database Engine
→
|
| stores |
attributes
→
business rules → collections → hierarchies → master data entities → members → versions of master data → |
| supports |
Excel add-in
→
business rules enforcement → data governance → data stewardship → hierarchy management → master data management → security and authorization for master data → staging tables for data import → transaction logging for master data changes → version management → web-based user interface → workflow for data changes → |
| usedFor |
chart of accounts master data
→
customer master data → product master data → vendor master data → |
Referenced by (2)
| Subject (surface form when different) | Predicate |
|---|---|
|
Data Quality Services
→
|
integratesWith |
|
SQL Server
→
|
supportsFeature |