How to use a private key to connect to an SFTP datasource in AppFabric?

Question

I am creating my first data factory in app fabric. One feature I found missing is that I cannot connect to a SFTP source unless, I have basic authentication. In the previous version of Azure Data Factory, I had an option of selecting the authentication type on the drop down for the linked service.

In the app fabric world, there are no similar options to connect to a SFTP source. Has anyone else encountered this issue?

Answer 1

It seems that Azure App Fabric currently lacks support for SSH private key authentication for SFTP connections, which is a change from the options available in the traditional Azure Data Factory.

As a workaround, you may consider:

1. Using Basic Authentication with a username and password if that is an option for your SFTP source.
2. Custom Integration by setting up an Azure Function or Logic App as a middle layer to handle the SFTP connection using private key authentication and then integrating it with App Fabric. This would involve more setup but can give you the flexibility needed until App Fabric adds this feature.

If this is a critical need, consider submitting feedback to Microsoft or checking with their support for any upcoming feature updates related to this.

Answer 2

Hi @Abhijit Shrikhande

Greetings & Welcome to Microsoft Q&A forum! Thanks for posting your query!

MS Fabric is currently not supported in the Q&A forums, the supported products are listed over here Supported products on MS Q&A (more to be added later on).

You can ask the experts in the dedicated MS Fabric community forum.

Can you please open as a new thread in MS Fabric community: https://community.fabric.microsoft.com/t5/General-Discussion/bd-p/ac_generaldiscussion

I hope this information helps. Please do let us know if you have any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Thank you.