Ability to decrypt and encrypt the incoming and outgoing files in DataFactory using custom Activity
Our client is expecting files with encrypted columns (only few columns are encrypted like PII and others are not) in source, so we are looking options to use ADF to decrypt and do the ETL accordingly.
Similary, while sending the files downstream, ADF should be able to encrypt related PII columns.
Andy Steinke commented
Is there any solution planned for ADF? We have the need to encrypt an output file before sending it to a vendor and would like to be able to do it easily within the pipeline.
Dharini Vaideeswaran commented
Is there any solution provided for this idea? I would like to do a similar activity in ADF. Please let me know if there is any way of doing this.