Microsoft MDS
Profisee MDM Search   |   Register   |   Login    Profisee LinkedInProfisee TwitterProfisee FacebookProfisee YouTube
Microsoft MDS
Skip Navigation Links.
Microsoft MDS

Microsoft MDS Blog

By Profisee on 4/16/2014 10:15 AM
A worker-centric workflow provides direct feedback to data stewards when an action is required of them. This action is discrete, and does not require coordination with other activities within a larger defined process. For example, once a particular issue is corrected, a subsequent action is not immediately required. Common examples of a worker-centric process include:
By Profisee on 2/3/2014 5:31 PM

A noble goal for any software solution is to provide an out-of-the-box experience that natively meets all end user requirements. Master data management (MDM) solutions are no different, and all platforms provide interface options that dynamically react to the underlying data model to provide data stewardship functionality.

In the MDM space, data stewards are ideally experts in the data that is being managed, and can be trusted with flexible and powerful interfaces that are provided out of the box. As less sophisticated “casual” data stewards are engaged, a need arises for a more constrained interface to manage the user experience and guide stewardship activities. In a prior blog posting, we showed options for creating simple task interfaces for just such a scenario.

By Profisee on 1/27/2014 1:03 PM

Preserve Verification Data, Reduce Service Overhead with Maestro MDM

The Maestro Adapter for Dynamics CRM was specifically created to deliver powerful data stewardship and data quality capabilities to companies deploying Dynamics CRM. There are many benefits to using Master Data Maestro to master customer data for use in Dynamics CRM and other organizational systems. One such benefit helps companies maximize the value of paid address verification services.

By Profisee on 1/14/2014 2:33 PM

There are many benefits to using Profisee’s Master Data Maestro to master customer data for use in Dynamics CRM and other organizational systems. Maestro leverages the Microsoft Master Data Services (MDS) base platform, delivered as part of SQL Server, to provide a seamless enterprise-level MDM platform. Maestro Adapter for Dynamics CRM was specifically created to deliver powerful data stewardship and data quality capabilities to customers deploying Dynamics CRM, and to support the rapid transfer of data from Dynamics CRM into Microsoft Master Data Services (MDS).

By Profisee on 12/20/2013 3:22 PM

As we discussed in the first blog in this series, “Dynamics CRM Implementation with Master Data Maestro Cleansing “, Master Data Maestro’s Dynamics CRM Adapter enables you to cleanse and de-duplicate customer records loaded into your Dynamics CRM instance from various enterprise source systems. User-defined survivorship rules and processes determine which attributes of matched records from these multiple sources are used to create the master record – or “Golden Record”. Harmonization is the complimentary process of pushing data from a Golden Record back out to source system records, for ultimate operational MDM capability.

By Profisee on 12/6/2013 12:00 AM

Making the effort to load the most accurate and complete data possible into Microsoft Dynamics CRM can lower total cost of ownership and simplify later integration efforts. This endeavor can be greatly expedited by adding data management and cleansing technologies into the process before bringing the new system online. The larger and more distributed the initial customer data is, the more value these technologies can provide. While there are any number of systems that can be used to load data into a Dynamics CRM instance, this blog focuses on leveraging SQL Server Master Data Services (MDS), along with the Profisee Maestro Server and Dynamics CRM Adapter, to ensure that you start with clean data.

By Profisee on 11/6/2013 3:11 PM

Having master data centralized in a common repository is the first step in getting your master data under control. However, master data management (MDM) is more than data integration and centralization. You also need the “management” component of MDM. Most out-of-the-box solutions, MDS included, have an interface through which master data can be managed. This is great when you have a smaller number of "power" users who manage master data frequently. But what happens when you have a large number of infrequent users, or "casual" data stewards? For them, MDM is yet another application they must be aware of, navigate to, and be trained on. This poses a challenge to many organizations that are attempting to implement an MDM solution for the entire enterprise.

Ideally, there would be a way to allow these casual users to be presented with a simplified interface that is hosted within the confines of the applications or portals they are already accustomed to, with access to browse, consume, and manage master data. In this blog, we’ll present a couple of options for doing just this.

By Profisee on 10/25/2013 12:00 AM

Microsoft has now released CTP1 and CTP2 of SQL Server 2014. After downloading and installing CTP2 and probing around a bit, we discovered that there are a number of bug fixes in MDS and DQS. However, there do not appear to be any improvements to existing functionality or new features added to Microsoft’s Master Data and Data Quality products. While we don’t know for certain, it would be very unusual for any major changes to be introduced after CTP2. So it seems likely that MDS and DQS will be basically the same in SQL Server 2014.

By Profisee on 10/24/2013 12:00 AM

Big data is a hot topic in the data space today, with many of the major data vendors working to quickly release big data-capable solutions that compete with the incumbent big data platform, Hadoop MapReduce. With the speed at which new data is created, big data is real and is here to stay. Over the coming years, some of the applications of big data theory will deliver tremendous insights into the trends that exist in data generated by people and systems.

Many in the master data management (MDM) space wonder what the relationship is between big data and master data. In this blog, we’ll look at the working relationship between these two today, and propose what the future may hold. Included are examples from the perspective of B2C organizations, those most likely to be working with both master data and big data (outside of government).

By Profisee on 10/17/2013 12:00 AM

Changes are coming to Dynamics CRM! While many customers are in the midst of migration from Dynamics CRM 2011 to Dynamics CRM 2013, Profisee is working to ensure this transition is seamless with your Master Data Management system. The same Master Data Maestro maps and adapter will work for both 2011 and 2013 versions of Dynamics CRM.

By Profisee on 10/11/2013 12:00 AM

It is a common misconception that subscription views are not included when deploying a package. This is not true; subscription views are included, in certain scenarios. The behavior differs slightly depending on whether your package includes data. What follows is an overview of MDS’ behavior in both of these scenarios:

Package with no data

When a package is created from MDS that does not include any data, the subscription views that use a version flag are all included. For example, you have created the following views in your model:

By Profisee on 10/9/2013 12:00 AM

There are two common challenges when deploying business rules between environments:

  1. When rules or rule items are deleted from the lower environment, the changes are not reflected in the higher environment
  2. When rules refer to Domain Based Attribute values, those values must exist in the target model in order to edit or execute rules
We’ll tackle these issues one at a time.

By Profisee on 10/7/2013 9:48 AM

Once a solution is in production, deployments for subsequent releases must be done incrementally. MDM solutions are generally additive in nature, and most changes that are promoted involve the addition of new model artifacts (entities, attributes, business rules, etc.).

As the solution grows and matures, there will be releases that include some form of cleanup to remove artifacts that are no longer needed. From a deployment perspective, this presents a challenge. MDS Model Deployment only synchronizes changes that are in the package file. If something was removed from the development environment, it will not be in the package file, and therefore not be inspected as a part of the deployment.

By Profisee on 8/20/2013 3:25 PM

The Microsoft Master Data Services model deployment functionality is quite capable, but their packaging in the MDS 2008 R2 release was slightly limiting (or, more accurately, not limiting enough). An MDS 2012 feature called Model Package Editor provides new model deployment options that dramatically improve MDS release management flexibility. In this blog post, we will discuss key MDS Model Package Editor functionality and how it can help your organization.

By Profisee on 4/9/2012 9:29 AM

As hierarchies grow larger and larger, we are aware of many customers with millions of members rolled into hierarchies; searching to find salient members or locations in the hierarchy becomes challenging. Often we rely on validation messages and notifications to find the member needing work, but typically we just need to find a member quickly based on the task in hand and our knowledge of our dimension.

By Profisee on 3/2/2012 11:06 AM


SQL Server 2012 Master Data Services has been built to address many of the major issues of the last release (2008 R2). Fans will be pleasantly surprised by these innovations, while detractors will see many of their complaints vanish. The new features of MDS can be grouped into three major enhancements:

By Profisee on 2/7/2012 2:27 PM

Microsoft MDS is a capable master data management (MDM) application. But if you’re a first time MDS administrator, chances are your processing times have grown significantly longer since the date of implementation. Anyone’s first MDM project is highly difficult without support from an expert, but taking a few key maintenance steps in SQL Server can make a drastic improvement.

In this first “Performance” post, we’ve addressed a commonly encountered MDS performance issue pertaining to member creation.

Microsoft MDS
Platform Solutions Industries  Services Resources Contact Us  
Maestro Suite Customer / CDI Healthcare  MD Assessment Video Gallery Profisee Headquarters     US: +1 678.202.8990
Data Quality Product / PIM Hospitality  MD Accelerator MD Education Two Northwinds Center     info (at)
Golden Records Location Insurance  MD Break the Tape Library 2520 Northwinds Parkway     UK: +44 (0) 1403 824020
Maestro SDK Accounts Oil & Gas  MD Education Press Releases Alpharetta, GA 30009     uk-info (at)
CRM Adapter Hierarchy Mgmt Retail  MD Governance Events       AUS: +61 (0)2 9931 7874
Request Demo      MD Coaching Blog       aus-info (at)

© 2014 Profisee Group, Inc. All brand names and product names are the trademarks of the respective companies.
Microsoft MDS