SFTP (Secure File Transfer Protocol) uses secure shell encryption to provide a high level of security for sending and receiving file transfers.
In Humaans it is now possible to configure scheduled reports to be uploaded to a server in addition to being sent by email. This opens the door for many types of integrations that rely on data ingest through SFTP.
Setting up SFTP for scheduled reports
Create a report, and click Save as when you are ready to proceed.
Toggle Scheduled report and select SFTP as the destination.
Enter your SFTP details:
Server: the url to your SFTP server, this must start with sftp:// and can be a domain or IP address, optionally specify the port. You can paste a connection string (e.g.sftp://username:password@35.11.11.111/import/report.csv) which will pre-fill the relevant inputs.
Remote path: this can be a relative path from the user’s home directory (e.g../or../) or an absolute path (e.g./importsorC:\\imports) and can either specify a filename that must end in.csvor a directory, in the case a directory is specified the report name will be in the form[Schedule report name] [Start range date]-[End range date].csv.
Username: the username to login with.
Password: optionally specify the user’s password.
Public key: optionally generate a public key for public key authentication, this should be added to your SFTP server.
If using both password and public key authentication then the server must be configured to accept password,publickey in that order. We don’t currently support publickey authentication as the first method, e.g. publickey,password.
IP allowlisting
If your SFTP server specifies an IP allow list, we will always send traffic from one of the following IP addresses:
34.34.179.99
34.38.212.76
34.38.37.224