Automate.io vs. HCL DataConnect

• That scenario where you want your tools interact each other, Automate.io is the best option.
• But even when you need to automate some functions and your tool doesnt give you the option to do it, Automate.io will help you with that.
• It have way more functionalities that im sure u will be happy to explore.

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

• Automatically populates information into other applications.
• Saves tedious work & time checking on information.
• Set it up once and it runs as needed.

• 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

• Speed. Screens sometimes take a long time to load, and data lists occasionally load very slowly or not at all, requiring a refresh.

• 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

Excellent tool, offering excellent ROI.

It is brilliantly superb.

Jay from Automate.io has been very helpful in fixing a problem (my fault - I forgot to read the guide), but he did so in a way that he clearly understood my automation objectives and could provide relevant and handy guidance.

Make sure the person managing it knows APIs and Databases, so they can 'understand' what Automate does and offers. Without such conceptual understanding, Automate is too geeky. WITH such conceptual understanding, Automate is a Church Picnic easy.

• Automate.io is way more friendly and easy to use
• Zapier is more expensive
• Way too many errors
• Zapier Api interaction is not the best

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

• Integration helps numerous departments who are now able to see the data ROI: priceless.
• Dozens of hours saved each month in following up and tracking results ROI: thousands/yr.

• 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