What users are saying about

Actian Pervasive Data Integrator

3 Ratings
Score 3.7 out of 101

Denodo

4 Ratings
Score 8.9 out of 101

Add comparison

Likelihood to Recommend

Actian Pervasive Data Integrator

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.
Justin Duperre 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 Pervasive Data Integrator
7.0
Denodo
Connect to traditional data sources
Actian Pervasive Data Integrator
7.0
Denodo

Data Transformations

Actian Pervasive Data Integrator
7.0
Denodo
Simple transformations
Actian Pervasive Data Integrator
9.0
Denodo
Complex transformations
Actian Pervasive Data Integrator
5.0
Denodo

Data Modeling

Actian Pervasive Data Integrator
4.3
Denodo
Business rules and workflow
Actian Pervasive Data Integrator
5.0
Denodo
Collaboration
Actian Pervasive Data Integrator
3.0
Denodo
Testing and debugging
Actian Pervasive Data Integrator
5.0
Denodo

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.
Justin Duperre 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

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

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.)
Justin Duperre 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

  • 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.
Justin Duperre 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 Pervasive Data Integrator

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