Allowing ETL access to my data on File Transfer Protocol Secure (FTPS) ETL can access data in files residing on any File Transfer Protocol Secure (FTPS) server. This article details creating an FTPS 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.

To define a connection in ETL to your FTPS server

  1. Click the Connections icon (lightning bolt) on the top left menu.
  2. Click New connection and choose File Transfer Protocol Secure (FTPS).
    thumbnail image
  3. In the new FTPS connection window, name the connection and enter the connection information:
    • Hostname - the host name of the FTPS server.
    • User Name - the user name to use when connecting to FTPS server.
    • Password - the password to use when connecting to FTPS server using password authentication.
      Note: User name cannot contain the character $ and passwords cannot contain the character @.
    • Port - the TCP port of the FTPS server (Default is 21).
  4. Click Test connection. If the credentials are correct, a message that the connection test was successful appears.
  5. Click Create FTPS 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 FTPS server.