Skip to main content
TrustRadius
HCL DataConnect

HCL DataConnect
Formerly Actian DataConnect

Overview

What is HCL DataConnect?

HCL DataConnect (formerly Actian DataConnect) is a hybrid integration solution that enables users to integrate anything, anywhere, anytime. It can be deployed in on-premise, cloud, and/or hybrid environments and offers quick onboarding. With its emphasis data quality, data reuse, adaptability…

Read more
Recent Reviews

TrustRadius Insights

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 …
Continue reading
Read all reviews
Return to navigation

Product Details

What is HCL DataConnect?

HCL DataConnect (formerly Actian DataConnect) is a hybrid integration solution that enables users to integrate anything, anywhere, anytime. It can be deployed in on-premise, cloud, and/or hybrid environments and offers quick onboarding. With its emphasis data quality, data reuse, adaptability and self-service integration, DataConnect is designed to support rapid onboarding and deliver the fast time to value.

HCL DataConnect Features

Data Source Connection Features

  • Supported: Connect to traditional data sources
  • Supported: Connecto to Big Data and NoSQL

Data Transformations Features

  • Supported: Simple transformations
  • Supported: Complex transformations

Data Modeling Features

  • Supported: Data model creation
  • Supported: Metadata management
  • Supported: Business rules and workflow
  • Supported: Collaboration
  • Supported: Testing and debugging

Data Governance Features

  • Supported: Integration with data quality tools
  • Supported: Integration with MDM tools

Additional Features

  • Supported: Design and management intuitiveness
  • Supported: Connect anything
  • Supported: Design once, deploy anywhere
  • Supported: Migration
  • Supported: Data profiling
  • Supported: Data Quality
  • Supported: Scales rapidly
  • Supported: Future-proof and Portable
  • Supported: End-to-end Security and Compliance
  • Supported: Simplified Architecture
  • Supported: Performance Tuning
  • Supported: Web Service API Invoker
  • Supported: Built-in Text, XML, and JSON Editors
  • Supported: Hybrid Agent

HCL DataConnect Screenshots

Screenshot of DataConnect is a hybrid integration solution used to design, deploy, and manage integrations on premise, in the cloud or in hybrid environments with no limits on data types or volumes.Screenshot of Actian DataConnect is a versatile hybrid integration platform that supports a wide range of use cases in every industry.Screenshot of DataConnect helps service delivery teams (e.g. SaaS ProServ team, Systems Integrator) rapidly  onboard and maintain application integrations across their customer base.Screenshot of DataConnect helps organizations onboard master data from their customers as part of the customer onboarding and maintenance process.Screenshot of DataConnect helps an enterprise or service provider exchange EDI data with their supply chain, customer network, or partner network.Screenshot of Actian DataConnect

HCL DataConnect Technical Details

Deployment TypesOn-premise, Software as a Service (SaaS), Cloud, or Web-Based
Operating SystemsWindows, Linux
Mobile ApplicationNo
Supported CountriesNorth America, Europe, Asia-Pacific
Supported LanguagesEnglish

HCL DataConnect Customer Size Distribution

Consumers0%
Small Businesses (1-50 employees)20%
Mid-Size Companies (51-500 employees)40%
Enterprises (more than 500 employees)40%
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(18)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

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.

Complicated licensing process: Several users have found the licensing process of the software to be complicated, especially when upgrading from legacy versions.

Steep learning curve and limited user community: Some users have mentioned that the software has a steep learning curve compared to other tools in the market. They also noted that there is not a large user community to rely upon for help, making it difficult to find support and solutions.

Difficulties with implementation and customization: Users have reported difficulties in implementing solutions without plug-ins, mentioning that it is up to the vendor to develop based on client requests. Additionally, some users expressed challenges in building custom plug-ins due to a lack of developer information provided by the software.

Reviews

(1-2 of 2)
Companies can't remove reviews or game the system. Here's why
David Byrd | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
  • 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.
  • 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.
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.
Data Source Connection (2)
95%
9.5
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
90%
9.0
Data Transformations (2)
100%
10.0
Simple transformations
100%
10.0
Complex transformations
100%
10.0
Data Modeling (5)
100%
10.0
Data model creation
100%
10.0
Metadata management
100%
10.0
Business rules and workflow
100%
10.0
Collaboration
100%
10.0
Testing and debugging
100%
10.0
Data Governance (2)
95%
9.5
Integration with data quality tools
90%
9.0
Integration with MDM tools
100%
10.0
  • 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.
  • Boomi
As I stated earlier, DataConnect makes a head-to-head run against the others. It has advantages and disadvantages compared to the competitors. The choice really comes down to pricing and specific requirement needs for the project you are planning. Questions such as On-premise or Cloud, Security, and Specific Connectors available will drive your decision.
Justin Duperre | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
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.
  • 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.
  • 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.
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.
Data Source Connection (2)
35%
3.5
Connect to traditional data sources
70%
7.0
Connecto to Big Data and NoSQL
N/A
N/A
Data Transformations (2)
70%
7.0
Simple transformations
90%
9.0
Complex transformations
50%
5.0
Data Modeling (5)
26%
2.6
Data model creation
N/A
N/A
Metadata management
N/A
N/A
Business rules and workflow
50%
5.0
Collaboration
30%
3.0
Testing and debugging
50%
5.0
Data Governance (2)
N/A
N/A
Integration with data quality tools
N/A
N/A
Integration with MDM tools
N/A
N/A
  • This tool was chosen prior to my arrival and was used to build three integrations. We have decided to switch to SSIS since we have licenses for it and it is a more common tool for ETL integrations.
  • It has been difficult to network with individuals that have experience with this tool.
  • Having been a part of a software package purchased, we have chosen to use a different tool for future integrations and plan to rewrite existing integrations.
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.)
Return to navigation