Microsoft SQL Server Master Data Services: Difference between revisions

Revision as of 16:33, 30 October 2017

Revision as of 00:28, 16 May 2020

Line 10:

Master Data Services allows the master data to be categorized by hierarchical relationships, such as employee data are a subtype of organization data. Hierarchies are generated by relating data attributes. Data can be automatically categorized using rules, and the categories are introspected programmatically. Master Data Services can also expose the data as [[Microsoft SQL Server]] [[view (database)|views]], which can be pulled by any [[SQL]]-compatible client. It uses a role-based access control system to restrict access to the data. The views are generated dynamically, so they contain the latest data entities in the master hub. It can also push out the data by writing to some external journals. Master Data Services also includes a web-based UI for viewing and managing the data. It uses [[SilverLight]] in the front-end and [[ASP.NET]] in the back-end.{{cn|date=January 2015}}

Master Data Services also includes certain features not available in the Stratature +EDM product.{{fact|date=October 2017}} It gainsprovides a [[Web service]] interface to expose the data, as well as an [[API]], which internally uses the exposed web services, exposing the feature set, programmatically, to access and manipulate the data. It also integrates with [[Active Directory]] for authentication purposes. Unlike +EDM, Master Data Services supports [[Unicode]] characters, as well as support multilingual user interfaces.{{cn|date=January 2015}}

SQL Server 2016 introduced a significant performance increase in Master Data Services over previous versions.<ref>http://www.faceofit.com/why-is-sql-server-2016-is-faster-than-ever</ref>