What users are saying about

Denodo

4 Ratings

Actian DataConnect

3 Ratings
Score 8.3 out of 101

Denodo

4 Ratings
Score 8.9 out of 101

Add comparison

Likelihood to Recommend

Actian DataConnect

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.
David Byrd profile photo

Denodo

Denodo is a data virtualization software that works on real-time data. Choose it when you do not want to have a local storage or replication. 1. Do you need to mashup data from different datasources returning different types of data at real-time? Denodo works here.2. Do you need to do data aggregation and run reports on local data? Denodo may not be the best fit.3. Do you want a wrapper for your database and expose as webservices? Maybe Denodo can fit. However this is purely based on business needs.4. Do you want to use Denodo as a caching layer? Maybe Denodo is not suited for this. You have to look at specific caching solutions.5. Is time-to-market a key factor? Integrating two sources was a cakewalk with Denodo. It is a compromise of cost vs. time-to-market. 6. How frequently will you need to integrate another datasource or a new data set? One time integration may be best to achieve outside of Denodo or any data virtualization platform for that matter.
Karthick Subharaj Rajarathinam profile photo

Feature Rating Comparison

Data Source Connection

Actian DataConnect
9.5
Denodo
Connect to traditional data sources
Actian DataConnect
10.0
Denodo
Connecto to Big Data and NoSQL
Actian DataConnect
9.0
Denodo

Data Transformations

Actian DataConnect
10.0
Denodo
Simple transformations
Actian DataConnect
10.0
Denodo
Complex transformations
Actian DataConnect
10.0
Denodo

Data Modeling

Actian DataConnect
10.0
Denodo
Data model creation
Actian DataConnect
10.0
Denodo
Metadata management
Actian DataConnect
10.0
Denodo
Business rules and workflow
Actian DataConnect
10.0
Denodo
Collaboration
Actian DataConnect
10.0
Denodo
Testing and debugging
Actian DataConnect
10.0
Denodo

Data Governance

Actian DataConnect
9.5
Denodo
Integration with data quality tools
Actian DataConnect
9.0
Denodo
Integration with MDM tools
Actian DataConnect
10.0
Denodo

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.
David Byrd profile photo
  • Flat learning curve.
  • Does not need brilliant developers.
  • Less need for custom denodo wrappers, even if needed is not very complex.
  • Denodo stored procedures and functions helped address complex, not straightforward requirements.
  • Export/import deployment between environments was very helpful.
Karthick Subharaj Rajarathinam profile photo

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.
David Byrd profile photo
  • Caching - but I am sure it will be improved by now. There were times when we expected the cache to be refreshed but it was stale.
  • Schema generation of endpoints from API response was sometimes incomplete as not all API calls returned all the fields. Will be good to have an ability to load the schema itself (XSD/JSON/Soap XML etc).
  • Denodo exposed web services were in preliminary stage when we used; I'm sure it will be improved by now.
  • Export/Import deployment, while it was helpful, there were unexpected issues without any errors during deployment. Issues were only identified during testing. Some views were not created properly and did not work. If it was working in the environment from where it was exported from, it should work in the environment where it is imported.
Karthick Subharaj Rajarathinam profile photo

Alternatives Considered

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.
David Byrd profile photo
I did not use any other data virtualization platform. BizTalk is not the right comparison; it is an integration layer and for orchestration; do not use denodo as an orchestration layer, it is not for connecting upstreams to downstreams and orchestrate data flows, it is primarily for pulling information and presenting in a fashion that benefit the audience
Karthick Subharaj Rajarathinam profile photo

Return on Investment

  • 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.
David Byrd profile photo
  • Improved time-to-market. We addressed new requirements in less than 2 person days.
  • Very agile. Easy to handle changing requirements. Like a new requirement, a change in requirement was not expensive either.
  • Platform issues were difficult to diagnose and debug.
Karthick Subharaj Rajarathinam profile photo

Pricing Details

Actian DataConnect

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

Denodo

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details