SQL warehousing — Secure FTP operators

The secure FTP operator transfers one or more files to and from a remote computer by using the SSH File Transfer Protocol (SFTP).

Concept topic graphic of the secure FTP operator

The secure FTP operator uses the SSH protocol to create a secure connection between the client and the remote server. The operator supports the following SFTP operations:

For each of the SFTP operations, the operator supports three modes for file transfer: overwrite, resume, and append. In addition, you can run the following user-defined SFTP commands by using this operator:

get
get-resume
get-append
put
put-resume
put-append
cd
lcd
ln
mkdir
lmkdir
rm
rmdir
chmod
chown
chgrp

You can use glob expressions with wildcard characters to transfer multiples files at a time.

You can provide authentication for the file transfer in one of the following ways:

Use a user ID and password.
Set up a public key authentication between the client and the remote computer by using the SSH protocol.
Set up host authentication on the client computer.