Blog Post: Installing and Configuring Data Quality Services

 

After you’ve downloaded Denali CTP3, it’s time to install DQS!

Here you can find some important information that will help you install and configure DQS successfully.

Data Quality Services (DQS) contains three components: DQS server, DQS client, and a DQS Cleansing SSIS component. The DQS server is installed on top of the SQL Server Database Engine, and includes two databases: DQS_MAIN and DQS_PROJECTS. DQS_MAIN db contains all the DQS stored procedures, its engine and the published knowledge bases. The DQS_PROJECTS db contains all the data quality projects information. The DQS client is a standalone application that enables you to connect to a DQS server, providing you with a highly-intuitive graphical user interface to perform your data-cleansing tasks, as well as other administrative tasks related to DQS. The DQS Cleansing SSIS component enables you to integrate the DQS functionality into an SSIS data flow, for batch execution. Each of these 3 components can be installed on separate machines, or on the same one – according to your needs. Refer to the DQS Help documentation for additional details on DQS and how it can be used.

All DQS components are installed through the SQL Server Denali Setup. Watch this video to walk through the DQS installation and configuration, step by step. For more detailed information, refer to the DQS Installation Guide.

Please pay attention: in order to complete the DQS server installation, some post-installation steps must be performed. Otherwise, DQS server will not be functional. These steps are explained in the resources mentioned above.

Do you experience any issues during installation? Check this page for troubleshooting, refer to CTP3 release notes, or contact us.

 

Enjoy!

The DQS Team

Sienna Miller Cindy Taylor Halle Berry Catherine Bell Tessie Santiago