Master Data Services (MDS) – SQL Server 2008 (Video Tutorial)

Leave a comment (2) Go to comments

Master Data Management (MDM) comprises a set of processes and tools that consistently defines and manages the non-transactional data entities of an organization (which may include reference data). MDM has the objective of providing processes for collecting, aggregating, matching, consolidating, quality-assuring, persisting and distributing such data throughout an organization to ensure consistency and control in the ongoing maintenance and application use of this information.

Master Data Services Installation and Configuration Video

What is Master Data Services? What is Master Data Management? Why is Master Data Management Needed?

As per Microsoft: Master Data Services (MDS) helps organizations standardize and streamline the business data customers use across their organization to make critical business decisions. MDS is a Master Data Management (MDM) application built from platform components which may be deployed as an application or extended by use of the platform components to consistently define and manage the critical data entities of an organization. MDS is an any-domain hub that supports but is not limited to domains such as product, customer, location, cost center, equipment, employee, and vendor.
Using MDS, customers can manage critical data assets by enabling proactive stewardship, enforcing data quality rules, defining workflows around data changes, notifying impacted parties, managing hierarchies, and sharing the authoritative source with all impacted systems.

What is Master Data Management?

Master Data is the reference data in a business, often described as the nouns of a business. Master data is the set of data that is used to identify aspects of business transactions and yet isn’t tied to any specific domain such as customers, sales, products or locations.

Master data is not metadata (or data that describes other data) but the list of items (known as entities) such as products, categories, subcategories, countries, sizes, colors that tend to change slowly when compared an organization’s transactional data.

Master Data Management refers to a coordinated process of managing this reference data and to the processes, policies and procedures that are part of this management process. It is important to note that the way the data is managed is relatively unrelated to the domain of the data (ie: what the data relates to in the business). Master Data Management will often involve placing this data in a centrally-managed location that provides an authoritative source for the entire organization.

Why is Master Data Management Needed?

It is common for organizations to lack a source of truth regarding the ways their data is categorized or classified. This tends to lead to reporting and operational systems that are out of sync. Most people have experienced different classifications being used to describe items in different companies, in different divisions of companies or even within different reporting systems.

Alternately, it is commonplace for users to need to re-enter data in one system that already exists in another system. Worse, that data will often need to be correlated at a later point in time.

Many organizations attempt to put business intelligence systems in place yet find that while the concept of a dimension is simple enough, the reality of obtaining a single source of truth for building the dimension is far from simple. Systems will have different coding schemes, naming schemes or grouping and consolidation methods. Faith in the information provided by the business intelligence systems that summarize this inconsistent data is soon lost.

These problems end up causing costs to the business. Mistakes that need to be manually corrected or data that needs to be manually cleaned are particularly expensive problems to deal with. Urgent corrections to deal with regulatory or compliance issues can be even more expensive

SQL Server Master Data Services

SQL Server Master Data Services provides a location, platform and process for creating an authoritative source of data for an organization. It is a highly extensible platform that both operational and analytic master data management systems can be built on.

With Master Data Services, enterprises can standardize the data that their people rely on when making critical business decisions. It provides:

  • A master data hub for central management of entities and hierarchies.
  • A web-based portal that provides secure, role-based access to the master data.
  • Detailed handling of data versioning at both the entity and hierarchy levels.
  • Integration with workflow processes to deal with business rule violations.
  • Flexible and extensible business rules to ensure the quality of data in the master data hub.

Key Points

Microsoft SQL Server Master Data Services

  • SQL Server Master Data Services is Microsoft’s implementation of tooling for master data management.
  • Master data management relates to management and ongoing stewardship of an organization’s master data.
  • Master data is typically the reference or lookup data used by applications.
  • Designing Master Data Services Solutions

    • Entities represent the nouns in sentences that describe business processes such as “Customers purchase products”.
    • Attributes are the properties associated with entities.
    • Hierarchies can be formed either from within the data in the model or explicitly.
    • Data quality should be assessed where possible to check the success of a master data management project.
    • Master data management projects tend to be more about people, processes and politics than about technology.

    Implementing Master Data Services Projects

    • Master Data Services provides permission-based security for all levels of entity-based hierarchies.
    • Business rules are used to validate data.
    • Models can be migrated between environments.
    • When data validation issues arise, workflows can be started or email notifications sent.

    Source : Microsoft Clinic

    EOF - Master Data Services (MDS) – SQL Server 2008 (Video Tutorial), SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
    Leave a comment


    1. For anyone interested, check out Master Data University, the first and only place to find online courses for Microsoft SQL Server 2008 R2, complete with video lectures and all of the materials you’ll need for Microsoft MDS.

    Leave a Reply

    Your email address will not be published. Required fields are marked *


    You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

    Notify me of followup comments via e-mail. You can also subscribe without commenting.

    Trackbacks and Pingbacks: