Share via

How do I use password protected data as source?

Balachandran Kannan 181 Reputation points
2021-02-16T10:21:20.243+00:00

My Copy activity's source is a CSV file at an SFTP location. On top of authentication to access SFTP, the data files it contains are compressed/zipped and password protected. Is there a way to process it through ADF where password can be passed.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
0 comments
Accepted answer
  1. Nandan Hegde 36,146 Reputation points MVP Volunteer Moderator
    2021-02-16T10:31:50.007+00:00

    Hey @Balachandran Kannan ,
    Based on my knowledge, as of today ADF does not support reading password protected files.

    You can add your feedback: https://feedback.azure.com/forums/34192--general-feedback/suggestions/40677769-azure-data-factory-decompress-zip-files-with-pas

    However you can copy the file from SFTP to blob location as is via ADF and then use Azure functions/ Custom activity for unzipping the pwd protected file .
    Reference:
    https://stackoverflow.com/questions/61435153/data-factory-unzip-a-password-protected-zip

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.