Why Actian DataConnect goes head to Head with the Big Boys
March 27, 2017

Why Actian DataConnect goes head to Head with the Big Boys

David Byrd | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Actian DataConnect

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

HCL DataConnect Feature Ratings

Connect to traditional data sources
10
Connecto to Big Data and NoSQL
9
Simple transformations
10
Complex transformations
10
Data model creation
10
Metadata management
10
Business rules and workflow
10
Collaboration
10
Testing and debugging
10
Integration with data quality tools
9
Integration with MDM tools
10