Relational Database Profile
Define the type and location of a relational database.
Database Settings

Database type
Type of database to use, SQL server or Oracle.
Default value: SQL server
For SQL Servers
Server name
Name of the server containing the database.
Database name
Name of the database.
For Oracle Servers
Connection type (Oracle)
Type of connection to connect to the Oracle database; TNS or data source.
Schema
Schema of the database.
Prefix
Prefix to add to the tables.
Test connection
Test the connection to the server and database. When connection is valid, a list of available tables is loaded.
Authentication type
Type of authentication to use; SQL server/Oracle server or Windows authentication.
Default value: Server authentication
Login ID/User ID
ID to use for login.
Password
Password for login.
Tables
Select the database table to use.
Preview
Load the structure of the table.
Description
Description of the database.
Fuzzy search
When checked, fuzzy matching is performed yielding more results but lower performance.
Ignore case
When checked, ignore upper and lower case writing of text.
Ignore spaces
When checked, ignore spaces in the values of the fields when comparing with the text on the document.
Ignore characters
Enter the characters to ignore in the values of the fields and the text before comparing.
Unique Id column
Select from the list the column that uniquely identifies a record. This is used to help identifying duplicates in validation.
Selected columns
Select only the columns that are used in locators and validation rules to reduce memory usage.
Columns preview
From the selected database the first 20 rows are shown with the field names as column headers.
Save
Click the save button to save the settings.
Save as
Click the save as button to save the settings under a new name.
Cancel
Click the cancel button to close the window and return to the list of relational databases.