Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
Data Factory setup with Sink as SFTP using SSH key doesn't work
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 71%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESW%3C/text%3E%3C/svg%3E)
Sandeep Wadhwa
6
Reputation points
I am trying to configure an Azure Data Factory to copy data from On-Premise Integrated Runtime IR to an SFTP.
I am able to achieve the functionality and connect to SFTP using plain password, but when I switch the FTP connection to use SSH key instead of password, it gives error.
I am able to use the same private key and connect to SFTP using Filezilla and Putty, but for some reason, ADF keeps giving error. The error that I get is that authentication failed due to invalid key.
On the SFTP logs, I do not see any issue mentioned that invalid key was provided at the login.
Is there anything that I am missing? Any thoughts/tips on this would be helpful!
Azure Data Factory
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Saurabh Sharma 23,846 Reputation points Microsoft Employee Moderator2020-11-19T15:38:43.813+00:00 @Sandeep Wadhwa Thanks for posting your question on Microsoft Q&A. Are you getting any errors while testing the connection on "Linked Service" blade ? Can you please provide the exact error message.
I have tried using an sftp server and it works for me with Files.com and Putty. I have followed the below steps -- Generated Public Key on Putty tool and updated Files.com user account public key.
- Saved Private key in a file(not as .ppk) from putty as OpenSSH Key with a key passphrase.
- Create a linked service by providing username, choosing Private key file, providing passphrase. Test connection is successful as shown below -
Please let me know if you have done anything differently.
- Generated Public Key on Putty tool and updated Files.com user account public key.
-
Saurabh Sharma 23,846 Reputation points Microsoft Employee Moderator
2020-11-20T19:06:52.767+00:00 @Sandeep Wadhwa Just following up to know if you are still having issues ?
-
Saurabh Sharma 23,846 Reputation points Microsoft Employee Moderator
2020-11-23T19:02:18.09+00:00 @Sandeep Wadhwa Please let me know if you are still having any issues and needs help.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 91%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Pedro 25 Reputation points2023-06-09T20:45:56.91+00:00 Hello, i have the same issue, i would like to know if is possible to make the connection without a private key, as we dont have it, we only have the public key.
Sign in to comment
Sign in to answer