Category Archives: MDS/MDM

Data cleansing in SSIS, DQS, and MDS

Posted on May 9, 2013 by

Data cleansing can be done via SSIS as well as Data Quality Services (DQS) and Master Data Services (MDS).  The lines are a bit blurred when talking about data cleansing using SSIS, DQS and MDS.  In what product should data … Continue reading →

Posted in DQS, MDS/MDM, SQLServerPedia Syndication, SSIS | 1 Comment

Profisee Master Data Maestro

Posted on March 7, 2013 by

I have been using Microsoft’s Master Data Services (MDS) on a daily basis for the last 8 months.  I also have been using Microsoft’s Data Quality Services (DQS) for the last couple of months.  While both products are very good and … Continue reading →

Posted in DQS, MDS/MDM, SQLServerPedia Syndication | 2 Comments

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

Posted on February 12, 2013 by

Thanks to everyone who attended my presentation “Introduction to Microsoft’s Master Data Services (MDS)” at the Houston Area SQL Server User Group Monthly Meeting. Here is the PowerPoint presentation: Introduction to Microsoft’s Master Data Services (MDS). Introduction to Microsoft’s Master Data Services (MDS) … Continue reading →

Posted in MDS/MDM, Presentation, Session, SQLServerPedia Syndication | Leave a comment

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

Posted on February 11, 2013 by

Tomorrow (Tuesday, Feb 12th) at 11:30am CST, I will be presenting the session “Introduction to Microsoft’s Master Data Services (MDS)” at the Houston Area SQL Server User Group Monthly Meeting.  Below is the abstract.  I will be presenting in person but you … Continue reading →

Posted in MDS/MDM, Presentation, Session, SQLServerPedia Syndication | Leave a comment

MDS Error SYSERR207 after SQL Server 2012 SP1 Upgrade

Posted on January 10, 2013 by

After upgrading to SQL Server 2012 SP1, I ran into a bug in Master Data Services (MDS) that applies only to models that are deployed or created after SP1 is applied (models deployed or created before SP1 is applied are … Continue reading →

Posted in MDS/MDM, SQLServerPedia Syndication | Leave a comment

Master Data Management (MDM) Hub Architecture

Posted on January 8, 2013 by

The Master Data Management (MDM) hub is a database with the software to manage the master data that is stored in the database and keep it synchronized with the transactional systems that use the master data.  There are three basic styles … Continue reading →

Posted in MDS/MDM, SQLServerPedia Syndication | Leave a comment

MDS: The Microsoft SQL Server license has expired

Posted on January 3, 2013 by

When installing Master Data Services (MDS) in SQL Server 2012 or installing SQL Server 2012 sp1 (and possibly a CU), you might see the message “The Microsoft SQL Server license has expired” when trying to pull up the MDS web … Continue reading →

Posted in MDS/MDM, SQLServerPedia Syndication | 3 Comments

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

Posted on December 20, 2012 by

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 … Continue reading →

Posted in MDS/MDM, Presentation, Session, SQLServerPedia Syndication | Leave a comment

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

Posted on December 17, 2012 by

I will be presenting the session “Introduction to Microsoft’s Master Data Services (MDS)” at the Data Architecture Virtual Chapter on Thursday, Dec 20th, at Noon CST.  Below is the abstract.  It will be a remote presentation that you can join online.  Details … Continue reading →

Posted in MDS/MDM, Presentation, Session, SQLServerPedia Syndication | Leave a comment

Master Data Services Web Services API Error

Posted on November 20, 2012 by

In Master Data Services (MDS), I received an error when using C# code in the script task in SSIS 2012 to call the MDS web services API: To fix this, I had to edit the web.config in C:\Program Files\Microsoft SQL … Continue reading →

Posted in MDS/MDM, SQLServerPedia Syndication, SSIS | Leave a comment