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

Actian Pervasive Data Integrator [EOL] vs Informatica PowerCenter comparison

 

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 (3rd), Data Visualization (11th)
 

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

"For data transfers and ETLs on Windows, this is a great product."
"There were no concerns with the stability. This product is very good from a stability perspective."
"Web based interface."
"This product is extremely useful and better than building an in-house solution."
"We have been using it for ETL, it is very robust and easy to use."
"I would recommend that others considering the solution go ahead and use it for any batch and high volume loads with complex transactions."
"To me, what's most valuable in Informatica PowerCenter is the flexibility in building the integration pipeline."
"In summary, this is a good tool and I definitely recommend it."
"The setup is very simple."
"Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution."
"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."
"The technical design developed in Excel can be directly imported into Powercenter using Powercenter Repository Manager and the corresponding mapping is automatically created."
"To me, what's most valuable in Informatica PowerCenter is the flexibility in building the integration pipeline. Usually, you need to have a platform to be able to integrate with different technologies, including legacy data such as the mainframe. The platform should also be rich enough to transform the data per your business requirement, with no restrictions. Rich integration and rich transformation capabilities are the two key capabilities in Informatica PowerCenter. The solution also offers ease of use. Another valuable feature of Informatica PowerCenter is the drag-and-drop integration because it's GUI-based, similar to IBM and Oracle."
 

Cons

"Technical support is an area which can definitely improve."
"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)."
"At the moment, we can't even use it for 1, since it keeps failing in our QA testing."
"They should release new versions for the solution's on-premises setup."
"It is very difficult to learn."
"The licensing is difficult."
"The solution must improve the integration with new services."
"The performance of Informatica PowerCenter could improve."
"The solution could have better documentation on basic steps or blocks that specify what to do."
"There is some room for improvement in terms of pricing."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it."
 

Pricing and Cost Advice

Information not available
"Our client has purchased the license, and we are using it."
"Price-wise, it's more expensive than SSIS, but it's a better tool, so it has more features. Licensing is on a yearly basis."
"We are satisfied with the pricing."
"The licensing fees are paid on a yearly basis."
"The price is mostly reasonable."
"We are using an annual license for Informatica PowerCenter."
"The price of Informatica PowerCenter is expensive, but it does give value."
"I would rate the pricing for this solution a six out of ten. The exact pricing depends on various products that you have."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
900,838 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
16%
Manufacturing Company
8%
Computer Software Company
7%
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 Business15
Midsize Enterprise11
Large Enterprise75
 

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, Microsoft, Palantir and others in Data Integration. Updated: June 2026.
900,838 professionals have used our research since 2012.