What users are saying about
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
8 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.6 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

Fivetran

Fivetran works well when you have a lot of data in different places and want to get it all in one spot. I don't think it's as necessary if you have one cluster that needs to be replicated against and the data could wait a day. In this instance, there are other tools.
Scott Laronge | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

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

Data Transformations

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

Data Modeling

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

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

Fivetran

  • Quick replication of data with minimal lag.
  • Automated reporting if data is out of date.
  • The customer support team is relatively good.
Scott Laronge | 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

Fivetran

  • A full schema refresh takes us two-three days and knocks us offline from monitoring up-to-date business KPIs, running updated analyses, etc. This is likely due to us having massive amounts of data (from a count(1) perspective, not size of tables perspective).
  • There's little to no progress estimate on the front end UI to see how long this refresh might take and you need to enable back end logging in Amazon to see where it's at in the sync process and derive rough estimates of completion time.
Scott Laronge | TrustRadius Reviewer

Usability

Actian Pervasive Data Integrator

No score
No answers yet
No answers on this topic

Fivetran

Fivetran 9.0
Based on 1 answer
Just need to input connection info.
Scott Laronge | TrustRadius Reviewer

Performance

Actian Pervasive Data Integrator

No score
No answers yet
No answers on this topic

Fivetran

Fivetran 8.0
Based on 2 answers
It runs pretty well and gets our data from point A to point cluster quickly enough. Honestly, it's not something I think about unless it breaks and that's pretty rare.
Scott Laronge | 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

Fivetran

Honestly, we haven't done much investigation in a while, it just works 360 days of the year. The other five days there may be a hiccup that will throw us a day off of data, but it gets caught up in the end.
Scott Laronge | 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

Fivetran

  • I don't think about ETL (Extract, Transform and Load).
  • I don't process any ETL, it's set it and forget it.
Scott Laronge | TrustRadius Reviewer

Pricing Details

Actian Pervasive Data Integrator

General

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

Fivetran

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
Fivetran
7.0

Usability

Actian Pervasive Data Integrator
Fivetran
9.0

Performance

Actian Pervasive Data Integrator
Fivetran
8.0

Add comparison