What is our primary use case?
We host our application in Azure App Services and use Logic Apps to monitor everything within. We can schedule or trigger emails in case of any failures.
Every company needs their live transaction data in digital format. We never directly interact with the live database, regardless of the company's domain. Instead, we take snapshots of the live database, which act as separate reporting databases. It's a separate database; we call it a reporting database.
Once the data is within the reporting database, we do massaging by combining more than one table and some information to make it a beautifully presented or required report. A job is needed to do all this kind of activity. So, as a program, what we do is build a program and keep it simple. It's a console-based application at the option. Someone has to trigger that between month-end or during month-end or late at night, non-office hours, non-business hours, maybe in between.
In Logic Apps, what we do is have these kinds of applications as an EXE to be triggered at a particular point in time, period of time. Then, the final output, we want to drive it to the next level, to the block storage. So, in the storage block, we have another Logic App. It's like a chain of Logic Apps. We can train multiple applications. Once the final output is successfully maintained in another location or block storage, we use Logic Apps to trigger the application in general.
How has it helped my organization?
I deal with all the projects built under the .NET and .NET Core frameworks. I think Logic Apps is good for helping us run our access on a cloud environment like Azure. It's much easier, more reliable, and better to maintain.
If the server is shut down, the app may not trigger, but Azure Logic runs in a cloud environment. So there's no point where the server is down. Even if there is downtime, we have high availability, like 99.999%.
So, in a fraction of a second, our server can be brought up, and the Logic App can trigger and run. The failure rate of Logic Apps is very low, and the success rate is high.
Supports complex workflows:
It runs behind Azure services, on top of Azure. We have our tenant as a domain under our project subscription. Based on our license and overall requests, Logic Apps provides the best performance. You can have single or multi-chain trigger points within one Logic App function. You can also have nested ones. For example, if job one succeeds, it goes to job two; if not, it goes to job three. You can do this kind of conditional execution based on the success rate.
Keeping up with AI:
Currently, AI mostly plays with data, such as Cosmos DB and Azure Integration Apps. When a customer wants to fetch information out of this data, we can implement AI on the database side. Logic Apps are more for in-house requirements, like generating jobs, presenting jobs, generating reports, saving information into databases, or saving information into block storage. It's a triggering point where manual intervention is not required every time; a one-time configuration is enough.
What is most valuable?
One of the key features is the on-premise service, which we call a scheduler or task manager. However, Logic Apps is not just on-premise. It's capable of triggering Azure Functions, which are purely serverless actions.
For example, if you want to monitor partition consumption in gigabytes without manually going to the Azure portal and selecting the partition view, Logic Apps simplifies this process. You can easily get Azure metrics information and store it somewhere. So, you can automate many tasks using Logic Apps. It's a part of Azure, and we use it mainly to automate our daily tasks and trigger large processes.
Integration capabilities of Azure Logic Apps:
To trigger apps with Logic Apps, you need to know either Python or .NET Core. There are limitations since it's designed and maintained by Microsoft. You must use Microsoft apps to ensure the EXE runtime is automatically managed by Logic Apps. There are boundaries we have to follow to make the Logic event successful. Since it's a Microsoft product, the EXE should be within the Microsoft environment. Python works fine as well.
When Logic Apps triggers something, the runtime must be supported by Azure App Services. If you want to run an EXE built with .NET, it will work. However, if it's built with Java, it won't know how to run it. You need to inform it that the runtime is different from Microsoft. I've mainly used Microsoft services to run Logic Apps, and it works well.
What needs improvement?
In Logic Apps, it supports AJAX and jQuery as commands to filter out to input the parameter. But regular expressions in general aren't supported well. So, I recommend that Logic Apps could be enhanced by supporting regular expressions (RegEx) more comprehensively . That would be a great improvement.
RegEx expressions are useful when running an EXE, and you must provide parameters, like running it for June 2024. You need to feed some information to Logic Apps. I want to tell the program to take the current month and year. For that, you need to use date functions. Using regular expressions in general is also possible by manipulating strings, which is currently missing.
For how long have I used the solution?
I have been using it for one year.
What do I think about the stability of the solution?
It is a stable product. I would rate the stability a nine out of ten.
What do I think about the scalability of the solution?
It is a scalable product. I would rate it a nine out of ten.
How are customer service and support?
Because it's Microsoft support, when we raise a ticket, it will take a week or a couple of weeks to get back to us. So they are normally busy.
We have experts supporting our Azure services to make it better. If we badly need Microsoft, then we rely on Microsoft and raise a ticket. We know that it's going to take much time for them to get back, at least two to three days.
And then, from there, it will take a week to get the solution, either successfully or to determine if what we are trying to do is not workable. The turnaround time is very high.
The main issue is with the time. So, the support could be faster. There are many people opting for new cloud services, so the support from them to the customer is always low.
How would you rate customer service and support?
Which solution did I use previously and why did I switch?
I have also used Cosmos DB and Azure Synapse Analytical Database.
How was the initial setup?
One should have an awareness of the Azure portal. Then, the user will find it very easy to use Logic Apps.
I would rate my experience with the initial setup a nine out of ten, with ten being very easy. Because we need to have some knowledge for regular expressions. Otherwise, it can be done easily.
Deployment time:
It does not take a long time to deploy. Only the task you want to achieve needs to be made as an EXE, and that takes time. But configuring it into a Logic App to run based on the given timeline is very easy. It's a one-time configuration. You must have Azure privileges. If not, you won't be able to at least create or trigger the Logic Apps. You must have the privilege.
What's my experience with pricing, setup cost, and licensing?
The licensing is cheaper because, compared to other services, Azure services are much cheaper and affordable. Any medium to large-scale company can easily afford them. They can scale up and scale down as needed. The charges incurred by Microsoft are within a limit that companies can afford.
What other advice do I have?
If there is a repeated manual job or visiting a portal, downloading something, or manually doing something within the Azure apps, I would recommend using Logic Apps to automate it. It will make lives easier.
Overall, I would rate it a ten out of ten.