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

Centerprise Data Integrator

Centerprise Data Integrator is well-suited for creating ETL packages to load a data warehouse. The product makes it easy to insert data in a variety of ways into a SQL table. It can create a new table-structure, append to existing tables, or reload data in any number of ways. If an organization is already highly skilled in SSIS, this may not be the product for you, but if you're just getting started in having a data warehouse as business practice, this may make the implementation faster and easier for your IT team. You may also find that its easy enough to use that you don't need extensive IT training to use it. We've also found that Data Integrator makes a useful bridge between various database applications. We can easily use it to create automated scripts that run, or to transfer data between systems. Without a team of highly trained software developers, some of these options would've been out of reach for us.
Andre Beaumont profile photo

Feature Rating Comparison

Data Source Connection

Actian Pervasive Data Integrator
7.0
Centerprise Data Integrator
7.8
Connect to traditional data sources
Actian Pervasive Data Integrator
7.0
Centerprise Data Integrator
8.3
Connecto to Big Data and NoSQL
Actian Pervasive Data Integrator
Centerprise Data Integrator
7.3

Data Transformations

Actian Pervasive Data Integrator
7.0
Centerprise Data Integrator
8.6
Simple transformations
Actian Pervasive Data Integrator
9.0
Centerprise Data Integrator
9.1
Complex transformations
Actian Pervasive Data Integrator
5.0
Centerprise Data Integrator
8.1

Data Modeling

Actian Pervasive Data Integrator
4.3
Centerprise Data Integrator
7.2
Business rules and workflow
Actian Pervasive Data Integrator
5.0
Centerprise Data Integrator
8.0
Collaboration
Actian Pervasive Data Integrator
3.0
Centerprise Data Integrator
6.4
Testing and debugging
Actian Pervasive Data Integrator
5.0
Centerprise Data Integrator
7.3

Data Governance

Actian Pervasive Data Integrator
Centerprise Data Integrator
8.2
Integration with data quality tools
Actian Pervasive Data Integrator
Centerprise Data Integrator
8.2
Integration with MDM tools
Actian Pervasive Data Integrator
Centerprise Data Integrator
8.2

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

Centerprise Data Integrator

  • The links to many different data sources made it real easy to gain access to the key data elements and integrate the data across many different systems.
  • The graphical approach is self documenting and permits the rapid assimilation of existing work by new team members.
  • It makes it VERY easy to build source/destination data reconciliations.
  • The ability to incrementally see the data transformation results at any point in a data flow is invaluable.
  • The XML processors make it real easy to process and integrate XML data. We've even used Centerprise on its own data logs to pull out and report on the XML job log data for custom reporting.
  • Centerprise is an invaluable tool for addressing data integration particularly dealing with 'Shadow IT' Excel spreadsheets.
  • The dataflow architecture will take some getting used to as you have to understand the various data flow objects and THINK about how a data flow will work to accomplish what you want.
Phil Nacamuli profile photo

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

Centerprise Data Integrator

  • PDF reports are tricky at times. The columns line up when printed on paper. But Centerprise does not always see the columns this way.
David Farler profile photo

Likelihood to Renew

Actian Pervasive Data Integrator

No score
No answers yet
No answers on this topic

Centerprise Data Integrator

Centerprise Data Integrator 9.1
Based on 2 answers
We renew yearly, it is a core part of our department's functionality.
No photo available

Usability

Actian Pervasive Data Integrator

No score
No answers yet
No answers on this topic

Centerprise Data Integrator

Centerprise Data Integrator 8.0
Based on 5 answers
It's very intuitive and visually descriptive. The interface is standard windows drag and drop although cut and paste are not universally available depending upon what function you're trying to do. You see the ETL and what it's doing. You can inspect the data elements the transformations and perform data previews incrementally along the data flow. You actually SEE what the results are and you can make adjustments without black box testing
Phil Nacamuli profile photo

Support

Actian Pervasive Data Integrator

No score
No answers yet
No answers on this topic

Centerprise Data Integrator

Centerprise Data Integrator 7.7
Based on 4 answers
I have always had my support questions answered with timely follow-up and even queries regarding my satisfaction if I've gotten lazy and NOT closed a resolved call. To date ALL of my support questions have been answered.
Phil Nacamuli profile photo

Implementation

Actian Pervasive Data Integrator

No score
No answers yet
No answers on this topic

Centerprise Data Integrator

Centerprise Data Integrator 9.1
Based on 2 answers
Think outside the box because Centerprise can take on more than just data integration.
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

Centerprise Data Integrator

We are currently looking at Mulesoft as a replacement.
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

Centerprise Data Integrator

  • The tool has had significant impact on our ability to gather and convert competitive data where the competitor will not provide or allow access to their data source directly. If their system will generate reports, we can convert it.
Dave Worthington profile photo

Screenshots

Actian Pervasive Data Integrator

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

Actian Pervasive Data Integrator
Additional Pricing Details

Centerprise Data Integrator

General

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

Centerprise Data Integrator Editions & Modules

Centerprise Data Integrator
Edition
Centerprise Enterprise
Contact rep1
1. Lifetime License per Seat
Additional Pricing Details
Discounts are provided for 10 pack, 20 pack, 50 pack, and enterprise wide Centerprise Professional licenses.

Add comparison