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

7.0

VertifyData

—

Connect to traditional data sources

7.0

—

Actian Pervasive Data Integrator

7.0

VertifyData

—

Simple transformations

9.0

—

Complex transformations

5.0

—

Actian Pervasive Data Integrator

4.3

VertifyData

—

Business rules and workflow

5.0

—

Collaboration

3.0

—

Testing and debugging

5.0

—

Actian Pervasive Data Integrator

—

VertifyData

6.5

Pre-built connectors

—

6.3

Connector modification

—

5.9

Support for real-time and batch integration

—

5.8

Data quality services

—

7.7

Data security features

—

7.3

Monitoring console

—

5.7

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

Ease of use - I don't want to say that data integration platforms couldn't still be easier to use, but given the complexity of the matter, I think VertifyData is doing a great job of being understandable, consistent and logical.
Reliability of service - once you leave the setup phase behind you, the data movement machine runs in the background without any noise or interruption.

Read full review

Michael Florin

Staff Marketing Automation Architect

LogMeInComputer Software, 1001-5000 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

I think the UI could get a refresher. It looks a little old-school and I sometimes get lost in the navigation.
I saw some inconsistencies on the scheduler, most likely caused by time zone differences. One dialogue reflected the user's time zone, the next server's time zone.

Read full review

Michael Florin

Staff Marketing Automation Architect

LogMeInComputer Software, 1001-5000 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

We are moving and have moved tens of millions of records, and in initial load phase we sometimes struggled. Errors were returned from the endpoints, but after we've moved past that phase, we have never experienced any issues. Definitely no measurable impact on the adjacent systems.

Read full review

Michael Florin

Staff Marketing Automation Architect

LogMeInComputer Software, 1001-5000 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

I've never used Bedrock Data, we only got demos, so I am not sure.

Read full review

Verified User

Employee in Marketing

Computer Software 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

Right now we can't use any of the Opp reports Marketo provides, because we are working with the Vertify team to clean up some Opp data and sync that data differently going forward, so right now I have to say zero positive impact, but they feel confident that we will be able to utilize those features of Marketo soon, so that's good to hear.

Read full review

Verified User

Employee in Marketing

Computer Software Company, 51-200 employees

View all 4 answers on this topic

Likelihood to Recommend