Azure Logic Apps - Powerful workflow tool
Use Cases and Deployment Scope
We use Azure Logic Apps to automate the workflows mainly to extract the data from on-prem databases. My use case is to extract the customer related data stored in the database from the on-prem through gateway and load the data to SharePoint site for further processing. Implemented quite a lot of workflows targeting the similar extraction process.
Pros
- SharePoint connection
- Connect to SQL DB
- Connect to Database from on-prem through gateway
Cons
- Better user interface to develop workflows
- Allow more than 500 workflow actions
- All runtime retention more than default 90 days
Likelihood to Recommend
Azure Logic Apps is well suited for workflow automations, integration of on-prem and online systems, file transfer process, connection well with SharePoint apps. This is not well suited when to integrate the custom code written in different programming languages, I had issues to integrate complex code function to utilize within Azure Logic Apps workflow.