Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Approval Workflow in Master Data Services 2016 using Change Sets - Part 2


By:   |   Read Comments   |   Related Tips: More > Master Data Services

Attend our free MSSQLTips Webcast - How to Simplify Routine SQL Server Administration Tasks


Problem

In part 1 of this tip, we introduced the concept of the approval workflow in Master Data Services (MDS) 2016 using change sets. The second part will focus on how an administrator can inspect a change set and how to approve or reject it.

Solution

To learn more about creating a change set from a user perspective, please read the first part of this tip: Approval Workflow in Master Data Services 2016 using Change Sets - Part 1. In this tip will continue with the change set created in the first part.

SQL Server 2016 Preview

At the time of writing, SQL Server 2016 is still in preview (currently Release Candidate 3 (RC3) has been released). This means functionality or features of Master Data Services might change, disappear or be added in the final release.

Approving a Change Set in SQL Server Master Data Services

When you're an entity administrator, you will receive a notification when someone has submitted a change set for your entity. Currently there's little documentation about how this actually works. When you browse to the entity, you can view the submitted change set in the Changesets pane. The status is Pending as it's waiting for approval.

View change set in SQL Server 2016 Master Data Services

If you click on the change set, you can view the details. You can either approve or reject the change set.

View the details of the changesets to approve or reject in SQL Server 2016 Master Data Services

When you approve the change set, the changes are made to the entity. In this case, the 4 members are added to the entity. You probably need to refresh the browser to see the changes.

Changes are approved and made in SQL Server 2016 Master Data Services

The change set itself has disappeared from the list. The user who submitted it can still see it though, now with the status committed.

Committed change set in SQL Server 2016 Master Data Services

NOTE - You don't need to be an entity administrator to approve change sets. Members with higher permissions levels - such as super users for example - can also manage change sets.

Rejecting a Change Set in SQL Server Master Data Services

Let's create a new change set (with the user that's not an administrator) to illustrate the process when a change set is rejected.

Create new change set in SQL Server 2016 Master Data Services

You can easily see the new change between the existing members.

See all changesets in SQL Server 2016 Master Data Services

As an administrator, you can now reject the change set.

Reject change set in SQL Server 2016 Master Data Services

The change set disappears again from the list and the changes are not applied of course. Unfortunately, there's no option to give a comment on why you rejected the change set. For example, there was a typo in the description. The user who created the change set can view it in the list with the status rejected.

Rejected status on the Manage Changesets interface in SQL Server 2016 Master Data Services

Be aware that in the Manage Changesets screen, you can only view your own change sets. So as an administrator, you still only see your own change sets. It would have been nice if you could also see submitted change sets of other users, so you can easily manage and approve/reject them.

Apply and Un-apply a Change Set in SQL Server Master Data Services

One feature of change sets has been unmentioned so far: the ability to apply or unapply a change set. The principle is straight forward: when you apply a change set, you see the changes as they will be applied to the entity. If you unapplied a change set, you view the entity data in its current state. Let's quickly update a row to see the effect.

Select a changeset in SQL Server 2016 Master Data Services

By default, the change set is applied and you can see the change marked in yellow.

Update to Changeset in SQL Server 2016 Master Data Services

When you click on Unapply in the Changesets pane, the current state of the data is shown.

Unapplied change set in SQL Server 2016 Master Data Services

You can also apply rejected change sets. It's also possible to apply a change set from the Changesets menu. If you do so, you are immediately taken to the entity to view the changes.

The ability to apply or unapply a change set is not only important for the user, but also for the entity administrator. Using Apply the administrator can easily inspect the changes before the change set is approved or rejected.

Excel Add-in for Master Data Services Changesets

The Master Data Services Excel Add-in also supports change sets, but only from the user perspective. In other words, you can only view your own change sets. Current administrators have to use the browser to approve or reject change sets. In the Publish and Validate section of the ribbon, there's an action to show or hide the change sets panel.

Show Changeset for SQL Server 2016 Master Data Services in Excel

When you edit data of the entity and you publish it to the server, you'll get a dialog asking to specify a change set.

Publish changes to SQL Server 2016 Master Data Services from Excel

At the time of writing, there seems to be a bug in the Changesets pane, causing it to stay empty. However, if you hide it and show it, it very briefly shows some contents, but then they disappear again. I was able to grab a screenshot before the contents disappear:

Master Data Explorer in Excel for SQL Server 2016 Master Data Services

Let's hope this bug gets resolved soon, so that the add-in can fully support change sets. Make sure to have always the latest version of the add-in.

Conclusion

In this tip we covered changesets from the admin perspective: we saw how we could approve or reject changes made to an entity. We also learned how we could apply or unapply a changeset to inspect the changes that would be made by the changeset. At the end, we briefly discussed the current abilities of the MDS Excel Add-in.

Next Steps
  • Try it out yourself! Create a change set and familiarize yourself with all of the different statuses and actions. Also read part 1 to get up to speed with change sets.
  • You can find more Master Data Services tips in this overview.
  • For more SQL Server 2016 tips, you can use this overview.


Last Update:


signup button

next tip button



About the author
MSSQLTips author Koen Verbeeck Koen Verbeeck is a BI professional, specializing in the Microsoft BI stack with a particular love for SSIS.

View all my tips
Related Resources





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


SQL tips:

*Enter Code refresh code     



Learn more about SQL Server tools