Documentation | Support

Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Classifying Content > Database fingerprinting > Database Fingerprinting Wizard - Field Selection
Database Fingerprinting Wizard - Field Selection
Administrator Help | Forcepoint DLP | Version 8.5.x
This screen varies depending on whether you are defining a fingerprint for a database table, Salesforce site, or CSV file.
*
Database table or CSV file
*
Salesforce site
After clicking Next on this page, see Database Fingerprinting Wizard - Scheduler.
Database table or CSV file
1.
Mark Select up to 32 fields from a table to select the fields to fingerprint.
a.
Use the drop-down list to select a table. CSV files are preselected.
b.
Select one or more fields to fingerprint. These correspond to table columns.
Select up to 32 fields per table.
*
(Database tables only) To change the displayed name for one or more fields, click Modify Displayed Names.
*
Review the SQL query that was generated for your selection under Selection as SQL Query.
Click View Sample Data to make sure that the correct information is fingerprinted.
2.
Select Use the following SQL query to select records to construct a custom SQL query.
*
Enter the query or click Copy Above Query, then modify the copied string.
*
Consult a database administrator when formatting the query, to make sure it doesn't create any functionality, performance, or stability issues.
Click View Sample Data to make sure that the correct information is fingerprinted.
3.
Click Next to continue. The system validates the SQL query.
 
* 
Tip 
When selecting the fields to fingerprint, be sure to follow the guidelines in Selecting the data to fingerprint. Avoid fingerprinting short values, columns with repetitive values, and uninteresting or irrelevant values.
* 
Note to Informix users
The system cannot fingerprint Informix tables that have names containing a backslash character. There is a workaround, however.
1.
Mark Select up to 32 fields from a table.
2.
Select the table and fields.
3.
Copy the query from the Selection as SQL query field.
4.
Mark Use the following SQL query to select records.
5.
Paste the query into the box.
6.
Surround the table name with double quotes. For example:
SELECT "name","id","cc","phone" FROM "blade2\informix".custdb.

Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Classifying Content > Database fingerprinting > Database Fingerprinting Wizard - Field Selection
Copyright 2017 Forcepoint. All rights reserved.