TrustRadius: an HG Insights company
Back to Overview
HCL DataConnect Logo

HCL DataConnect Reviews and Ratings

Rating: 6 out of 10
Score
6 out of 10

Community insights

TrustRadius Insights for HCL DataConnect are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

Easy-to-use Design: Several users have found the design of the ETL tool to be user-friendly and easy to navigate, making it a breeze to create ETLs.

Flexible Data Handling: Many reviewers have praised the flexibility of the software when it comes to mapping, moving, and transforming data. They appreciate its ability to handle various data scenarios and different situations with ease.

Wide Range of Connectors: A significant number of users have highlighted the variety of connectors available in the software. Particularly in the healthcare space where HIPAA compliance is crucial, customers appreciate the availability of connectors for reading different file formats.

Reviews

2 Reviews

Why Actian DataConnect goes head to Head with the Big Boys

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

We use Actian DataConnect to load data in and out of Oracle CRM On Demand and Oracle Sales Cloud. The inbound data comes from many different sources including JD-Edwards, SAP, IMS, and other CRM type products. Most of the outbound data feeds to other systems via CSV type of files. We use DataConnect for our customer base. Each customer has their own licenses and we support their integrations.

Pros

  • The large connector base for DataConnect is outstanding. However even when they do not have a custom connector, they have a web services Invoker which allows you to connect to any web services.
  • The underlying scripting language is Visual Basic-ish. Very easy to start.
  • The product has been around a long time, through multiple company acquistions, and still is a competitive player via pricing.
  • Support team is awesome.
  • Large user community.

Cons

  • 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.

Likelihood to Recommend

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.

DB
David Byrd
Sr Integration Engineer - Dual Certified in Dell Boomi Developer 1 & 2, and Actian DataConnect in Information Technology at SFCG (11-50 employees)
Vetted Review
HCL DataConnect
23 years of experience
View profile

Data Integrator - A worthy competitor to SSIS?

Rating: 7 out of 10
Incentivized

Use Cases and Deployment Scope

We use Data Integrator to bridge data from our Admissions software to our Student Information System. It is used by the IT developers only, with guidance from both the Admissions department and Registrars department. We have three bridges we have built using Data Integrator, one for each main branch/type of student. This product allows us to successfully transition the data appropriately into our core system.

Pros

  • 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.

Cons

  • Sometimes the screen does not load- since it is a web based software, this can be seen as a reliability issue.
  • "Maps" can become somewhat complex, and between multiple developers this can be painful when sharing or explaining others' work.
  • The concept of macros adds flexibility in how to solve problems, but is a separate language and can take time to learn and master.

Likelihood to Recommend

I wouldn't recommend Data Integrator over SSIS, but it may be a better tool than other ETL offerings. Having a background in the Microsoft Stack, I am hesitant to recommend any other products especially in a Microsoft-centric company. If this was the only option to use, I think it does a good job at integrating systems after taking time to learn the approach. "Maps" in Data Integrator is definitely different than "process flow" philosophy in SSIS.

JD
Justin Duperre
Data Management Support Specialist in Information Technology at American International College (201-500 employees)
Vetted Review
HCL DataConnect
1 year of experience
View profile