English
  • PowerCenter 10.2 HotFix 2
  • All Products

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

Workflow Basics Guide

Workflow Basics Guide

Back Next

Configuring a Session to Use Connection Variables

Configuring a Session to Use Connection Variables

If the source or target is a database, you can use connection variables.
To enter the database connection for the $Source and $Target connection variables:
  1. In the session properties, select the Properties tab or the Mapping tab, Connections node.
  2. Click the Open button in $Source Connection Value or $Target Connection Value field.
    The Connection Browser dialog box appears.
  3. Select a connection variable or session parameter.
    You can enter the $Source or $Target connection variable, or the $DBConnection
    Name
     or $AppConnection
    Name
     session parameter. If you enter a session parameter, define the parameter in the parameter file. If you do not define a value for the session parameter, the Integration Service determines which database connection to use when it runs the session.
  4. Click OK.