Load data from a website using ADL Data pipelines

bk 466 Reputation points
2020-10-19T15:09:27.467+00:00

Hi All
I want to load data from an excel link on a webiste. Is there a good document to show how to do it? I want to load data using ADF.
Thanks

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,567 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MartinJaffer-MSFT 26,081 Reputation points
    2020-10-19T23:38:54.07+00:00

    Hello @bk and thank you for your question.

    If the link on the website is for a download, you probably want to do 2 copy activities.

    First, copy from the website to your storage. (HTTP binary dataset) , probably also decompress at the same time.

    Second you can use the excel connector to load from the excel file now in storage to wherever you want it to go.

    0 comments

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.