Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Read file from SFTP that used public/private key

nasyikin
6 - Meteoroid

Is it possible for Alteryx to make connection to SFTP that used public/private key and without using any third-party tools?

 

 

9 REPLIES 9
mikekelvin
5 - Atom

Yes, Alteryx can make a connection to SFTP that uses public/private key authentication without using any third-party tools.

 

Alteryx has built-in connectors for SFTP that allow you to securely transfer files between a local machine and a remote SFTP server using various authentication methods, including public/private key authentication.

 

To establish a connection using public/private key authentication in Alteryx, you will need to provide the location of the private key file and enter the passphrase for the private key, if applicable. You can specify these settings in the SFTP tool configuration window in Alteryx.

It's worth noting that you will need to have the appropriate permissions and access to the private key file to be able to establish a connection using public/private key authentication. If you encounter any issues with the connection, you may need to consult with your IT department or SFTP server administrator to ensure that the necessary settings are configured correctly.

 

Hope this answers your query.

nasyikin
6 - Meteoroid

Thanks for the info @mikekelvin can you share Alteryx built-in connectors for SFTP and where I can get them.

 

Because I've been web searching and could not find any SFTP connectors on Alteryx.

AkimasaKajitani
17 - Castor
17 - Castor

Hi @nasyikin 

 

Do you try the Download tool?

https://help.alteryx.com/20223/designer/download-tool

 

It can provide to access to the sFTP function.

DavidElliott
5 - Atom

Sounds great - can you tell us where do we put the key in the downloads tool? Is there an example you could share?

 

Many thanks!

Felipe_Ribeir0
16 - Nebula

@DavidElliott as far as i know, currently it is not possible to use ppk`s with the download tool to access sftp servers.


But you can try to follow the WINSCP path:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/ZIP-and-SFTP-ToFile-ToFileToZI...


There are also some community tools around:

https://github.com/SKOPOS-ELEMENTS/SFTPTools_Alteryx/releases

 

And you could try to do it using python.

kunvai1
7 - Meteor

Hey, I am trying to read files from sftp site. How to configure download tool for the public key ? Where can I pass the phrase?

apathetichell
19 - Altair

Download tool does not support SFTP via public/private key. Install WinSCP and run via CLI.

kunvai1
7 - Meteor

Hey I am trying to build an alteryx workflow to read data from a csv file on sftp site. If download tool doesn't help , can I do with python tool?

Labels
Top Solution Authors