Actian Pervasive Data Integrator vs VertifyData

Likelihood to Recommend

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.

Read full review

Justin Duperre

Data Management Support Specialist

American International CollegeHigher Education, 201-500 employees

View all 1 answers on this topic

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.

Read full review

Michael Florin

Staff Marketing Automation Architect

LogMeInComputer Software, 1001-5000 employees

View all 4 answers on this topic

Feature Rating Comparison

Actian Pervasive Data Integrator

VertifyData

Connect to traditional data sources

Actian Pervasive Data Integrator

VertifyData

Simple transformations

Complex transformations

Actian Pervasive Data Integrator

VertifyData

Business rules and workflow

Collaboration

Testing and debugging

Actian Pervasive Data Integrator

VertifyData

Pre-built connectors

Connector modification

Support for real-time and batch integration

Data quality services

Data security features

Monitoring console

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.

Read full review

Justin Duperre

Data Management Support Specialist

American International CollegeHigher Education, 201-500 employees

View all 1 answers on this topic

Communication.
Follow up.
They're constantly trying to improve.

Read full review

Verified User

Employee in Marketing

Computer Software Company, 51-200 employees

View all 4 answers on this topic

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.

Read full review

Justin Duperre

Data Management Support Specialist

American International CollegeHigher Education, 201-500 employees

View all 1 answers on this topic

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

Read full review

Verified User

Analyst in Other

Human Resources Company, 51-200 employees

View all 4 answers on this topic

Usability

No score

No answers yet

No answers on this topic

Ask the community to sound off

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.

Read full review

Michael Florin

Staff Marketing Automation Architect

LogMeInComputer Software, 1001-5000 employees

View all 2 answers on this topic

Performance

No score

No answers yet

No answers on this topic

Ask the community to sound off

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

Read full review

Verified User

Employee in Marketing

Computer Software Company, 51-200 employees

View all 2 answers on this topic

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

Read full review

Justin Duperre

Data Management Support Specialist

American International CollegeHigher Education, 201-500 employees

View all 1 answers on this topic

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.

Read full review

Verified User

Director in Marketing

Financial Services Company, 51-200 employees

View all 4 answers on this topic

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.

Read full review

Justin Duperre

Data Management Support Specialist

American International CollegeHigher Education, 201-500 employees

View all 1 answers on this topic

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

Read full review

Verified User

Analyst in Other

Human Resources Company, 51-200 employees

View all 4 answers on this topic

Basic License	$6,000¹
Standard License	$15,000¹
Premium License	$31,188¹
Enterprise License	$50,000¹

Likelihood to Recommend