SQL Server 2008 R2. Master Data Services. Pierre-Louis Usselmann, Ben Watt SOGETI Switzerland firstname.lastname@example.org, email@example.com. Agenda. Sogeti 2‘ The problems with Data 2‘ What is Master Data ? 3‘ Master Data Management 5‘ Master Data Services 10‘
Master Data Services
Pierre-Louis Usselmann, Ben Watt
Sogeti and Business Intelligence
€ 8’710 Million
92’000 employeesCapgemini Group
Answer to all IT needs that require Proximity:
* Technical Assistance * Small/Medium Projects * Maintenance
“Big deals” IS
Business Process Outsourcing
Design & Integration of Enterprise Solutions
Technological Transformation Program
Economic Performance Improvement
The Problems with Data
It takes us too long to introduce
products. Product information is in
too many places, and we don’t have
a system or process for managing all
of the information that we need to
offer our products.
We have customer data spread
across many systems. We don’t
know which data is right, and we
can’t see our complete relationship
with our customers.
What is it ?
What is MDM ?
Becomes a central, application independent resource
Ensures consistent master information across transactional and analytical systems
Simplifies ongoing integration tasks and new application development
Addresses key issues such as data quality and consistency proactively rather than “after the fact” in the data warehouseWhat is MDM?
MDM is the discipline of providing an authoritative source for referential data in your organization.
MDM is a continuous process, involving
Technology & Tools
MDM objective is creating and maintaining consistent and accurate lists of Master DataWhat is MDM?
Creating and maintaining a high quality, consistent set of Master Data leads to
Coherent and correct reporting & regulatory compliance
An authoritative source of information used throughout your organization
The ability to evolve Master Data to accommodate changing business needs
MDM can also facilitate the merging of multisource environments
e.g. as a result of mergers and acquisitionsMDM Benefits
Concepts and Features
Entities: Region, Country, Status
Members:France, Germany, Hungary, …
Attributes: Population, Square km, …
Hierarchy: Country →Region (derived)Country → Sales Volumes (explicit)
Workflow: Business Rules
Security: User Access
+41 (0) 18.104.22.168
+41 (0) 61.205.41.00