DQS and MDS are both SQL 2012 features supported by BI and Enterprise editions. Data Quality Services (DQS) can be used by business users and IT professionals to maintain the quality of their data and to ensure that the data is suited for their organization’s business usage. Master Data Services (MDS) is a SQL Server feature for master data management (MDM). MDM is used to discover non-transactional lists of data, with the goal of assembling maintainable master lists.
Want to save money on DQS & MDS and have less overhead for general support and maintenance? Talk to our experts!
In this post I will guide you through the configuration process of those features and the integration of DQS and MDS. If you haven’t installed them yet use the installation CD\ISO file and add the features during SQL Server installation process.
And to save you the trouble, I’ve prepared a new version of SQL Server 2012 w/ BI Stack template with these features.
So let’s begin!
This will open an installation script; all you have to do is type in a Data master key password.
When the script finishes running you can start using Data Quality client located under the same folder in the Start menu.
On Windows Server 2008 / 2008 R2, open the Server Manager and add the Web Server (IIS) role and the following required role services:
Web Server
– Common HTTP Features
Static Content
Default Document
Directory Browsing
HTTP Errors
– Application Development
ASP.NET
.NET Extensibility
ISAPI Extensions
ISAPI Filters
– Health and Diagnostics
HTTP Logging
Request Monitor
– Security
Windows Authentication
Request Filtering
– Performance
Static Content Compression
– Management Tools
IIS Management Console
Add the following features:
– .NET Framework 3.0 Features
– WCF Activation
HTTP Activation
Non-HTTP Activation
– Windows Process Activation Service
Process Model
.NET Environment
Configuration APIs
Want to save money on DQS & MDS and have less overhead for general support and maintenance? Talk to our experts!
Create Service Accounts:
Create a service account for the Master Data Manager Web application. You must specify an identity for the application pool in which the application runs.
Click on OK and continue.
Congratulations! This is how your web application will look:
Want to save money on DQS & MDS and have less overhead for general support and maintenance? Talk to our experts!
In order to do this we need to go back to the Master Data Services Configuration Manager and navigate to the web configuration tab. Choose your web application and database, and click on the Enable integration with Data Quality Services button.
Great! You successfully integrated MDS and DQS!
And to save you the trouble I’ve prepared a new version of the SQL Server 2012 w/ BI Stack template that contains these features.