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 101
4 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.2 out of 101

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

VertifyData

I would recommend it, as VertifyData exactly fit our use case. I can't speak for all use cases and all connectors - naturally - but the ones we are using and have explored so far, work perfectly well. Also, being a person myself that is not fluent in SQL or JSON or API language in general, I was still able to create all workflows our company needed myself. Which I consider a huge benefit.
Michael Florin profile photo

Feature Rating Comparison

Data Source Connection

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

Data Transformations

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

Data Modeling

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

Cloud Data Integration

Actian Pervasive Data Integrator
VertifyData
6.5
Pre-built connectors
Actian Pervasive Data Integrator
VertifyData
6.3
Connector modification
Actian Pervasive Data Integrator
VertifyData
6.0
Support for real-time and batch integration
Actian Pervasive Data Integrator
VertifyData
5.9
Data quality services
Actian Pervasive Data Integrator
VertifyData
7.8
Data security features
Actian Pervasive Data Integrator
VertifyData
7.3
Monitoring console
Actian Pervasive Data Integrator
VertifyData
5.8

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 profile photo

VertifyData

  • Communication.
  • Follow up.
  • They're constantly trying to improve.
No photo available

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 profile photo

VertifyData

  • Automated error trouble-shooting is not always clear/helpful
  • Clearly distinguishing internal errors vs. external errors
  • Perhaps a blog where users can interact with questions + solutions
No photo available

Usability

Actian Pervasive Data Integrator

No score
No answers yet
No answers on this topic

VertifyData

VertifyData 7.3
Based on 2 answers
Creating a mapping between source and target while also using lookups and transformations is not trivial. And VertifyData solved this reasonably well, at least all users in my organization understood it pretty quickly.
Michael Florin profile photo

Performance

Actian Pervasive Data Integrator

No score
No answers yet
No answers on this topic

VertifyData

VertifyData 6.8
Based on 2 answers
It is not the easiest user interface to read/understand. However, once you understand how it works, then using it is not that bad. It's hard to remember what feature is listed under what tab (Manage vs. Define). A suggestion would be to get all call to actions on the same page
No photo available

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 profile photo

VertifyData

Vertify offered more flexibility and was presented as a simple solution. In reality, it is more complex that we envisioned and we have never fully utilized our tools due to the lack of ability to configure things properly.
No photo available

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 profile photo

VertifyData

  • Independently, teams are able to carry out their process with less communication and at a higher level of accuracy.
  • VertifyData is actively taking into consideration, consulting, and supporting our plans to build out the business
No photo available

Pricing Details

Actian Pervasive Data Integrator

General

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

Actian Pervasive Data Integrator Editions & Modules

Additional Pricing Details

VertifyData

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
Required
$6,000*

* Per License

VertifyData Editions & Modules

Edition
Basic License$6,0001
Standard License$15,0001
Premium License$31,1881
Enterprise License$50,0001
  1. Per Year
Additional Pricing Details
Enterprise License is custom. The starting price is $50,000 and depending on the scope, could increase. There are a la carte options for sandboxes, custom connector builds, and professional services

Rating Summary

Likelihood to Recommend

Actian Pervasive Data Integrator
7.0
VertifyData
7.2

Usability

Actian Pervasive Data Integrator
VertifyData
7.3

Performance

Actian Pervasive Data Integrator
VertifyData
6.8

Add comparison