LogicApp as scheduling tool

Question

Hello Team,

Can LogicApp be used as scheduling tool ? Main requirements are as below: -

LogicApp should be able to execute ADF pipelines

LogicApp should be able to execute .bat files

LogicApp should be able to call APIs

LogicApp should be able to prompt for parameters and pass it to the ADF pipelines

Along with it, we should be able to run from any step in isolation or with reactivity (Like Autosys). For ex:- Lets say we have we need to run 3 ADF pipelines on success of each other. And if the second pipeline fails, we should be able to run from the second pipeline and continue further.

Are all these requirements achievable via LogicApp ?

If anyone has used it or have any POC, documentation surrounding these requirements and could be shared here would be very helpful.

Thanks.

Regards,

Nagesh CL

Answer 1

Hi Nagesh CL,

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

Yes, Azure Logic Apps can be used as a scheduling tool and can meet your requirements. Here’s how each of your needs can be addressed:

1. Logic Apps can trigger Azure Data Factory (ADF) pipelines using the built-in ADF connector. You can set up workflows to start ADF pipelines and handle their execution status.
2. Logic Apps can execute .bat files indirectly by using Azure Automation or Azure Functions. You can find the related documentation below :
   https://learn.microsoft.com/en-us/answers/questions/2085904/automating-execution-of-bat-file-using-adf-logicap
3. Logic Apps can easily call REST APIs using the HTTP action. You can configure the HTTP action to make GET, POST, PUT, DELETE, or other types of HTTP requests.
4. Logic Apps can prompt for parameters using HTTP request triggers or manual triggers. These parameters can then be passed to ADF pipelines as part of the pipeline execution request.
5. While Logic Apps doesn’t natively support running from a specific step like Autosys, you can design your workflows to handle such scenarios.
   You could, however, design the Logic App workflow with error handling and conditional paths. For instance, each ADF pipeline call could have a failure condition that sends it back to a specific step, and the Logic App could use retry policies for transient failures. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.