Digi Academy

Master Data Services with SQL 2008 R2

Digi Academy
A Milano

Chiedi il prezzo
Chiedi informazioni a un consulente Emagister

Informazioni importanti

Tipologia Corso
Luogo Milano
Inizio Scegli data
  • Corso
  • Milano
  • Inizio:
    Scegli data
Descrizione

What is Master Data Management? The Need for Master Data Management Data Quality Operational and Analytical Master Data Management Master Data Management Architectural Patterns Master Data Management Team

Strutture (1)
Dove e quando
Inizio Luogo
Scegli data
Milano
Via Valtellina, 63, 20124, Milano, Italia
Visualizza mappa
Inizio Scegli data
Luogo
Milano
Via Valtellina, 63, 20124, Milano, Italia
Visualizza mappa

Cosa impari in questo corso?

Web master
Security
Management
SQL
e-Business

Programma

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



Gli utenti che erano interessati a questo corso si sono informati anche su...
Leggi tutto