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

Databases that Do Not Allow User Names and Passwords

Databases that Do Not Allow User Names and Passwords

Some database drivers, such as ISG Navigator, do not allow user names and passwords. Since the Workflow Manager requires a database user name and password, PowerCenter provides reserved words to register databases that do not allow user names and passwords:
  • PmNullUser
  • PmNullPasswd
Use the PmNullUser user name if you use one of the following authentication methods:
  • Oracle OS Authentication.
    Oracle OS Authentication lets you log in to an Oracle database if you have a login name and password for the operating system. You do not need to know a database user name and password. PowerCenter uses Oracle OS Authentication when the connection user name is PmNullUser and the connection is for an Oracle database.
  • IBM DB2 client authentication.
    IBM DB2 client authentication lets you log in to an IBM DB2 database without specifying a database user name or password if the IBM DB2 server is configured for external authentication or if the IBM DB2 server is on the same as the Integration Service process. PowerCenter uses IBM DB2 client authentication when the connection user name is PmNullUser and the connection is for an IBM DB2 database.
Use the PmNullUser user name with any of the following connection types:
  • Relational database connections.
    Use for Oracle OS Authentication, IBM DB2 client authentication, or databases such as ISG Navigator that do not allow user names,
  • External loader connections.
    Use for Oracle OS Authentication or IBM DB2 client authentication.
  • HTTP connections.
    Use if the HTTP server does not require authentication.
  • PowerChannel relational database connections.
    Use for Oracle OS Authentication, IBM DB2 client authentication, or databases such as ISG Navigator that do not allow user names.
  • Web Services connections.
    Use if the web service does not require a user name.