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 →
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 →
The Master Data Services add-in for Excel has Data Quality Services functionality to help you match data before publishing it to the MDS repository. When you make a connection, if a DQS database is installed on the same instance of … Continue reading →
SQL Server Data Quality Services (DQS) is a knowledge-driven data quality product that is new to SQL Server 2012. The technology was from Microsoft’s acquisition of Zoomix in 2008. DQS enables you to build a knowledge base and use it to perform … Continue reading →
Microsoft SQL Server Master Data Services (MDS) is a Master Data Management (MDM) product from Microsoft. Master Data Services is the rebranding of the Stratature MDM product titled +EDM, which Microsoft acquired in June 2007. Master Data Services is architecturally … Continue reading →
SQL Server Master Data Services (MDS) has a number of enhancements in SQL Server 2012: Improved web user interface – If you are a current user of MDS in SQL Server 2008 R2 you know that it’s pretty difficult to … Continue reading →