Microsoft Master Data Services

Master Data Services (MDS)^[1] is the solution SQL Server on management of basic data. Management of basic data (master data management, MDM) includes actions taken by the organization for stay and determination of non-transactional lists of the managed main lists given for the purpose of compilation. The MDM project generally provides assessment and restructuring of internal business processes, along with implementation of MDM technology. Obtaining the reliable, centralized data available to the analysis becomes result of successfully implemented solution MDM that involves acceptance of the best business solutions.

After the correct training most of business users should purchase capability to implement the solution Master Data Services. Besides, it is possible to use MDS for management of any domain; it is not limited to management of lists of clients, products or accounts. Services MDS do not support structures for any domains directly after installation — domains, necessary for himself are defined by the user, creating for them models.

Hierarchies, the detailed security, transactions, support of versions of data and the business rule are among other functionality of services Master Data Services.

Services Master Data Services include the following components and work benches:

• Configuration manager of Master Data Services — the means used for creation and setup of databases and web applications of services Master Data Services.
• The manager of basic data — the web application used for accomplishment of administrative tasks (such as creation of model or business rule) which users for data-refresh address.
• MDSModelDeploy.exe is means which is used for creation of packets of objects of models and data for the subsequent deployment in other environments.
• Web service Master Data Services using which the developer can expand or create the user solutions Master Data Services.
• The means of Master Data Services the Superstructure for Excel used for data management and creation of new entities and attributes.

Notes