The following improvements have been made in this release of Master Data Services.
Note: Portions of the Master Data Manager web application use Silverlight. To install the version of Silverlight that works with SQL Server 2012 MDS, go here: http://go2.microsoft.com/fwlink/?LinkId=116053&v=5.0.61025.0.
Table of Contents Excel ImprovementsMatch Data before LoadingCollections UI Updated, Weights AddedSecurity SimplifiedCodes Automatically GeneratedNew Model Deployment ToolSharePoint Workflow Integration IntroducedMicrosoft Silverlight 5 RequiredInstallation is Part of SQL Server
You can now manage your master data in the Master Data Services Add-in for Microsoft Excel. You can use this add-in to load a filtered set of data from your Master Data Services database, work with the data in Excel, and then publish the data back to the
database. If you are an administrator, you can also use the add-in to create new entities and attributes.
In columns that display domain-based attributes, both the name and code are now automatically displayed.
The workflow for loading data has changed slightly. In order to load data, you must now open a new worksheet.
Changes have also been made to increase the visible workspace. The Master Data Explorer pane now closes when you load data, and information about the active worksheet has been combined into a single row at the top of the sheet.
It is now easier to share shortcut query files, which contain information about the server, the model, version, entity, and any applied filters. A new toolbar button allows you to send the shortcut query file to another user via Microsoft Outlook.
MDS can now be used more effectively to manage many-to-many relationships.
Links have been added, allowing you to more quickly access related entities. For more information, go to
The user interface (UI) for collections now uses Silverlight® and has been improved for usability.
Each collection member can have a weight value assigned. When you use the
Collections subscription view format, a Weight column displays the value set in the UI. For more information about collections, go to
To make assigning security easier, you can no longer assign model object permissions to the Derived Hierarchy, Explicit Hierarchy, and Attribute Group objects.
Derived hierarchy permissions are now based on the model. For example, if you want a user to have permission to a derived hierarchy, you must assign Update to the model object. Then you can Deny access to any entities you don’t want the user to have access
Explicit hierarchy permissions are now based on the entity. For example, if the user has Update permissions to an Account entity, then all explicit hierarchies for the entity will be updateable.
Attribute group permissions can no longer be assigned in the User and Group Permissions functional area. Instead, in the
System Administration functional area where attribute groups are created, users and groups can be given Update permission to attribute groups. Read-only permission to attribute groups is no longer available.
It is now easier to have Code attribute values automatically created for new members. To do so, edit an entity’s properties and select the
Create Code values automatically check box. Previously, you had to create a business rule to automatically create values for the Code attribute. For more information, go to
To deploy models with data, a new, higher performance command-line tool is now available. The model deployment wizard in the web application can now be used to deploy model structure only; to create and deploy packages with data, you must use the command-line
If you installed MDS at the default location, the tool is available at drive:\Program Files\Microsoft SQL Server\110\Master Data Services\Configuration\MDSModelDeploy.exe. For more information about this tool, go to
Two new features have been introduced to contribute to SharePoint workflow integration.
To work in the Master Data Manager web application, Silverlight 5.0 must be installed on the client computer. If you do not have the required version of Silverlight, you will be prompted to install it when you navigate to an area of the web application that
requires it. You can install Silverlight 5 from