Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

James Serra's Blog

James is a big data and data warehousing technology specialist at Microsoft. He is a thought leader in the use and application of Big Data technologies, including MPP solutions involving hybrid technologies of relational data, Hadoop, and private and public cloud. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 30 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker, having presented at dozens of PASS events including the PASS Business Analytics conference and the PASS Summit. He is the author of the book “Reporting with Microsoft SQL Server 2012”. He received a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas.

Introduction to Microsoft’s Master Data Services (MDS) Presentation Slides

Thanks to everyone who attended my “Introduction to Microsoft’s Master Data Services (MDS)” for the Data Architecture Virtual Chapter.  The recording of the session is available here.

Here is the PowerPoint presentation: Introduction to Microsoft’s Master Data Services (MDS)

I had some excellent questions at the end of the session, and here is more follow-up to my answers:

1) How do you provide high availability for MDS?  If you are using SQL Sever 2012, check out Installing Master Data Services in an AlwaysOn Environment.  To load-balance, check out Configuring a MDS load-balanced web farm using IIS v7 ARR.  MDS will work in a clustered environment if you have CU1 installed: FIX: Master Data Services is not supported on a clustered installation of SQL Server 2012.

2) What are the licensing costs for Profisee Master Data Maestro?  For that info, please contact Gene Webb, Senior Sales Executive at Profisee

3) Can you explain in more detail the “registry” hub architecture?  I’ll have a future blog post about this, but for now check out Master Data Management (MDM) Hub Architecture

Introduction to Microsoft’s Master Data Services (MDS)

Companies struggle with consolidating the same set of data from multiple systems to accurately report on critical business information. For example, having customer lists in multiple systems that often have the same customer in more than one list, sometimes with a different spelling. Master Data Services is bundled with SQL Server 2012 to help resolve many of the Master Data Management issues that companies are faced with when integrating data. In this session, James will show an overview of Master Data Services 2012, including the out of the box Web UI, the highly developed Excel Add-in, and how to get started with loading MDS with your data.

Comments

Leave a comment on the original post [www.jamesserra.com, opens in a new window]

Loading comments...