---
title: 7   Sensitive Data Discovery
slug: singleconnect-2-16/7-sensitive-data-discovery
description: Learn how to use the Sensitive Data Discovery tool effectively with this comprehensive document. From creating a datasource and defining patterns to initiating data discovery and viewing the discovered data, get step-by-step instructions on maximizing the
docTags: 
createdAt: 2020-08-04T14:02:33.000Z
---



You can use Sensitive Data Discovery to discover important data in a database.

**Creating Datasource**

The database that will be searched for sensitive data must be defined in Single Connect with credentials to get schema, table and column names.

1\.   Log in to the Single Connect GUI
2\.   Navigate to Administration > Datasource Manager
3\.   Enter the Datasource name, description, connection URL, username and password
4\.   Click on the “Test Connection” button to test
5\.   Click Save button to save the connection information

::Image[]{src="https://api.archbee.com/api/presign/g9cApVza9NIhSh0pjZYtA/SA8oG6ZnavwuYiOtdqBti_image.png" size="84" caption="Creating Datasource" position="center" showCaption="true"}

**Creating Pattern**

Most used patterns are defined in Single Connect. 

Different patterns can be added manually with the following steps:


1\.   Log in to the Single Connect GUI
2\.   Navigate to Sensitive Data Discovery
3\.   Open the “Patterns” tab
4\.   Enter in the Pattern’s Name, Lookup Type and Validation Type
5\.   Save

::Image[]{src="https://api.archbee.com/api/presign/g9cApVza9NIhSh0pjZYtA/AeW1NU2fzDMjpl7Eaa_kb_image.png" size="84" position="center" showCaption="false"}

 




**Data Discovery**


Discovery processes are applied on selected tables by determining the percentage of expected matched data and number of rows to be scanned.

1. Log in to the Single Connect GUI
2. Navigate to Sensitive Data Discovery
3. Open the Discovery tab
4. Select Database, Schema, Table, Pattern, Sample Data Count and Expected Matched Percentages
5. Click the Discover button

::Image[]{src="https://api.archbee.com/api/presign/g9cApVza9NIhSh0pjZYtA/IX1YgtyeVAMqgWsokHUXX_image.png" size="84" position="center" showCaption="false"}

To see the discovered data, follow the steps below:


    6\. Click the Options button of the discovered pattern at “Discovery Result”
    7\. Select “Show Details” 



::Image[]{src="https://api.archbee.com/api/presign/g9cApVza9NIhSh0pjZYtA/SrB_kMyNruGkpEJ63MEja_image.png" size="60" caption="Discovered Data " position="center" showCaption="true"}