What users are saying about

Actian Pervasive Data Integrator

3 Ratings
Score 3.7 out of 101

Ensemble

2 Ratings
Score 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

Ensemble

  • Best suited for fast development with a fundamental emphasis on object orientation
  • Prohibitive costs for very small integration projects
Nigel Timothy Bloom-Salm profile photo

Feature Rating Comparison

Data Source Connection

Actian Pervasive Data Integrator
7.0
Ensemble
Connect to traditional data sources
Actian Pervasive Data Integrator
7.0
Ensemble

Data Transformations

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

Data Modeling

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

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
  • Fast Development.
  • Incredible performance especially in the realm of massive transactional based data systems.
  • Extensive and customizable adapter technologies for integration with just about any system/technology current IT development has need for in this day and age of developing single user interfaces to multiple data sources and/or applications.
  • One of the most secure database technologies available.
Nigel Timothy Bloom-Salm 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
  • Given that Ensemble and Cache are one of if not the only true fully object orientated database/development technologies for massive transactional data systems its customizability is extensive and it just comes down to the creativity of the developer to get the products to pretty much do whatever they want to do with it. However, this is not necessarily obvious to newcomers to the technology.
  • The developer community could do with greater participation from the software developers/application specialists and engineers within InterSystems.
  • More extensive documentation and greater access to proven working solutions particularly in the realm of some of the lesser known or new and upcoming technologies.
Nigel Timothy Bloom-Salm profile photo

Usability

No score
No answers yet
No answers on this topic
Ensemble9.0
Based on 1 answer
Nigel Timothy Bloom-Salm profile photo

Support

No score
No answers yet
No answers on this topic
Ensemble9.0
Based on 1 answer
I have yet to raise an issue with InterSystems WRC that they have been unable to resolve to my satisfaction in the 20+ years that I have worked with their products.
Nigel Timothy Bloom-Salm 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
There is just no comparison. Try it and see for yourself. Furthermore based on information from software houses I have interacted with over the years it far out paces products like WebSphere.
Nigel Timothy Bloom-Salm 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
  • I was able to develop a fully functional integration engine linking pharmacy systems with pharmacy robotics in less than three months in comparison with the year that the previous software development company had taken to develop a solution that was incomplete and did not work using Microsoft technology.
  • The engine I developed was so stable and adaptable that it quickly replaced the equivalent engine supplied by the robot manufacturers own software development team.
  • It has proven to be so effective that it is now the product of choice for future developments within the organization replacing Microsoft technologies which were the previous company standard.
Nigel Timothy Bloom-Salm profile photo

Screenshots

Actian Pervasive Data Integrator
Ensemble

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

Ensemble

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