Learn more about SQL Server tools

mssqltips logo
 

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

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

How to version a SQL Server Master Data Services model


By:   |   Last Updated: 2016-05-19   |   Comments   |   Related Tips: More > Master Data Services

Problem

In SQL Server Master Data Services all the entities are organized in a model. Once a model is ready to be released to subscribers, it should be frozen and marked as ready for subscribers. Until a model is marked as ready, a model is typically deemed as work in progress. A standard process is required to release a completed version of the model to subscribers, which we will cover in this tip.

Solution

In this tip we will look at how to version and flag a model in SQL Server Master Data Services (MDS). A typical workflow of version management in MDS is as mentioned below:

  1. An initial version of the model is created when a new model is created and populated in MDS. This is an uncommitted version of the model.
  2. Once the model is ready, the model is generally locked by the administrator from any further changes.
  3. Business rules are then validated on the locked version of the data and post validation the model is committed.
  4. Now changes cannot be made to the committed version. This version is then flagged for use by subscribers.

So let's see how to implement this. We will assume that we have a model already in place.

Open Master Data Manager and navigate to "Version Management". Select the version and lock the model as shown in the below screenshot. Once locked the status of the model will show as "Locked".

SQL Server Master Data Services Locked version of the model

Once locked, the end users will not be able to make any changes to the version. They will see the members in the entities with a locked icon as shown in the below screenshot. So you may want to let the users know that this version has been locked from any changes. Admins would still be able to make changes to this version if needed.

SQL Server Master Data Services lock version of all attributes

Click on the Validate Version menu item, and this should bring up a screen as shown below. If you have business rules defined, you can click on the Validate button to validate the model against the business rules. The below screenshot shows that all the entities have been validated successfully. Click on the Commit button to save this version.

SQL Server Master Data Services Commit version of the model

Once the version is committed successfully, you will see a confirmation message and the Commit button will be disabled.

Successful Commit of SQL Server Master Data Services Model

Now that the version is successfully committed, we need to flag the version which the subscribers can use to detect this version as ready for use. In order to create a new flag, click on the Manage menu item and select Flags. Click on the Add button and create a new flag as shown below.

Manage version flags in SQL Server Master Data Services

Navigate back to Manage > Versions, and double click on the Flag field of the model as shown below. You will be able to see the list of flags available. Select the newly created flag and let the subscribers know. This completes the version management workflow.

Assign Flag for the SQL Server Master Data Services Model
Next Steps


Last Updated: 2016-05-19


get scripts

next tip button



About the author
MSSQLTips author Siddharth Mehta Siddharth Mehta is an Associate Manager with Accenture in the Avanade Division focusing on Business Intelligence.

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    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Learn more about SQL Server tools