Allowing ETL access to my data on Secure File Transfer Protocol (SFTP) ETL can access data in files residing on any Secure File Transfer Protocol (SFTP) server. This article details creating an SFTP connection in ETL.

In order to allow ETL direct access to your server, create firewall rules to allow ETL access from the relevant IPs in this list. You can also follow the directions here to allow ETL access through an SSH tunnel or reverse SSH tunnel.


To define a connection in ETL to your SFTP server

  1. Click the Connections icon (lightning bolt) on the top left menu.
  2. Click New connection and choose Secure File Transfer Protocol (SFTP).
    thumbnail image
  3. In the new SFTP connection window, name the connection and enter the connection information:
    • Hostname - the host name of the SFTP server.
    • Authentication Method - Select password or public key authentication. If key based authentication is selected, copy your account's public key from Settings -> Account Settings -> Profile and add it to the SFTP user's authorized keys.
    • User Name - the user name to use when connecting to SFTP server.
    • Password - the password to use when connecting to SFTP server using password authentication. Password cannot contain the character @.
    • Port - the TCP port of the SFTP server (Default is 22).
  4. Click Test connection. If the credentials are correct, a message that the connection test was successful appears.
  5. Click Create SFTP connection.
  6. The connection is created and appears in the connections list.
  7. Now you can create a package and test it on your actual data stored in an SFTP server.