End-to-End SQL Server Master Data Services

Play End-to-End SQL Server Master Data Services
Sign in to queue

Description

This session describes how SQL Server 2012 or 2014 Master Data Services (MDS) can be employed to implement Master Data Management (MDM). It introduces the discipline of MDM and maps common processes to the feature set of Master Data Services. It also introduces the new capabilities and features planned for SQL Server 2016. Topics include defining models, entities, attributes and hierarchies, to store and manage master data. Additionally, administrative tasks including business rules to validate data, the import and export of master data, model versioning, and permission management will be described. The two Microsoft user interfaces (the Master Data Manager web application, and the Excel add-in) are covered, in addition to T-SQL scripting opportunities to automate data integration processes. This session will be of interest to data stewards, ETL developers and ETL administrators in order to appreciate what SQL Server Master Data Services can achieve.

Day:

3

Level:

Level 300

Track:

Data Platform

Session Type:

Breakout Session

Code:

M355

Room:

Marlborough (SKYCITY)

Embed

Download

Download this episode

The Discussion

Add Your 2 Cents