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
ⓘ
surface form:
SQL Server 2012
SQL Server ⓘ
surface form:
SQL Server 2014
SQL Server ⓘ
surface form:
SQL Server 2016
SQL Server ⓘ
surface form:
SQL Server 2017
SQL Server ⓘ
surface form:
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 |
Excel
ⓘ
surface form:
Microsoft Excel
SQL Server Integration Services ⓘ SQL Server Reporting Services ⓘ other line-of-business applications ⓘ |
| introducedIn |
SQL Server
ⓘ
surface form:
SQL Server 2008 R2
|
| partOf |
SQL Server
ⓘ
surface form:
Microsoft SQL Server
|
| runsOn |
SQL Server
ⓘ
surface form:
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)
Full triples — surface form annotated when it differs from this entity's canonical label.