Put a file with SFTP
Description
You can use the Put files with SFTP job entry to put one or more files from an FTP server using the Secure FTP protocol.
Options
General Tab
Option |
Description |
---|---|
Name of the job entry |
The name of the job entry. This name has to be unique in a single job. A job entry can be placed several times on the canvas, however it will be the same job entry. |
SFTP-server name (IP) |
The name of the SFTP server or the IP address. |
SFTP port |
The TCP port to use. This is usually 22. |
User name |
The user name to log into the SFTP server. |
Password |
The password to log into the SFTP server. |
Use private keyfile |
Indicates whether or not a private keyfile is to be used. |
Private key filename |
If "Use private keyfile" is checked then this field is enabled. The file can be browsed to using the browse button to the right of the field. Â The Private Key should be in the PEM file format. Â For PuTTY-based Private Keys, use PuTTYgen to convert the file into "OpenSSH" format. |
Key passphrase |
If "Use private keyfile" is checked then this field is enabled. If a passphrase is required then enter it here. |
Proxy type |
The proxy type (SOCKS5, HTTP) of the specified proxy server. |
Proxy host |
The host name or the IP address of the proxy server. |
Proxy port |
The port of the proxy server to connect to. |
Proxy username |
The username to log into the proxy server as. |
Proxy password |
The password associated with "Proxy username". |
Compression |
The compression to use in the file transfer. Current options are "none" and "zlib". |
Files Tab
Source (local) files
Option |
Description |
---|---|
Copy previous results to args |
If files to send are dynamically generated by another transformation or if you want to identify files to sent, check this option. |
Copy previous result files to args |
If files to send are dynamically generated by another transformation or job entry or if you want to identify files to sent, please check this option. PDI will select files from previous files result entry and send theses files. If the file can not be found, PDI will ignore it. |
Local directory |
The directory on the machine on which Kettle runs from which you want to ftp the files from |
Wildcard |
Specify a regular expression here if you want to select multiple files. For example: .*txt$ : get all text files A.*[ENG:0-9].txt : files tarting with A, ending with a number and .txt |
Success when no file |
Check this option if the job entry has to success when there is no files to process otherwise the job will fail. |
After SFTP Put |
Action to take after the file is transferred. Actions are "Do nothing", "Delete file" and "Move file to". |
Destination folder |
Enabled if "After SFTP Put" is set to "Move file to". The destination on the source file for the move is specified here. Use to browse button to |
Create destination folder |
Enabled if "After SFTP Put" is set to "Move file to". If the "Destination folder" does not exists check this option to create it. |
Add filename to to result |
Enabled if "After SFTP Put" is seet to "Do nothing". If checked the name of the file is added to the result stream. |
Target (remote) folder
Option |
Description |
---|---|
Remote directory |
The remote directory on the SFTP server to which we put the files. Use the "test folder" button to connect to the remote server and validate that the folder exists. |
Create folder |
Check this option if the destination folder does not exist and should be created. |