SFTP Alteryx Connection, SAS Datasets.

[brperkins2]

Hello. I'm trying to determine if Alteryx can download files from an SFTP site. I have done the following steps. 

1. Add Text Input with the SFTP URL Folder I would like to download from. sftp:/server/department/analytics/data/project/data_file.sas7bdat

2. Add a download tool, select the URL, encode the URL text, and output to a string field. In the connection I enter my credentials (username, password).

When I run this workflow, I get error message:

Error: Download (10): Error transferring data: Couldn't resolve host name

[Felipe_Ribeir0]

Hi @brperkins2 

Are you using the intranet internet connection of your company? This SFTP server is inside the network of your company? Try to establish this connection without VPN/Using your own internet connection to see if it works.

I had this same problem here, our intranet connection did not allowed communication with hosts outside of the company. I used my own cellphone connection/unpluged from VPN to run the workflow until the network team created a specific exception to allow the communication between my personal machine/alteryx server and the external SFTP server. The error was exactly the same, so maybe it is the same situation.