Table of Contents

Search

  1. Preface
  2. Understanding Pipeline Partitioning
  3. Partition Points
  4. Partition Types
  5. Pushdown Optimization
  6. Pushdown Optimization and Transformations
  7. Real-time Processing
  8. Commit Points
  9. Row Error Logging
  10. Workflow Recovery
  11. Stopping and Aborting
  12. Concurrent Workflows
  13. Grid Processing
  14. Load Balancer
  15. Workflow Variables
  16. Parameters and Variables in Sessions
  17. Parameter Files
  18. FastExport
  19. External Loading
  20. FTP
  21. Session Caches
  22. Incremental Aggregation
  23. Session Log Interface
  24. Understanding Buffer Memory
  25. High Precision Data

Advanced Workflow Guide

Advanced Workflow Guide

Overriding Connection Attributes in the Parameter File

Overriding Connection Attributes in the Parameter File

If you use a session parameter to define a connection for a source or target, you can override the connection attributes in the parameter file. Use the $FTPConnection
Name
, $QueueConnection
Name
, $LoaderConnection
Name
, or $AppConnection
Name
session parameter.
When you define a connection in the parameter file, the Integration Service searches for specific, user-defined session parameters that define the connection attributes. For example, you create a Message Queue connection parameter called $QueueConnectionMyMQ and define it in the “[s_MySession]” section in the parameter file. The Integration Service searches this section of the parameter file for the “rows per message” parameter, $Param_QueueConnectionMyMQ_Rows_Per_Message.
When you install PowerCenter, the installation program creates a template file named ConnectionParam.prm that lists the connection attributes you can override for FTP, queue, loader, and application connections. The ConnectionParam.prm file is located in the following directory:
<PowerCenter Installation Directory>/server/bin
When you define a connection in the parameter file, copy the template for the appropriate connection type and paste it into the parameter file. Then supply the parameter values.
For example, to override connection attributes for an FTP connection in the parameter file, perform the following steps:
  1. Configure the session or workflow to run with a parameter file.
  2. In the session properties Mapping tab, select the source or target instance in the Connections node.
  3. Click the Open button in the value field and configure the connection to use a session parameter. For example, use $FTPConnectionMyFTPConn for an FTP connection.
  4. Open the ConnectionParam.prm template file in a text editor and scroll down to the section for the connection type whose attributes you want to override. For example, for an FTP connection, locate the “Connection Type: FTP” section:
                        Connection Type : FTP                     --------------------- ... Template ==================== $FTPConnection<VariableName>= $Param_FTPConnection<VariableName>_Remote_Filename= $Param_FTPConnection<VariableName>_Is_Staged= $Param_FTPConnection<VariableName>_Is_Transfer_Mode_ASCII=
  5. Copy the template text for the connection attributes you want to override. For example, to override the “Remote File Name” and “Is Staged” attributes, copy the following lines:
    $FTPConnection<VariableName>= $Param_FTPConnection<VariableName>_Remote_Filename= $Param_FTPConnection<VariableName>_Is_Staged=
  6. Paste the text into the parameter file. Replace
    <VariableName>
    with the connection name, and supply the parameter values. For example:
    [MyFolder.WF:wf_MyWorkflow.ST:s_MySession] $FTPConnectionMyFTPConn=FTP_Conn1 $Param_FTPConnectionMyFTPConn_Remote_Filename=ftp_src.txt $Param_FTPConnectionMyFTPConn_Is_Staged=YES
    The Integration Service interprets spaces or quotation marks before or after the equals sign as part of the parameter name or value.
    If you do not define a value for an attribute, the Integration Service uses the value defined for the connection object.


Updated November 14, 2019