Architecture of Master Data Services in Microsoft SQL Server 2008 R2

1. Required Slide SESSION CODE: BIE203 Architecture of Master Data Services inMicrosoft SQL Server 2008 R2 John McAllister Group Program Manager Microsoft Corporation

2. Today’s Agenda Discuss architecture Build a solution

3. What is the problem? You need reliable datathat you can manage and share– an authoritative source

4. How does the problem present itself? Which is the real XYZ Corp? Resolve XYZ Corp’s address Does product xrb019 = fft019? Add 15 attributes to product xrb019 Information workers can’t edit dimensions ERP – USA ERP – Europe Warehouse or analytic app Operational MDM Difficulty coordinating multiple systems Difficulty managing dimensions Analytic MDM

5. How does MDS help solve the problem?

6. MDS Logical Architecture Web UI (Stewardship & Administration) Service Adapter Public WCF Endpoint WCF Service Implementation Business Logic & Data Access Configuration Manager SQL Mail Notifications SQL Server 2008 R2 Procedures, Functions Staging Tables Models Master data Application Security Transactions history SharePoint Workflows Managed Schema Subscription Views

7. Example Deployment ERP MDM Server Web User Real-time (BizTalk) Modeling, Stewardship Application (Service) CRM SharePoint Workflow Database Bulk (SSIS) Cube Dimensions Outlook Email Notification

8. What do I need to do, Really? • Decide what problem to solve • What data? • How does it integrate? • Build a model • Load data • Refine the model • Integrate

9. What problem do I want to solve? • Start small • Limit the number of interfaces • Find something with solid business justification

10. Build a Model • Oh no! Not another model! • MDM Core Concepts • Model – A container for all other MDM objects – think schema • Entity – A group of items related by a similar type – think table • Member – An individual data item – think row • Attributes – A description of a member – think column • Hierarchy - an implicit or explicit containing relationship between members • Rule – A declarative condition or action on a member

11. Create a model called location • Create attributes called location type, square feet • Build a hierarchy based on location type Build a Model DEMO

12. Location Model Entity Location _________________ Code Name Location Type Square Feet Location Type _________________ Code Name

13. Move data into Staging Tables • Process Staging Load Data DEMO

14. Business Rules • Establish a notification process • Apply Security Refine the Model DEMO

15. Batch • Data in (Staging) • Data out (Subscriptions) • Transactional • API • BizTalk Integrate DEMO

16. Blank Background optionfor use with content that extends over Purple line art PowerPoint Guidelines • Font, size, and color for text have been formatted for you in the Slide Master • This template uses Calibri, a standard Windows Vista/7 and Office 2007/2010 font • Use the color palette shown below Primary Secondary SAMPLE FILL SAMPLE FILL SAMPLE FILL Sample Fill Sample Fill Sample Fill Sample Fill Sample Fill Sample Fill Sample Fill Sample Fill Sample Fill Sample Fill

17. PowerPoint TemplateSubtitle color Example of a slide with a subhead • Set the slide title in “All Caps” • Set subheads in “Sentence case” • Generally set subhead to 28pt or smaller so it will fit on a single line • The subhead color is defined for this template but must be selected; In PowerPoint 2007, it is the sixth font color from the left Hyperlink color: www.microsoft.com

18. Slide for Showing Software Code Use this layout to show software code The font is Consolas, a monospace font The slide doesn’t use bullets but levels can be indented using the “Increase List Level” icon on the Home menu

19. Table Format

20. Bar Chart Example

21. Pie Chart Example

22. Line Chart Example

23. Area Chart Example

24. Demo Title Name Title Company DEMO

25. Video Title VIDEO

26. Customer Title Name Title Company CUSTOMER

27. Partner Title Name Title Company PARTNER

28. Announcing Title ANNOUNCING

29. Required Slide Resources Learning • Sessions On-Demand & Community • Microsoft Certification & Training Resources www.microsoft.com/teched www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers • http://microsoft.com/technet • http://microsoft.com/msdn

30. Required Slide Complete an evaluation on CommNet and enter to win!

31. Sign up for Tech·Ed 2011 and save $500 starting June 8 – June 31st http://northamerica.msteched.com/registration You can also register at the North America 2011 kiosk located at registrationJoin us in Atlanta next year

32. © 2010 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

33. Required Slide