Is it possible for Alteryx to make connection to SFTP that used public/private key and without using any third-party tools?
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.
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.
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.
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!
@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:
There are also some community tools around:
https://github.com/SKOPOS-ELEMENTS/SFTPTools_Alteryx/releases
And you could try to do it using python.
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?
Download tool does not support SFTP via public/private key. Install WinSCP and run via CLI.
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?
User | Count |
---|---|
19 | |
14 | |
13 | |
9 | |
8 |