Microsoft SQL Server 2012 master data services / Tyler Graham.

Format:

Book

Author/Creator:

Graham, Tyler, author.

Language:

English

Subjects (All):

SQL server.

Client/server computing.

Database management.

Relational databases.

Physical Description:

1 online resource (1 v.) : ill.

Edition:

Second edition.

Other Title:

Master data services

Place of Publication:

New York : McGraw-Hill, [2012]

Language Note:

English

System Details:

text file

Summary:

Deploy and Maintain an Integrated MDS Architecture Harness your master data and grow revenue while reducing administrative costs. Thoroughly revised to cover the latest MDS features, Microsoft SQL Server 2012 Master Data Services , Second Edition shows how to implement and manage a centralized, customer-focused MDS framework. See how to accurately model business processes, load and cleanse data, enforce business rules, eliminate redundancies, and publish data to external systems. Security, SOA and Web services, and legacy data integration are also covered in this practical guide. Install Microsoft SQL Server 2012 Master Data Services Build custom MDS models and entityspecific staging tables Load and cleanse data from disparate sources Logically group assets into collections and hierarchies Ensure integrity using versioning and business rules Configure security at functional, object, and attribute levels Extend functionality with SOA and Web services Facilitate collaboration using the MDS Excel Add-In Export data to subscribing systems through SQL views

Contents:

Cover

About the Author

About the Technical Editor

Title Page

Copyright Page

Contents at a Glance

Contents

Foreword

Acknowledgments

Introduction

What You'll Learn in this Book

About the Sample Company

About the Sample Data

Chapter 1: Introduction to Master Data Services

What Is Master Data Management?

History of Master Data Management

Overview of Other Master Data Management Solutions

ERP Systems as MDM Solutions

Specialized Master Data Management Solutions

Catering to the Titans

Microsoft's Solution to Master Data Management

New Features of MDS in SQL Server 2012

What Master Data Services Still Delivers

The Value Proposition

Summary

Chapter 2: Installation and Configuration

Determining the Initial Scope of Your Project

About the Main Street Clothing Company Implementation

Preparing the Web Server

Windows 7 Web Application Requirements

Windows Server 2008 R2 Web Application Requirements

Installing Master Data Services

Procedure: How to Install Master Data Services

About MDS Configuration Manager

Creating an MDS Database

Procedure: How to Create an MDS Database

About System Settings

Creating the Master Data Manager Web Application

Procedure: How to Create a Master Data Manager Website (Optional)

Procedure: How to Create a Master Data Manager Web Application

Procedure: How to Associate the MDS Database with the Web Application

Securing Your Web Application

Getting the Latest Version of MDS

Upgrading 2008 R2 MDS

Repairing the MDS Database

Chapter 3: Starting an MDS Project

How Do I Know Master Data When I See It?

Business Process Models

System Roles

System of Entry

System of Record

Subscribing System

Mapping the Data.

Determining What to Do with Duplicate Records

Determining Which Attributes to Manage

The Main Street Clothing Company Example

Finding a Data Steward

Leveraging the Business Process Models

Filling in the Gaps

Determining System Types

Cleansing Data for Initial Import into MDS

Leveraging the MDS Excel Add-In to Manage Your Project

Chapter 4: Creating Your Model

MDS Modeling Concepts

Building a Model

Deploying a Model

Procedure: How to Deploy a Model Using ModelDeploy.exe

About Models

About Main Street Clothing Company's Models

Procedure: How to Create a Model

About Entities

About Main Street Clothing Company's Entities

Procedure: How to Create an Entity

About Members

About Main Street Clothing Company's Members

Procedure: How to Add a Member

About Attributes

About Main Street Clothing Company's Attributes

Procedure: How to Create an Attribute

Procedure: How to Create a Domain-Based Attribute

About Attribute Groups

About Main Street Clothing Company's Attribute Groups

Procedure: How to Create an Attribute Group

Procedure: How to Reorder Attribute Groups

Using Web Services

Creating a Model

Creating an Entity

Creating an Attribute

Chapter 5: Integrating Master Data Services with Other Systems

Staging Architecture

Benefits of Entity-Based Staging

Batch Tags

Security in Staging

System Settings

About Main Street Clothing Company's Staging Process

Standard Leaf and Parent Staging Fields

Staging Import Types

Member Staging Examples

Using Staging to Deactivate Members

Loading Relationships

Relationship Table Fields

Relationship Staging Examples

Importing Data into the Staging Tables

Procedure: How to Import Data into SQL Server by Using SSIS

Initiating the Staging Process.

Procedure: How to Use Master Data Manager to Initiate the Staging Process

Procedure: How to Use Stored Procedures to Initiate the Staging Process

The End of Staging Sweep

Using Web Services to Stage Data

Errors That Occur During Staging

Procedure: How to View Staging Errors in Management Studio

Staging Errors View

Viewing the Staging Batch Table

Procedure: How to Clear the Staging Queue

Chapter 6: Working with Hierarchies and Collections

Ragged vs. Level-Based Hierarchies

Derived Hierarchies

Explicit Hierarchies

Derived vs. Explicit: Which Hierarchy Is Best?

Creating Derived Hierarchies

Procedure: How to Create a Derived Hierarchy

Procedure: How to Create a Three-Level Derived Hierarchy

Hiding Levels

System Settings for Hierarchies

Creating Explicit Hierarchies

Non-mandatory Explicit Hierarchies

Mandatory Explicit Hierarchies

Procedure: How to Create an Explicit Hierarchy

Recursive Hierarchies

Procedure: How to Create a Recursive Hierarchy

Derived Hierarchies with Explicit Caps

Procedure: How to Create a Derived Hierarchy with Explicit Cap

Collections

Weighting of Collection Members

Procedure: How to Create a Collection

Creating Hierarchies by Using Web Services

Creating a Derived Hierarchy with the MetadataCreate Operation

Chapter 7: Working with Master Data

Changes in SQL Server 2012

Viewing the Base Entity

Finding Data by Filtering

Operators

Using Matching

Sorting and Pagination

Sorting

Pagination and Other Settings

New Explorer Format

Edit One Attribute for One Member

Edit One Attribute for Multiple Members

Exporting Members

Working with Data in Hierarchies

Moving Members by Dragging and Dropping

Moving Members by Using the Clipboard.

Moving Members in a Derived Hierarchy by Updating Attribute Values

Transactions

Reviewing Transactions

Reversing Transactions

Annotations

Annotating Transactions on Update

Navigating Related Entities

Navigating Attributes

Navigating Many-to-Many Relationships

Metadata

Using Web Services to Work with Members

Retrieving Members

Creating and Updating Members

Chapter 8: Using Business Rules

Business Rules Overview

Business Rule Structure

Business Rule Workflow

Creating a Business Rule

Editing a Business Rule and Configuring a Rule's Expression

Procedure: How to Require Attribute Values

Deleting a Condition or Action

More Expression Examples

Creating Your Own Expressions

Publishing Business Rules

Procedure: How to Publish a Business Rule

Business Rule Statuses

Applying Business Rules

Procedure: How to Apply Business Rules in Explorer

Resolving Validation Issues in Explorer

Procedure: How to Validate a Version

Other Business Rule Tasks

Procedure: How to Change the Rule Name and Description

Procedure: How to Set the Rule's Priority Order

Procedure: How to Exclude Business Rules

Configuring E-Mail Notifications

Procedure: How to Configure E-Mail Notifications

Procedure: How to Configure a Business Rule to Send E-Mail

Creating and Triggering Workflows

Creating a Workflow in MDS

Viewing Change Tracking Group Reports

Triggering an External Workflow

Using Web Services to Manage Business Rules

Getting a List of Rules

Creating a Business Rule Using Web Services

Chapter 9: Creating Versions of Data

Versions Overview

Changing the Structure of Your Model

Committing Versions

Versioning for Main Street Clothing Company

Updating Your Version Name and Description.

Procedure: How to Change the Version Name and Description

Version Statuses

Procedure: How to Lock a Version

Validating a Version

Procedure: How to Resolve Validation Issues

Reviewing and Reversing Transactions

Committing and Copying a Version

Procedure: How to Commit a Version

Procedure: How to Reopen a Committed Version

Procedure: How to Copy a Version

Version Flags

Procedure: How to Create a Version Flag and Assign It to a Version

Viewing a Version's Ancestry

Procedure: How to Delete a Version

Using Web Services to Work with Versions

Returning a List of Versions

Changing the Version Status

Chapter 10: SQL Server 2012 MDS Add-in for Excel

Installing the Add-in

Procedure: How to Install the Add-in for Excel

Working with MDS Data in Excel

Procedure: How to Connect to the MDS Server and Load an Entity

Publishing Changes

Refreshing Data from the Server

Making Deletions in Managed Sheets

Combining Data

Applying Rules

Filtering Entity Results Members

Procedure: How to Load a Filtered Entity

Saving and Sharing Queries

Procedure: How to Save a Filter Query and Share It Through Outlook

Creating and Modifying Entities Rapidly

Using the Excel Add-In at the Main Street Clothing Company

Procedure: How to Create an MDS Entity from Excel Data

Making Changes to an Existing Entity

Procedure: How to Modify an Existing Entity's Structure

Configuring Add-in for Excel Settings

Configuring Data Settings

Configuring Behavior Settings

Leveraging Data Quality Matching in Excel

Chapter 11: Implementing Security

Security Overview

Security Changes in SQL Server 2012

Users and Groups

Procedure: How to Add a Group

Administrators.

Procedure: How to Change the Administrator Account.

Notes:

Bibliographic Level Mode of Issuance: Monograph

Description based on print version record.

ISBN:

9786613941619

9781283629164

128362916X

9780071797863

0071797866

OCLC:

1024274480