Enter a name for the connection.

The connection type is set by default. You cannot edit this value.

Enter the user name to connect to the Vertica database.

Enter the password to connect to the Vertica database.

Indicates that the password for the repository user name is a session parameter, $Param

Name

. Define the password in the workflow or session parameter file, and encrypt it by using the

pmpasswd

CRYPT_DATA option.

Enter the name of the ODBC data source that you created for the Vertica database.

Select the code page that the

PowerCenter Integration

Service must use to read or write data.

Runs an SQL command with each database connection.

Runs an SQL command before the initiation of each transaction.

The number of seconds that the

PowerCenter Integration

attempts to reconnect to the database if the connection fails. If the

PowerCenter Integration

cannot connect to the database in the retry period, the session fails.

Select this option to enable load balancing on the Vertica database. When you enable load balancing, the

PowerCenter Integration

requests a load balanced connection with the Vertica database.