Microsoft SQL Server 2008 R2 Master Data Services. Written by two leading Microsoft SQL Server specialists, this book will empower you to manage and maintain the data used for critical business decisions through an understanding of Master Data Services. A comprehensive, totally practical tutorial - Ebook - Jeremy Kashel, Tim Kent, Martyn Bullerwell, Adatis Consulting Limited - Modern learning platform

E-book details

Log in, If you're interested in the contents of the item.

Microsoft SQL Server 2008 R2 Master Data Services. Written by two leading Microsoft SQL Server specialists, this book will empower you to manage and maintain the data used for critical business decisions through an understanding of Master Data Services. A comprehensive, totally practical tutorial

Jeremy Kashel, Tim Kent, Martyn Bullerwell, Adatis Consulting Limited

Ebook

Microsoft SQL Server 2008 R2 Master Data Services
- Table of Contents
- Microsoft SQL Server 2008 R2 Master Data Services
- Credits
- Foreword
- About the Authors
- About the Reviewers
- www.PacktPub.com
  - Support files, eBooks, discount offers and more
  - Why Subscribe?
  - Free Access for Packt account holders
  - Instant Updates on New Packt Books
- Preface
  - What this book covers
  - What you need for this book
  - Who this book is for
  - Conventions
  - Reader feedback
  - Customer support
  - Downloading the example code for this book
    - Errata
    - Piracy
    - Questions
- 1. Master Data Management
  - Master data
  - The need for Master Data Management
    - Manual updates
    - Different descriptions for the same attributes
    - Mergers and acquisitions
  - Master Data Management overview
  - Data quality
  - Operational and analytical Master Data Management
    - Analytical MDM
    - Operational MDM
  - Different approaches to Master Data Management
    - Transaction Hub
    - Registry
    - Hybrid
  - Data governance
  - Data stewardship
  - Politics and organizational changes
  - Summary
  - References
- 2. Master Data Services Overview
  - Master Data Services overview
  - Master Data Services architecture
    - MDS SQL Server database
    - Internet Information Services (IIS)
  - Master Data Manager
    - Accessing Master Data Manager
      - Explorer
      - Version Management
      - Integration Management
      - System Administration
      - User and Group Permissions
  - Summary
- 3. Installing and Configuring Master Data Services
  - Planning for a Master Data Services installation
    - Server topology
    - Database service account
    - Administrator account
  - Installing Master Data Services
  - Master Data Services Configuration Manager
    - Configuring Master Data Services for the first time
      - Database creation
      - Database settings
      - Web configuration
  - Installing sample models
  - Summary
- 4. Creating and Using Models
  - MDS object model overview
  - Models
    - Entities and attributes
      - Attributes
      - Domain attributes and relationships between entities
      - Creating an entity
      - Editing an entity
    - Members
      - The Master Data Manager Explorer
        
        Adding a member
        
        Editing a member
        
        Deleting members
        
        Annotating members
        
        Transactions
    - Attribute Groups
      - Creating Attribute Groups
      - Using Attribute Groups
    - Hierarchies
      - Derived Hierarchies
        
        Exploring Derived Hierarchies
        
        Adding a member in a Derived Hierarchy
      - Explicit Hierarchies
        
        Creating an Explicit Hierarchy
        
        Consolidated members
        
        Moving hierarchy members
    - Collections
      - Creating a collection
    - Master Data Services Metadata
      - Altering the default MDS Metadata
      - Viewing Metadata
      - User-defined Metadata
    - Summary
- 5. Version Management
  - Introduction to versions
    - The need for versions
    - The version interface
    - Version status
  - Creating and managing versions
    - Copying a version
    - Managing versions
    - Using versions
  - Validating versions
    - Member validation status
    - Validating a version
  - Locking, unlocking, and committing versions
    - Notifications
    - Locking versions
    - Unlocking versions
    - Committing versions
  - Managing Flags
  - Transactions
  - Summary
- 6. Importing Data into Master Data Services
  - The staging load process
    - Introduction
      - Staging tables
      - Data import security
  - Populating MDS step 1populating the staging tables
  - Creating new members
  - Creating new collections
  - Adding members to collections
  - Updating member attributes
  - Deleting a member (or collection)
  - Populating MDS step 2invoking the staging process
  - Populating MDS step 3validating the model
  - Clearing the staging tables
  - Errors in the staging process
    - Success codes
    - Warning codes
    - Error codes
  - Automating the MDS load process with SSIS
  - Summary
- 7. Business Rules and Workflow
  - Introduction to MDS business rules
    - Running business rules
    - Technical overview
  - Conditions and actions
    - Conditions
    - Actions
      - Default Value
      - Change Value
      - Validation
      - External Action
  - Business rules user interface
  - Creating business rules
    - Creating the required attributes business rule
    - Model setup
    - Creating the Store Size business rules
      - Running the Store Size business rules
  - Notifications
  - Workflow and SharePoint
    - Setup
      - SharePoint site creation
    - Store approval business rule
      - Creating the Store approval business rule
      - Creating the SharePoint custom column
      - Creating the Visual Studio project
      - Designing the SharePoint workflow
      - Adding code to the workflow
        
        Using section
        
        Declaration section
      - Deploying the workflow solution
      - Running the SharePoint workflow
  - Summary
- 8. Extracting Data from Master Data Services
  - Introduction
    - Master data delivery
  - Subscription Views
    - Formats
    - Creating Subscription Views
      - Extracting leaf and consolidated members
      - Extracting Explicit Hierarchies
      - Extracting collections
      - Extracting Derived Hierarchies
    - Subscription View maintenance
  - Delivering master data using BizTalk
    - Example scenario background
    - Creating the sample databases
    - Creating the BizTalk project
      - Building the receive schema and port
      - Building the destination schema
      - Building the map
    - Deploying the BizTalk solution
      - Receive port
      - Send port
    - Testing the BizTalk solution
  - Summary
- 9. Application Programming Interface
  - Introduction to the MDS API
    - What is a WCF service?
  - Getting started with the Web Services API
    - Creating a Web Services project
    - Exploring MDS Metadata
  - MDS assemblies
    - Creating an MDS Assemblies project
    - Setting up an MDS connection
  - Creating an MDS SharePoint Web Part
    - Setup
    - Creating the Web Part
      - Deploying the Web Part
    - Retrieving data from MDS
  - SharePoint workflow integration
    - Deploying the workflow solution
    - Running the SharePoint workflow
  - Summary
- 10. Master Data Services Security
  - Master Data Services security overview
  - User and Group Administration
    - Adding a user
    - Editing a user
    - Maintaining groups
  - User and Group Permissions
    - Function permissions
    - Model permissions
      - Administrators
      - Assigning model permissions
    - Hierarchy Members permissions
  - Summary
- Index

Title: Microsoft SQL Server 2008 R2 Master Data Services. Written by two leading Microsoft SQL Server specialists, this book will empower you to manage and maintain the data used for critical business decisions through an understanding of Master Data Services. A comprehensive, totally practical tutorial
Author: Jeremy Kashel, Tim Kent, Martyn Bullerwell, Adatis Consulting Limited
Original title: Microsoft SQL Server 2008 R2 Master Data Services. Written by two leading Microsoft SQL Server specialists, this book will empower you to manage and maintain the data used for critical business decisions through an understanding of Master Data Services. A comprehensive, totally practical tutorial.
ISBN: 9781849680516, 9781849680516
Date of issue: 2011-07-19
Format: Ebook
Item ID: e_3ci4
Publisher: Packt Publishing

select a language

Categories

E-book details