question

Jay-8106 avatar image
0 Votes"
Jay-8106 asked PRADEEPCHEEKATLA-MSFT commented

How Can Users Execute ADF Pipelines

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
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @Jay-8106,

Just checking in to see if the below answer provided by @VaibhavChaudhari helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·

1 Answer

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered Jay-8106 commented

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks, OK yeah that is option I hadn't thought of.
One issue could be that users only have access to Sharepoint and certain file types csv, excel, word so would not be allowed to run any powershell, I'll have to check with IT.

0 Votes 0 ·