Relational databases settings

Octobox Designer ›› Panels ›› Databases panel ››
Parent Previous Next

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.