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

Selecting an FTP Connection

Selecting an FTP Connection

To configure a session to use FTP, select the connection type and the connection object. Select an FTP connection object for each source and target that will use the FTP connection. To use SFTP, select an FTP connection object that is configured for SFTP. You configure connection options in the Connections settings on the Mapping tab.
To select an FTP connection for a source or target instance:
  1. On the Mapping tab, select the source or target instance in the Transformation view.
  2. Select the FTP connection type.
  3. Click the Open button in the Value field.
  4. Select a connection object or variable:
    • Use object.
      Select an FTP connection object. Click the Override button to override connection attributes.
    • Use connection variable.
      Use the $FTPConnection
      Name
      session parameter, and define the parameter in the parameter file. Override connection attributes in the parameter file.
    You can override the following attributes:
    Attribute
    Description
    Remote Filename
    The remote file name for the source or target. If you use an indirect source file, enter the indirect source file name.
    You must use 7-bit ASCII characters for the file name. The session fails if you use a remote file name with Unicode characters.
    If you enter a fully qualified name for the source file name, the Integration Service ignores the path entered in the Default Remote Directory field. The session will fail if you enclose the fully qualified file name in single or double quotation marks.
    You can use a parameter or variable for the remote file name. Use any parameter or variable type that you can define in the parameter file. For example, you can use a session parameter, $ParamMyRemoteFile, as the source or target remote file name, and set $ParamMyRemoteFile to the file name in the parameter file.
    Is Staged
    Stages the source or target file on the Integration Service. Default is not staged.
    Is Transfer Mode ASCII
    Changes the transfer mode. When enabled, the Integration Service uses ASCII transfer mode. You can use ASCII mode when transferring files on Windows machines to ensure that the end of line character is translated properly in text files. When disabled, the Integration Service uses binary transfer mode. Use binary transfer mode when transferring files on UNIX machines. Default is disabled.
  5. Click OK.


Updated June 25, 2020