elastic.io Integration Platform vs. HCL DataConnect

elastic.io Integration Platform is well suited for developers already leveraging the Elastic Search cluster, who want to automate and simplify add-on integrations. If developers are streaming data between plugins and want to have event-based batching, this is a great product to do that, albeit a paid solution, it can enhance your deployment and automation of ES plugins.

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

• Unlike other integration platforms, using and implementing elastic.io is fairly simple and intuitive
• You do not need to worry about scaling since it is taken care by the platform itself
• Developing new connectors isn't complicated

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

• Paid solutions are always challenging when the tool itself is free
• Available training for this paid solution

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

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

• If your datasets are diverse and could use automation, this will bring good ROI for time spent

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