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

Rules and Guidelines for Creating File Parameters and Database Connection Parameters

Rules and Guidelines for Creating File Parameters and Database Connection Parameters

Session file parameters and database connection parameters provide the flexibility to run sessions against different files and databases.
Use the following rules and guidelines when you create file parameters:
  • When you define the parameter file as a resource for a node, verify the Integration Service runs the session on a node that can access the parameter file. Define the resource for the node, configure the Integration Service to check resources, and edit the session to require the resource.
  • When you create a file parameter, use alphanumeric and underscore characters. For example, to name a source file parameter, use $InputFile
    Name
    , such as $InputFile_Data.
  • All session file parameters of a particular type must have distinct names. For example, if you create two source file parameters, you might name them $SourceFileAccts and $SourceFilePrices.
  • When you define the parameter in the file, you can reference any directory local to the Integration Service.
  • Use a parameter to define the location of a file. Clear the entry in the session properties that define the file location. Enter the full path of the file in the parameter file.
  • You can change the parameter value in the parameter file between session runs, or you can create multiple parameter files. If you use multiple parameter files, use the
    pmcmd
    Startworkflow command with the -paramfile or -localparamfile options to specify which parameter file to use.
Use the following rules and guidelines when you create database connection parameters:
  • You can change connections for relational sources, targets, lookups, and stored procedures.
  • When you define the parameter, you can reference any database connection in the repository.
  • Use the same $DBConnection parameter for more than one connection in a session.


Updated November 14, 2019