Prerequisites
The SSH File Transfer Protocol (SFTP) is a network protocol that provides secure file access, file transfer, and file management over a reliable data stream. It provides all the functionality offered by the FTP protocol, but more securely and more reliably.
To create an SFTP destination connection, configure the following connection settings:
Connect to Your Destination
To connect to your destination:
Provide a unique connection name.
Provide your connection settings.
Click Test & add connection to connect to the delivery channel.
Note: When testing a connection to a new destination, a test file is added into the target destination.
Connection Fields
To create an SFTP destination connection, configure the following connection settings:
Field | Description |
Connection name | Unique name of your connection that you can refer to in the future. |
Connection method | Type of connection: SFTP |
Address | IP address for your host or server. |
Port | Port number (typically, 22). |
Username | Username associated with this SFTP connection. |
Password | Password associated with this SFTP connection. |
Folder path (optional) | Destination folder path for the files. |
SSH Key Enabled | Enables the SSH key. Allows the SFTP service to log in without entering a password authentication. Often employed for file transfer automation. |
Override on revision | Allows an override of the default FTP umask, so files can be created with a 000 umask which allows read and write access. |
Private key | Private key used to authenticate a client when it connects to an SFTP server. |
Private key passphrase (optional) | Word or phrase that protects private key files. It prevents unauthorized users from encrypting them. Usually it's just the secret encryption/decryption key used for Ciphers. |
File types | Delivery options: Avro, CSV, Parquet, Raw |
Uncompressed delivery (optional) | If checked, delivers uncompressed files. Default: Compressed versions of the files. For example, gzip-compressed objects. |