Adding Databases Using ODBC to Include When Searching for Personally Identifiable Information

To add an ODBC Database Connection String first select Other via ODBC from the Database Type dropdown by clicking on the down arrow next to the Database Type field, then click the Configure button and enter your database connection information.  

Establish the fields below to configure a connection with a PostgreSQL database:

Name	Description
Database Name
User Name
Password

Additional Options:

When entering multiple entries, use a semicolon as the delimiter between entries.

Name	Description
TimeoutMillisec	Specify the number of milliseconds to wait for a SQL statement to execute before returning to the application. The syntax is: TimeoutMillisec=n (where n is the number of milliseconds). e.g. to specifiy a timeout of 10 seconds you would enter: TimeoutMillisec=10000;
PreFetchRows	Forces the application to fetch rows in bulk rather than retrieving records one by one (which is the default). The syntax is: PreFetchRows=n (where n is the number of rows). e.g. to fetch 5 rows at a time you would enter: PreFetchRows=5.

 

Press Test Connection. If successful, press OK and you will be taken back to the View and Manage Databases to search screen. Press Add to add the database connection string.

Additional Information

To view or modify this setting, click the Configuration ribbon, then the Settings button then the Databases page.  For additional settings please refer to View and Manage Databases to Search or Settings to Customize Your Experience.