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

Add comparison

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

It is perfect for dumping data from an ODS system into a data warehouse for reporting. It is fast, easy and simple to use. Our sources and Destinations/targets consisted of Oracle database tables (from two completely separate systems), Flat Files (Delimited and fixed), Excel, SQL Queries, and Cobol
Dawn Bauer 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.4
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.5
Simple transformations
Actian Pervasive Data Integrator
9.0
Centerprise Data Integrator
9.1
Complex transformations
Actian Pervasive Data Integrator
5.0
Centerprise Data Integrator
7.9

Data Modeling

Actian Pervasive Data Integrator
4.3
Centerprise Data Integrator
7.1
Business rules and workflow
Actian Pervasive Data Integrator
5.0
Centerprise Data Integrator
7.7
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

  • 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
  • It's incredibly easy to use. The YouTube videos Astera provides are enough to get you started. People with no previous ETL experience can start building simple mappings very quickly.
  • It's incredibly easy to install and maintain. After I first installed Centerprise, I was able to start working in just a few minutes, and the maintenance releases are pretty straightforward.
  • I am particularly impressed with how much Centerprise simplifies transformations that require more work in other ETL tools. The perfect example is the SCD transformation, which handles all the logic in an Slowly Changing Dimension. Even with a market leader like Informatica, the SCD logic has to be manually built. With Centerprise this can be built in just a few minutes, and it impacts every mapping.
Mario Ferrer profile photo

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.
Justin Duperre profile photo
  • The help functionality. Needs better search and more examples.
Mark Rubin profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
Centerprise Data Integrator9.1
Based on 2 answers
We renew yearly, it is a core part of our department's functionality.
No photo available

Usability

No score
No answers yet
No answers on this topic
Centerprise Data Integrator8.0
Based on 5 answers
It would be a 10 if there was more help available ... so I didn't have to contact support all the time.
Dawn Bauer profile photo

Support

No score
No answers yet
No answers on this topic
Centerprise Data Integrator7.7
Based on 4 answers
The help was wonderful. the only reason I dropped it down to an 8 is we struggled with the releases of code and it breaking current code.
Dawn Bauer profile photo

Implementation

No score
No answers yet
No answers on this topic
Centerprise Data Integrator9.1
Based on 2 answers
Think outside the box because Centerprise can take on more than just data integration.
No photo available

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.)
Justin Duperre profile photo
I have been a user of Informatica Power Center for 14 years, and I've always considered it the best ETL product available.Centerprise is relatively new, and although it can't be compared to Informatica yet, I dare to say it offers a few things that even Informatica does not, like the SCD transformation, and overall, the ease of use.I also evaluated open source tools such as Talend and Pentaho, but I realized you must have knowledge of JavaScript to even write some basic logic. While that is not an issue by itself, it makes it overwhelming compared to Centerprise's ease of use. The price was also very reasonable because the open source tools can get pricey once you want additional functionality or licenses.
Mario Ferrer profile photo

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.
Justin Duperre profile photo
  • 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.