Azure Logic Apps vs. HCL DataConnect

Microsoft Azure Logic Apps was a perfect solution for us to integrate the apps and products we used in our business to create automated workflows which were also complex and very advanced. This was a very new feature for us, and also it reduced our software costs massively and also saved us a lot of time. With the crisis, we were in back then Azure turned out to be the best cost-friendly solution because we only had to pay for what we used!

Incentivized

The choice to use Actian DataConnect really comes down to pricing and the type of integration project you are performing, specifically with the requirements, whether you want the integration to be on-premise or in the cloud, can you install agents on your servers etc. For integration tools it runs head to head with its competitors.

Incentivized

• Connecting to different services using OOB connectors
• Support for HTTP connectors which enables user to leverage RestAPIs
• Readability, i.e., it looks just like a Visio diagram. Even managers or HRs can have a look and get to know what's happening
• It's a Programmer's Lego. It's fun connecting them at the same time getting the work done

Incentivized

• Map multiple source and destination tables - what would be done in many steps in SSIS can be done in one or two "maps" in Data Integrator.
• Platform independent, cloud based, no client software.
• Conversion of data types, write flat files - this helps us with integrating systems.
• Fairly straightforward to use if the user has ETL experience.

Incentivized

• It falls short of alerting capabilities.
• Microsoft Azure should be unclouded with its pricing. We don't always know how much an inclusion will affect the monthly price. So we have to speculate where we are with the price and if we can afford to include another asset.

Incentivized

• Integration Manager needs better scheduling improvements. Like dependencies, and not running a process again if the prior run is still running.
• New connector development does not seem a priority.

Incentivized

Azure Logic Apps on the surface are very intuitive. There is definitely room for improvement but it was very well laid out. The main thing with the UI is that its baked into Azure which at times can be a confusing platform to navigate. This is not the fault of Azure Logic Apps for the Azure platform.

Incentivized

As with other Microsoft Azure support, Microsoft Logic Apps is hit or miss depending on the issue you are having. If it's simple then the resolution can be very quick. If it requires an engineer to review, then it will take them quite a while to look up a solution as they dig through.

This is very dependent on the line of work you are in and the unique company requirements, as is the case with everything. We utilize Azure Logic Apps for all of our computing solutions within our domain, and it has always worked flawlessly. One of the simplest clouds to set up and use is by far the most popular.

Incentivized

Data Integrator was initially a part of a package deal for us with our new Student Information System. It was chosen prior to my arrival at the institution. Since I discovered we have SQL Server licenses, we have decided to use SSIS instead since I have a background in the MSBI stack and SSIS appears to be more straightforward (process flow philosophy vs "map" philosophy.)

Incentivized

• Moving to Serverless Computing obviously makes the organization get rid of dependent Infra.
• ROI can be seen immediately as the required infra can be decommissioned after a successful quarter run.
• Being deployed as a single entity or single app on Azure Logic Apps, Organizations need to be more careful with controls applied to meet compliance and security posture.

Incentivized

• Our customer likes the consistent reliable integrations we have built so we [got] a definite return on investment.
• Problems are fairly easy to handle and rework.

Incentivized