Table of Contents

Search

  1. Preface
  2. Workflow Manager
  3. Workflows and Worklets
  4. Sessions
  5. Session Configuration Object
  6. Tasks
  7. Sources
  8. Targets
  9. Connection Objects
  10. Validation
  11. Scheduling and Running Workflows
  12. Sending Email
  13. Workflow Monitor
  14. Workflow Monitor Details
  15. Session and Workflow Logs
  16. Session Properties Reference
  17. Workflow Properties Reference

PowerExchange for Netezza Connections

PowerExchange for Netezza Connections

Use a relational connection object for each Netezza source or target that you want to access.
The relational database connection defines how the Integration Service accesses the underlying database for Netezza Performance Server. When you configure a Netezza connection, you specify the connection attributes that the Integration Service uses to connect to Netezza.
The following table describes the properties that you configure for a Netezza connection:
Property
Description
User Name
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
pmpasswd
CRYPT_DATA option. Default is disabled.
Password
Password for the database user name.
Connect String
ODBC data source to connect to Netezza Performance Server.
Code Page
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.