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

Connection Variable Values

Connection Variable Values

Enter the database connection you want the Integration Service to use for the $Source and $Target connection variables. You can select a connection object, or you can use the $DBConnection
Name
or $AppConnection
Name
session parameter if you want to define the connection value in a parameter file.
When you configure a mapping, you can specify the database location to use $Source or $Target variable for Lookup and Stored Procedure transformations. You can also configure the $Source variable to specify the source connection for relational sources and the $Target variable to specify the target connection for relational targets in the session properties.
If you use $Source or $Target in a Lookup or Stored Procedure transformation, you can configure the connection value on the Properties tab or Mapping tab of the session. When you configure $Source Connection Value or $Target Connection Value, the Integration Service uses that connection when it runs the session. If you do not configure $Source Connection Value or $Target Connection Value, the Integration Service determines the database connection to use when it runs the session.
The following table describes how the Integration Service determines the value of $Source when you do not configure $Source Connection Value:
Connection Used for $Source Variable
Mapping Objects
Connection Used
One source
The database connection you specify for the source.
Joiner transformation is before a Lookup or Stored Procedure transformation
The database connection for the detail source.
Lookup or Stored Procedure transformation is before a Joiner transformation
The database connection for the source connected to the transformation.
Unconnected Lookup or Stored Procedure transformation
None. The session fails.
The following table describes how the Integration Services determines the value of $Target when you do not configure $Target Connection Value in the session properties:
Connection Used for $Target
$Target
Connection Used
One target
The database connection you specify for the target.
Multiple relational targets
None. The session fails.
Unconnected Lookup or Stored Procedure transformation.
None. The session fails.