4 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 3 out of 100
3 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 10 out of 100

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 | TrustRadius Reviewer

InterSystems Ensemble

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

Feature Rating Comparison

Data Source Connection

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

Data Transformations

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

Data Modeling

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

Pros

Actian Pervasive Data Integrator

  • 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 | TrustRadius Reviewer

InterSystems Ensemble

  • Easy to use: The simplicity of its programming language allows fast learning. Visual environment to generate complex code.
  • Robust: A fall of the system will not be a problem. Never again will information of the transactions in progress be lost. Never more messages lost.
  • Connect to the world: The most popular connection is possible to implement quickly. FTP, File folder, TCP, SMPT, REST.... all method are ready to use. Only define "where" and "how"
Francisco Lopez de las Heras | TrustRadius Reviewer

Cons

Actian Pervasive Data Integrator

  • 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 | TrustRadius Reviewer

InterSystems Ensemble

  • 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 | TrustRadius Reviewer

Support Rating

Actian Pervasive Data Integrator

No score
No answers yet
No answers on this topic

InterSystems Ensemble

InterSystems Ensemble 9.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 | TrustRadius Reviewer

Alternatives Considered

Actian Pervasive Data Integrator

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 | TrustRadius Reviewer

InterSystems Ensemble

Mirth is another integration platform that we have used but its development, in Java, made us always create new methods every time a new product was integrated. Every connection process had to be developed from the beginning and it was not easy to reuse code. Nor did it allow us to have an extensive catalog of HL7 messaging, having to perform the validation of each and every one of its fields manually.
Francisco Lopez de las Heras | TrustRadius Reviewer

Return on Investment

Actian Pervasive Data Integrator

  • 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 | TrustRadius Reviewer

InterSystems Ensemble

  • We have integrated 5 laboratories in a treatment monitoring system in less than a month of development. Being able to integrate the following in a period no longer than a week.
Francisco Lopez de las Heras | TrustRadius Reviewer

Screenshots

Actian Pervasive Data Integrator

InterSystems Ensemble

Pricing Details

Actian Pervasive Data Integrator

General

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

InterSystems Ensemble

General

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

Rating Summary

Likelihood to Recommend

Actian Pervasive Data Integrator
7.0
InterSystems Ensemble
9.0

Usability

Actian Pervasive Data Integrator
InterSystems Ensemble
9.0

Support Rating

Actian Pervasive Data Integrator
InterSystems Ensemble
9.0

Add comparison