Overview

Introduction

The Implement Master Data Management Solutions module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:

  1. Install and Configure Master Data Services
  2. Enable Master Data Services Feature
  3. Using MDS Configuration Manager
  4. Create MDS Model and Basic Objects
  5. Populate Entities in an MDS Model and Deploy the Model

Exercise 1 - Install and Configure Master Data Services

In this exercise, you will learn the following in Microsoft SQL Server 2012:

  • Install Master Data Services using SQL Server 2012 Setup
  • Create Master Data Services Database
  • Create Master Data Manager web application
  • Associate MDS database with Master Data Manager web application

Exercise 2 - Enable Master Data Services Feature

In this task, you will enable Master Data Services feature in the already existing SQL Server 2012 installation to install Master Data Services.

Exercise 3 - Using MDS Configuration Manager

As a post installation task, you can open Master Data Services Configuration Manager after the setup completes and all the required application are installed on the system. You can then create a master data services database, web application and connect the web application with the created master database.

In this task, you will create a Master Data Services database. You will then create a MDS web application and associate the web application with the database. You will also configure the MDS data manager web application and install Silverlight.

Exercise 4 - Create MDS Model and Basic Objects

In this exercise, you will learn the following in Microsoft SQL Server 2012:

  • Create MDS model with entities, hierarchies, attributes, and attributes group

Exercise 5 - Populate Entities in an MDS Model and Deploy the Model

In this exercise, you will learn the following in Microsoft SQL Server 2012:

  • Create MDS model with entities, hierarchies, collections, and attributes
  • Deploy the model

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.