No more typing reviews! Try our Samantha, our new voice AI agent.

Actian Pervasive Data Integrator [EOL] vs Informatica PowerCenter comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Actian Pervasive Data Integ...
Average Rating
5.8
Number of Reviews
6
Ranking in other categories
No ranking in other categories
Informatica PowerCenter
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
85
Ranking in other categories
Data Integration (4th), Data Visualization (13th)
 

Featured Reviews

BB
Associate Manager at a tech services company with 10,001+ employees
It is stable and we did not have any issues with initial setup. I am not sure if there are various connectors available in the recent version to support the wide range of sources available.
I am not sure if there are various connectors available in the recent version of Pervasive DI to support the wide range of sources available (e.g., big data, cloud, EME) I have been using it for 6-7 months. There were no concerns with the stability. This product is very good from a stability…
Garima Goel - PeerSpot reviewer
Associate Principal Engineer at Nagarro
Has supported complex data pipeline creation but performance tuning and monitoring responsiveness need improvement
Sometimes, I see various performance issues with Informatica PowerCenter, including caching concerns, whether it's a joiner transformation or other transformations, so I believe the team can enhance the performance perspectives of these transformations. Additionally, sometimes the Informatica Monitor hangs or takes time to open the current run or logs, which the team can also look into. Informatica is transitioning to cloud solutions and discontinuing on-premise support after 2026, so when we discuss Informatica Cloud and its support, it becomes quite expensive for the organization compared to peers such as SnapLogic or Netezza, which offer lower pricing. Informatica Cloud Intelligence's pricing is notably high.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"This product is extremely useful and better than building an in-house solution."
"Web based interface."
"There were no concerns with the stability. This product is very good from a stability perspective."
"We have been using it for ETL, it is very robust and easy to use."
"For data transfers and ETLs on Windows, this is a great product."
"It provides everything I need."
"In general, it is a great tool."
"It is very robust, scalable, and simple to use, and it is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"It is easy to use, and it is quick for developing things. It is fairly powerful, and it can integrate with a lot of different platforms without much hassle."
"The most complex task, in this case, was to read and transform BLOB data, and Java transformation in Informatica Power Center was a great solution."
"Informatica PowerCenter is worth the money to use for its benefits."
"I like the completeness of the way I can build ETL workflows; it's not one feature that stands out, rather it's the way everything is working together."
"Once you figure it out, it is a powerful and simple ETL tool. Its stability has been very satisfactory."
 

Cons

"The areas which I think need to be improved are the transform and load steps."
"I am not sure if there are various connectors available in the recent version of Pervasive DI to support the wide range of sources available (e.g., big data, cloud, EME)."
"Technical support is an area which can definitely improve."
"At the moment, we can't even use it for 1, since it keeps failing in our QA testing."
"Its interface can be modernized. It is an old product. I have been working with it for 14 years, and it still looks the same. It hasn't been modernized much. It also needs to handle more modern formats, such as JSON files. It works with the old text files and databases, but it does not always work with the newer, modern stuff. You need to make your own programs to support that kind of stuff. Support is also a kind of difficult with Informatica. They don't do direct support and rely on using their distributors around the globe for support, which means that you kind of have to go through this layer of different companies before you get help."
"The only problem is that it is moderately expensive, which is essential to emphasize."
"The solution currently requires quite an established data center in place because there is no option for software as a service so the best option to install the platform is on-prem."
"It is very difficult to learn."
"Configuration is complicated and could be simplified; it requires experience, and not many people have that."
"This product is going to decommission in the next couple of years."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
"In terms of innovation, creativity is not there in this solution. It is still an on-prem ETL tool."
 

Pricing and Cost Advice

Information not available
"According to what I've heard and read on various blogs, it's quite expensive when compared to similar competitive products."
"The license model is CPU based."
"I rate the product's price a ten on a scale of one to ten, where one is a low price, and ten is a high price."
"Informatica PowerCenter is reasonably priced. It is less expensive than Pentaho. There is a standard version fee in Taiwan. It is a one-time yearly subscription price that is approximately $3,010 US dollars for three users."
"Licensing is a one time cost. But maintenance costs depend on what you want, how long you need it. Maintenance is a kind of insurance. With health insurance, you don't know whether you will get sick or need to go to hospital or not but you have to have insurance. It's the same thing with support. If you have that expertise in resolving issues, if you have enough experience in your IT department, I would say you don't need the support. But in practice, they recommend you go with the support. If you want support you have to pay for it."
"Pricing for Informatica PowerCenter isn't cheap, but if I compare it with IBM, it's as expensive as IBM, however, Informatica PowerCenter is more innovative, especially when compared to a giant company such as IBM that has thousands of products. Informatica PowerCenter is limited only to data management, but it has new features that come out every quarter. Points for ease of use and flexibility go to Informatica PowerCenter, but price-wise, IBM and Informatica are equal because they're both expensive."
"We have a site license, but we do pay by the division."
"The pricing is a little expensive, but in the same range as IBM and other competitors."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
914,109 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
BI Expert at a healthcare company with 1,001-5,000 employees
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
No data available
Financial Services Firm
15%
Manufacturing Company
8%
Outsourcing Company
8%
Government
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business3
Large Enterprise4
By reviewers
Company SizeCount
Small Business14
Midsize Enterprise11
Large Enterprise76
 

Questions from the Community

Ask a question
Earn 20 points
How does Azure Data Factory compare with Informatica PowerCenter?
Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stability and reliability I am looking for, good scalability, and is easy to set up an...
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
Which Informatica product would you choose - PowerCenter or Cloud Data Integration?
Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a real data governance strategy. Additionally, PowerCenter is able to manage huge...
 

Also Known As

Pervasive Data Integrator, PDI
PowerCenter
 

Overview

 

Sample Customers

Pediatrix Medical Group
University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
Find out what your peers are saying about Informatica, Palantir, Microsoft and others in Data Integration. Updated: September 2026.
914,109 professionals have used our research since 2012.