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

SFTP

SFTP

If you are sending sensitive data over a network, you can use Secure File Transfer Protocol (SFTP) for securing data. To connect to an SFTP server, configure an FTP connection to use SFTP. SFTP enables file transfer over a secure data stream. The PowerCenter Integration Service creates an SSH2 transport layer that enables a secure connection and access to the files on an SFTP server.
SFTP creates an encrypted channel between two computer systems and protects against the following attacks:
  • IP spoofing, which occurs when a remote host sends out packets that pretend to come from another trusted host.
  • IP source routing, which occurs when a host can pretend that an IP packet comes from another trusted host.
  • DNS spoofing, which occurs when an attacker forges name server records.
  • Interception of clear text passwords and other data by intermediate hosts.
  • Manipulation of data by attackers in control of intermediate hosts.
SFTP uses a combination of asymmetric cryptology and symmetric cryptology to provide strong encryption and optimal performance. Most commercial servers and many open source servers support SFTP. SFTP is also an effective protocol to use for transmitting large files as it compresses the data stream before encryption.
To use SFTP file sources and targets in a session, perform the following tasks:
  1. Create an FTP workflow connection and configure the FTP connection object for SFTP.
  2. Select and configure an SFTP connection object in the session properties.
  3. Configure source file properties.
  4. Configure target file properties.


Updated August 27, 2020