topic FTP connection to a linux server in Alteryx Designer Desktop Discussions

FTP connection to a linux server

Kakelad — Thu, 24 May 2018 01:19:36 GMT

Hello!
We are trying to read and write data from/to our linux server.
We have validated through an SSH connection that the file is there and that the path is as we have configured in alteryx. We also configured the username and password in Alteryx.
However, when trying to run the GET in Designer, we get and error that "server could not be connected".
I will add a screenshot of our situation.

What are we doing wrong? Any tips?
Thank you!

Re: FTP connection to a linux server

KevinP — Fri, 02 Mar 2018 17:14:38 GMT

@Kakelad Most likely your URL is incorrect. Most ftp servers chroot the users login into their home directory. So /home/<username> typically becomes just /. To test this you can try pasting the URL directly into your web browser. You will likely get the same or similar error as you do in the download tool. If this is the case try shortening the url to: ftp://transfer.fonapi.fi/in/rikastettava_data.csv or to: ftp://transfer.fonapi.fi/rikastettava_data.csv

Re: FTP connection to a linux server

Kakelad — Mon, 05 Mar 2018 08:01:25 GMT

Thanks for the answer!

I kind of already solved my own problem :) just changed the "ftp//" in my connection name to "sftp//"
Too simple :D !