DropStream Warehouse File Exchange Integration: Defining Connection Strings

How do I define the connection string?

DropStream uses a URI connection string to define how to exchange files with a remote server. 

Format: <protocol>://<username>:<password>@<host>:<port>

Example: sftp://joe:password123@ftp.example.com:22

We support the following File Transfer Protocols:
  • FTP
  • FTPS
  • SFTP (SSH + FTP)

NOTE: the username and password must be URL encoded. This encoding tool, https://www.url-encode-decode.com, can be used as a quick way to encode only the username and password portion of the connection.