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.
PDI will select files list from previous result rows (not result files, see next option) and send theses files. If the file can not be found, PDI will ignore it. (It takes the first field of the result row as a string field. When you are not using version 5.0 with the result files option, you can use the circumvention that is attached.)

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.
(since version 5.0 to differentiate between the result rows and result files set)

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
browse to destination folder.

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.