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. Appendix A: Session Properties Reference
  17. Appendix B: Workflow Properties Reference

Workflow Basics Guide

Workflow Basics Guide

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 Db2 Warehouse.
Database Name
Database name of Db2 Warehouse that you want to connect to.
Schema Name
The schema name in Db2 Warehouse from where you want to fetch the metadata.
Server Name
Host name of Db2 Warehouse.
Port Number
Network port number used to connect to the Db2 Warehouse server.
Driver Name
Specify the name of the IBM Data Server driver that you configured in the
odbcinst.ini
file.
For example, 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>....

0 COMMENTS

We’d like to hear from you!