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 Db2 Warehouse Connections

PowerExchange for Db2 Warehouse Connections

The following table describes the Db2 Warehouse connection properties that you must configure:
Property
Description
User Name
Database user name with the appropriate read and write database permissions to access Db2 Warehouse.
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 IBM Data Server Driver.
Database Name
Database name of IBM Db2 Warehouse that you want to connect to.
Schema Name
The schema name in IBM Db2 Warehouse from where you want to fetch the metadata.
PowerCenter Integration Service browses all schemas in IBM Db2 Warehouse if you do not specify a schema name.
Server Name
Host name of IBM Db2 Warehouse.
Port Number
Network port number used to connect to the IBM Db2 Warehouse server.
Driver Name
Specify
IBM DB2 ODBC DRIVER - IBMDBCL1
.
Advanced connection properties
Optional. Additional connection parameters that you want to use.
Specify the connection parameters as key-value pairs in the following format, and separate each key-value pair with a semicolon:
<param1>=<value>&<param2>=<value>&<param3>=<value>....