Encrypt the CSV file before transferring to SFTP

Divakar Krishnan 106 Reputation points
2022-05-04T14:44:06.21+00:00

Dear Team,

As per our requirement, we need to encrypt the CSV file and transfer it to SFTP using ADF.

I have checked in ADF, but there is no option to encrypt the CSV file.

Can someone please assist on how to encrypt the CSV file using public shared key using ADF?

Thanks,
Divakar

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,142 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nandan Hegde 31,346 Reputation points MVP
    2022-05-05T05:59:12.35+00:00

    Hey,
    Based on my understanding

    Unfortunately there is no out of box feature in Azure Data factory to perform encryption/decryption of files. Below are couple of feature request suggestions submitted by other Azure users. I would recommend you to please comment and/or up-vote the below user voice items to increase the priority of feature implementation.

    https://feedback.azure.com/forums/270578-data-factory/suggestions/40410025-ability-to-decrypt-and-encrypt-the-incoming-and-ou

    https://feedback.azure.com/forums/270578-data-factory/suggestions/41023156-add-support-for-gpg-file-decryption

    In order to transform/process data in a way that isn't supported by Data Factory, you can create a Custom logic with your own data movement or transformation logic and use the Custom activity in a pipeline. Or another option you could try out is Azure Function Activity.

    Additional info :
    Here are few related helpful resources:


2 additional answers

Sort by: Most helpful
  1. Vandana Chaturvedi 1 Reputation point
    2022-05-04T15:02:29.43+00:00

    I was told that since we are sending it over SFTP, we don't need to encrypt the data. As per my understanding even if we are sending data over SFTP, we should encrypt it.

    0 comments No comments

  2. Divakar Krishnan 106 Reputation points
    2022-05-05T05:55:38.133+00:00

    @Vandana Chaturvedi , We should encrypt the file even if we are sending data over SFTP.

    Thanks,

    0 comments No comments