- PowerCenter 10.1
- All Products
Database user name with the appropriate read and write database permissions to access Netezza Performance Server.
Use Parameter in Password
Indicates the password for the database user name is a session parameter, $Param
Name. Define the password in the workflow or session parameter file, and encrypt it by using the
pmpasswdCRYPT_DATA option. Default is disabled.
Password for the database user name.
ODBC data source to connect to Netezza Performance Server.
Code page associated with Netezza Performance Server.
Connection Environment SQL
Runs an SQL command with each database connection. Default is disabled.
Transaction Environment SQL
Runs an SQL command before the initiation of each transaction. Default is disabled.
Connection Retry Period
Number of seconds the Integration Service attempts to reconnect to the database if the connection fails. If the Integration Service cannot connect to the database in the retry period, the session fails. Default value is 0.