I want to use a pipline ADF to call an API REST which used an sql table and extracts one or more files. API should return 3 files if the table contains 3 different regions, for this reason I used the following activities: A lokupctivity : it’s a query ( distinct on the column Regions) to get all the reg…
Tag: azure-data-factory
Excel into Azure Data Factory into SQL
I read a few threads on this but noticed most are outdated, with excel becoming an integration in 2020. I have a few excel files stored in Drobox, I would like to automate the extraction of that data into azure data factory, perform some ETL functions with data coming from other sources, and finally push the …