How Can Users Execute ADF Pipelines

Jay 561 Reputation points
2021-03-18T08:57:41.357+00:00

Hi,

I have a pipeline that simply selects data from a sql db and exports the data to csv into blob storage, works fine.

The data is sometimes only needed to be run once in a week and other times maybe 10 times in a day, the users will control when they need the data.

Just need advice on what I should be looking at to achieve this and what you think are best ways.
I originally was thinking something like a webpage with a button they click to run the pipeline.

I've had a quick look and some are saying use Web Activity or Logic App or Power Automate when email received etc. but I don't want to head down any of these avenues without knowing what is the recommended/standard way of doing above.

Any advice you can give would be much appreciated.

Thanks.

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

Accepted answer
  1. Vaibhav Chaudhari 38,681 Reputation points
    2021-03-18T09:21:39.43+00:00

    One option is to write a PowerShell script that triggers the pipeline, show status that pipeline is running and finally shows successful status.

    Users can simply double click the file and execute it


    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav


0 additional answers

Sort by: Most helpful