Unlock excel file when using azure data factory

Lars Schlaepfer 21 Reputation points


I'm currently working with data that I receive every 1st of the month. This data is delivered in my email as an excel file but it's protected with a password. I use Azure Logic App to move the attachment (excel file) to a blob storage. This file is then used within Azure Data Factory to copy it into my database table.

To automate this process I need a solution to enter this password automatically when I want to copy it into my database with ADF.

Is there someone that encountered the same problem and has found a solution?

Kind regards,

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,527 questions
{count} votes

0 additional answers

Sort by: Most helpful