Query Regarding Dual-Factor Authentication for SFTP in Azure Data Factory V2

Question

We are in the process of configuring Azure Data Factory to establish an SFTP connection. Our requirement is to implement dual-factor authentication, which involves both an SFTP user ID and an SSH public key exchange method. However, during the creation of Azure Data Factory in the portal, it seems to accept only one authentication method, despite displaying three authentication factors.

Due to internal security guidelines, it is crucial for us to use the dual-factor authentication method. Could you please provide a response to this inquiry, as it holds significant importance in our ongoing project?

Answer 1

Hello Pravalika,

Thanks for asking your question in this forum.

Regarding your question, as I know, Azure Data Factory (ADF) supports using SSH keys for authentication when connecting to an SFTP server, but dual-factor authentication (using both SFTP user ID and SSH public key) may not be supported.

I suggest using AZURE KEY VAULT to store SSH PK and SFTP user ID credentials.

You can visit the link below. It describes the steps on how to use manage Identity and assign a user, then set credentials for that.

https://learn.microsoft.com/en-us/azure/data-factory/credentials?tabs=data-factory

Please let me know if you have further questions.

Regards

Zahra