Finding sensitive data

The first step is to discover the sensitive data in your production database. This is done by scanning the database, using out of the box patterns for the discovery.

Select Enterprise | Quality Management | Data Discovery and Modeling. The Secure Test Data Management Overview page (which we have seen in the previous chapter when the Application Data Model instance was created) appears.

Click on the Actions menu and select Sensitive Column Types. This displays the following screen:

We can see a number of out of the box instances of sensitive column types. These are patterns that help to identify data that would normally be considered confidential, such as credit card number, phone number, email ID, Social Security Number, and others.

Let us create a new sensitive column type. For example, select PHONE_NUMBER and click on Create Like....

Name the new sensitive column type appropriately. In the Search Patterns section, whatever is specified in Column Name or Column Comment...