Technical Library | 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 | TRITON AP-DATA | Version 8.3.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
Database table or CSV file
Field
Description
Select up to 32 fields from a table
Select this option if you want to select the fields to fingerprint.
1.
From the drop-down list, select the table that contains the fields of interest. CSV files are preselected.
2.
Select the field(s) you want to fingerprint. These correspond to columns in the table.
You can select up to 32 fields for any given table.
To change the displayed name of the field(s), click Modify Displayed Names, then edit the names as desired. (For Database Table only.)
You can view the SQL query that was generated for your selection. This appears under Selection as SQL Query.
Click View Sample Data to make sure that the correct information is fingerprinted.
Use the following SQL query to select records
Select this option if you want to generate your own SQL query. You can either type your own query or click Copy Above Query then modify it. Be sure to 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. When you click Next, the system validates your SQL query.
 
* 
Tip 
When you select the fields to fingerprint, be sure to follow the guidelines in Selecting the data to fingerprint. For example, 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; however, there is a workaround.
1.
Select the Select up to 32 fields from a table option.
2.
Select the desired table and fields.
3.
Copy the query from the field labeled, Selection as SQL query.
4.
Select the Use the following SQL query to select records option.
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 2016 Forcepoint LLC. All rights reserved.