Skip to content

create-a-data-quality-project.md

Latest commit

 

History

History
61 lines (40 loc) · 2.97 KB

create-a-data-quality-project.md

File metadata and controls

61 lines (40 loc) · 2.97 KB
title Create a Data Quality Project
description Create a Data Quality Project
author chugugrace
ms.author chugu
ms.date 03/01/2017
ms.service sql
ms.subservice data-quality-services
ms.topic how-to
f1_keywords
sql13.dqs.dqproject.newdqproject.f1
helpviewer_keywords
create,data quality project
data quality project,create
ms.custom
build-2025

Create a Data Quality Project

[!INCLUDE SQL Server - Windows only ASDBMI]

[!INCLUDE support-notice]

This topic describes how to create a data quality project by using [!INCLUDEssDQSClient]. A data quality project is used to run the cleansing or matching activity in [!INCLUDEssDQSnoversion] (DQS).

Before You Begin

Prerequisites

You must have a relevant knowledge base to use in the data quality project for the cleansing or matching activity.

Security

Permissions

You must have the dqs_kb_editor or dqs_kb_operator role on the DQS_MAIN database to create a data quality project.

Create a Data Quality Project

  1. [!INCLUDEssDQSInitialStep] Run the Data Quality Client Application.

  2. In the [!INCLUDEssDQSClient] home screen, click New data quality project.

  3. In the New Data Quality Project screen:

    1. In the Name box, type a name for the new data quality project.

    2. (Optional) In the Description box, type a description for the new data quality project.

    3. In the Use Knowledge base list, click to select a knowledge base to be used for the data quality project. The Knowledge base details: <Knowledge_Base_Name> area on the right side displays the domain names available in the selected knowledge base.

    4. In the Select Activity area, click on an activity that you want to perform using this data quality project:

      • Cleansing: Select this activity to cleanse the source data.

      • Matching: Select this activity to perform matching. This activity is available only if the knowledge base selected for the data quality project contains a matching policy.

  4. Click Create to create a data quality project.

Follow Up: After Creating a Data Quality Project

After you create a data quality project, you are presented with a wizard that you use to perform the selected activity: cleansing or matching. For more information about the cleansing and matching activities, see Data Cleansing and Data Matching.