Master Data Services with SQL 2008 R2

What you will get out of this module:

An overview of the Master data Management

An understanding of challenges

The benefits of implementing a solution

An examination of the various competing architectures.

Guidelines on the team roles

In this module you will gain the knowledge that is key to working within MDS. A clear understanding of the terms such as Entity, Member and Attribute etc. and how they relate to each other will allow you to develop a MDS system.

Master Data Services Architecture

Master Data Services Key Terms

Master Data Services Web Interface

Master Data Services SQL Data Base

Installing Master Data Services

Creating the Master Data Services Database

Initial Configuration

Installation of Master Data Services

Configuration of Master Data Services

Create the MDS Web

Explore the Web Interface

What you will get out of this module:

An appreciation of the Architecture

An understanding of the key terms

The relationships between the objects

The installation requirements

Familiarization of the MDS Web Interface

The Model of the data is the key to success. In this module you will learn to design your data model then how to implement that design.

Modeling Concepts

Modeling Guidelines

Building a Model

Deploying a Model

How to Step by Step

Develop a Model using MDS

What you will get out of this module:

Working knowledge of Data Models

Model Development Guidelines

Model Development Major Steps

Implementation of a Module

In this module we will review the considerations for loading data into the models. We will examine the staging tables and stored procedures that may be utilized for loading data.

MDS Staging Tables

Creating New Members

Creating New Collections

Adding Members to Collections

Updating Member Attributes

Importing the Data

Validating the Model

Error Conditions

View the Staging Tables

Importing Data with SQL Server Integration Services

Run the Staging Process

Using a Stored Procedure to Initiate the Staging Process

Viewing Errors

What you will get out of this module:

How to manually load data into modules

How to created new Members and attributes with SQL

Loading data via the staging databases

An understanding of the functionality of the staging tables

The error conditions that may occur

Understanding Versions

Version Statuses

Version Validation

Version Flags

Ancestry

Validating Versions

Locking, Unlocking and Committing Versions

Create a Version

Work with Version Flags

Validate a Version

View a Version Ancestry

Lock, Unlock and Commit a Version

What you will get out of this module:

The need for Versions

Knowledge of a Version Status

How to use a Version Flag

Viewing A Version’s Ancestry

How to Lock, Unlock and Commit a Version

Business Rules Overview

How to Create A Business Rule

Business Rules Interface

Rule Expressions

Conditions and Actions

Using SharePoint Workflows

Create several Business Rules

Use Visual Studio to create a workflow called by the Business Rules

What you will get out of this module:

Understanding of Business Rules

How to code a Business Rule

Work with the Web Interface

How to create an Expression

Integrate SharePoint into the path of the workflow

Invoking complicated workflows through the use of SharePoint

Master Data Services Security Overview

Users and Groups

Administrators

Permission Levels

Best Practices

Implement Security

Test Security

What you will get out of this module:

This module will demonstrate the security of Master Data Services

Subscribing Systems

Subscription Views

Formats

Creating Views

How Subscribing Systems can Extract Data

Create a Subscription View

Subscribe to the View

What you will get out of this module:

How to use Publish Data

How to Create a Subscription View

An understanding of Formats

How a subscribing system can extract data.

Using Web Services to Interface with Master Data Services

Creating the Web Service

Errors in the Web Service

Create a Web Service Project in Visual Studio

Perform Several Operations with the Web Service

What you will get out of this module:

How to use Web Services to Interface with Master Data Services