Data Correction with Data Quality Services - SQL Server Integration Services Design Patterns - page 142

Using the Data Quality Client

The Data Quality Client application is used to build and manage your knowledge
bases. It can also be used as a standalone tool for cleansing data. The tool is targeted
toward data stewards and IT professionals who own and manage data within your or-
ganization. Users of the tool will fall into three different roles (shown in Table 5-1 ),
which map to roles within the main DQS database. The functionality you can access
through the tool will depend on what role you are currently assigned to.

Table 5-1 . Data Quality Services Roles

Name SQL Role Description

DQS KB
Operator

dqs_kb_operator User can edit and execute an existing data quality pro-

ject.

DQS KB Ed-
itor

dqs_kb_editor User can perform project functions and create and edit

knowledge bases.

DQS Admin-
istrator

dqs_administrator User can perform project and knowledge functions, as

well as administer the system.

Note Members of the sysadmin role on the SQL Server instance on which DQS is
hosted have the same level of permissions as a DQS Administrator by default. It is re-
commended that you still associate users with one of the three DQS roles.

Knowledge Base Management

The options under the Knowledge Base Management section allow you to create and
maintain your knowledge bases. When creating a new knowledge base, you have the
option to create an empty knowledge base, or to base it on an existing knowledge base,
which will prepopulate the new knowledge base with the domains from the original.
Knowledge bases can also be created from a DQS file ( .dqs extension), allowing you
to back up or share knowledge bases across systems.
You'll perform three main activities when interacting with your knowledge bases
through this UI (shown in Figure 5-2 ) . These activities are available after you've cre-
ated a new knowledge base or have opened an existing one.