Importing Data into Master Data Services | Microsoft SQL Server 2008 R2 Master Data Services

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Microsoft SQL Server 2008 R2 Master Data Services

4.3 (4)

Microsoft SQL Server 2008 R2 Master Data Services

4.3 (4)

Overview of this book

Microsoft SQL Server 2008 R2 Master Data Services

Microsoft SQL Server 2008 R2 Master Data Services

Credits

Credits

Foreword

Foreword

About the Authors

About the Authors

About the Reviewers

About the Reviewers

www.PacktPub.com

www.PacktPub.com

Preface

Preface

Free Chapter

Master Data Management

Master Data Management

Master data

The need for Master Data Management

Master Data Management overview

Data quality

Operational and analytical Master Data Management

Different approaches to Master Data Management

Data governance

Data stewardship

Politics and organizational changes

Summary

References

Master Data Services Overview

Master Data Services Overview

Master Data Services overview

Master Data Services architecture

Master Data Manager

Summary

Installing and Configuring Master Data Services

Installing and Configuring Master Data Services

Planning for a Master Data Services installation

Installing Master Data Services

Master Data Services Configuration Manager

Installing sample models

Summary

Creating and Using Models

Creating and Using Models

MDS object model overview

Models

Version Management

Version Management

Introduction to versions

Creating and managing versions

Validating versions

Locking, unlocking, and committing versions

Managing Flags

Transactions

Summary

Importing Data into Master Data Services

Importing Data into Master Data Services

The staging load process

Populating MDS step 1—populating the staging tables

Creating new members

Creating new collections

Adding members to collections

Updating member attributes

Deleting a member (or collection)

Populating MDS step 2—invoking the staging process

Populating MDS step 3—validating the model

Clearing the staging tables

Errors in the staging process

Automating the MDS load process with SSIS

Summary

Business Rules and Workflow

Business Rules and Workflow

Introduction to MDS business rules

Conditions and actions

Business rules user interface

Creating business rules

Notifications

Workflow and SharePoint

Summary

Extracting Data from Master Data Services

Extracting Data from Master Data Services

Introduction

Subscription Views

Delivering master data using BizTalk

Summary

Application Programming Interface

Application Programming Interface

Introduction to the MDS API

Getting started with the Web Services API

MDS assemblies

Creating an MDS SharePoint Web Part

SharePoint workflow integration

Summary

Master Data Services Security

Master Data Services Security

Master Data Services security overview

User and Group Administration

User and Group Permissions

Summary

Index

Index

Creating new collections

As we saw in Chapter 4, a collection is a grouping of members that isn't defined by one of the existing attributes. Creating collections is very similar to the process for creating new members. The syntax is exactly the same, other than setting the MemberType_ID to 3, populating the MemberName column with the name of the collection, and populating the MemberCode column with a unique code for the collection. The syntax for this can be seen shortly.

In this example, we are creating a new collection for stores where we want to include a marketing campaign named "2011 Campaign Targets":

/* Create a new collection in the staging tables */
USE MDS -- replace with the name of your master data repository
GO

/* Declare the variables for use in the insert statement */
DECLARE @ModelName nvarchar(50)
DECLARE @EntityName nvarchar(50)

/* Set the variables appropriately */
SET    @ModelName  = 'Store' 
SET    @EntityName  = 'Store'

/* Insert records into the staging table. ...

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Microsoft SQL Server 2008 R2 Master Data Services

Search

Your notes and bookmarks