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

External Loader Connections

External Loader Connections

Use a loader connection object for each target that you want load through an external loader.
The following table describes the properties that you configure for an external loader connection:
Property
Description
Name
Connection name used by the Workflow Manager. Connection name cannot contain spaces or other special characters, except for the underscore.
User Name
Database user name with the appropriate read and write database permissions to access the database. If you use Oracle OS Authentication or IBM DB2 client authentication, enter PmNullUser. PowerCenter uses Oracle OS Authentication when the connection user name is PmNullUser and the connection is to an Oracle database. PowerCenter uses IBM DB2 client authentication when the connection user name is PmNullUser and the connection is to an IBM DB2 database.
To define the user name in the parameter file, enter session parameter $Param
Name
as the user name, and define the value in the session or workflow parameter file. The Integration Service interprets user names that start with $Param as session parameters.
You can connect to a database runs on a network that uses Kerberos authentication. To use Kerberos authentication for the database connection, set the user name to the reserved word
PmKerberosUser
. If you use Kerberos authentication, the connection uses the credentials of the user account that runs the session that connects to the database. The user account must have a user principal on the Kerberos network where the database runs.
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. For Oracle OS Authentication or IBM DB2 client authentication, enter PmNullPassword. For Teradata connections, you can enter PmNullPasswd to prevent the password from appearing in the control file. Instead, the Integration Service writes an empty string for the password in the control file.
Passwords must be in 7-bit ASCII.
If you set the user name to
PmKerberosUser
to use Kerberos authentication for the database connection, set the password to the reserved word
PmKerberosPassword
. The connection uses the credentials of the user account that runs the session that connects to the database.
Connect String
Connect string used to communicate with the database. For syntax, see Native Connect Strings.
You can parameterize the connect string attribute for Oracle external loader connections.

0 COMMENTS

We’d like to hear from you!