none
Data Factory - SFTP as Sink RRS feed

  • Question

  • Hi,

    I have following use case to support.

    SFTP ( Source ) ------> Extract, Transform and Load ------->SFTP(Destination)

    I am planning to use data factory to copy data from Source to Azure Blob.

    I would use .NET custom activity to transform the data and store the data in Azure Blob.

    I would like to copy the files from Azure Blob to my Destination which is again SFTP.

    The data factory currently does not support SFTP as a sink.

    What is the best way to copy the files from Blob to SFTP Server? Following are the options I was considering.

    1. Logic Apps to copy the files from Azure Blob to SFTP Server

    2. .NET Custom activity using a .NET SFTP library.

    Any recommendations on the above approaches? Is there a recommended SFTP Library which can be used for .NET Custom activity?

    Thanks in advance,

    RM

    Tuesday, August 1, 2017 1:56 AM

All replies