Actian Pervasive Data Integrator [EOL] vs Informatica PowerCenter comparison

Why PeerSpot?

Actian and Informatica are both solutions in the Data Integration category. Additionally, 50% of Actian users are willing to recommend the solution, compared to 91% of Informatica users who would recommend it.

Actian Pervasive Data Integ...

Read 6 Actian Pervasive Data Integrator [EOL] reviews

50% willing to recommend

Informatica PowerCenter

Read 85 Informatica PowerCenter reviews

17,332 Views
12,999 Comparison Views

91% willing to recommend

Actian Pervasive Data Integ...

Informatica PowerCenter

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Actian Pervasive Data Integrator [EOL] and Informatica PowerCenter based on real PeerSpot user reviews.

Find out what your peers are saying about Informatica, Microsoft, Palantir and others in Data Integration.

To learn more, read our detailed Data Integration Report (Updated: October 2026).

Buyer's Guide

Data Integration

October 2026

Download the complete report

Helped 921,523 peers since 2012

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

Ranking in other categories

No ranking in other categories

Informatica PowerCenter

Average Rating

8.0

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Data Integration (4th), Data Visualization (13th)

Featured Reviews

BI Shnu Bhatta

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…

Read full review

Hemanthreddy Vakiti

Data Engineer at a tech vendor with 10,001+ employees

Streamlined daily sales workflows have reduced team size and enabled earlier, accurate reporting

One of the best features I appreciate about Informatica PowerCenter is that anyone with minimal knowledge of ETL can easily use it. It has four different interfaces: Monitor, Repository, Designer, and Workflow Manager. With our use case, we can easily go to that particular interface and use it. Another valuable feature is the use of Mapplets; if we have one mapping created that we want to use again and again for other workflows, we can create a Mapplet and save it so that we can reuse the mapping, reducing our workload. Informatica PowerCenter has positively impacted my organization because, as I mentioned previously, the development team has been reduced to half since we moved to it due to its easy interface and the reusability of Mapplets. It has also saved us a lot of time; for example, it has saved nearly one hour per day on monitoring and workflow tasks. Saving one hour a day is key because it has led us to report the data to business users one hour earlier than the usual time. If there are any anomalies or defects in the data, we can easily rectify them within that hour, which reduces the chance of errors in the data. Regarding cost, the number of people working on the project has been reduced to half, thus significantly decreasing costs for our organization since we moved to Informatica PowerCenter.

Read full review

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."

"This product is extremely useful and better than building an in-house solution."

"Web based interface."

"We have been using it for ETL, it is very robust and easy to use."

"It's a complete package, which is why we use this solution."

"It reduces a lot of legacy coding."

"Informatica is scalable, it's perfect."

"The ETL is able to extract transform load from/to a variety of sources, like Oracle, Microsoft's SQL Server, and Big Data."

"Error handling capability is quite good in Informatica PowerCenter because it provides a very detailed session log, which is really helpful to identify errors."

"The technical design developed in Excel can be directly imported into Powercenter using Powercenter Repository Manager and the corresponding mapping is automatically created."

"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."

"It is UI friendly and has all the advantages of an ETL tool."

More Informatica PowerCenter pros

Cons

"At the moment, we can't even use it for 1, since it keeps failing in our QA testing."

"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)."

"The only problem is that it is moderately expensive, which is essential to emphasize."

"Informatica PowerCenter is outdated and would benefit from modernization. They should have a very good migration strategy from Informatica PowerCenter to AACF. Informatica PowerCenter there is no point in using it, you have to use a cloud version."

"The solution must improve the integration with new services."

"Informatica PowerCenter could improve by having a single interface because half of the system is still in the legacy interface and many other elements are moved to the developer client. It would be good if there was a single interface for the end user and developers."

"While Informatica is great for data-integration, it does not have any analytics features. Thus, organizations have to always look for another product for their BI needs."

"Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic."

"It is very difficult to learn."

"The documentation could be improved."

More Informatica PowerCenter cons

Pricing and Cost Advice

Information not available

"I would rate the pricing for this solution a six out of ten. The exact pricing depends on various products that you have."

"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."

"It is for big enterprises. We have leveraged Informatica for big enterprises but not for small and medium enterprises because it is a very costly product as compared to other products. We propose this solution only for enterprise customers. For small to medium enterprises, we would propose the Microsoft solution. Its licensing is currently bundle-wise. It should be features-wise and not bundle-wise."

"Its maintenance is expensive."

"Compared to other tools, I think PowerCenter is a bit expensive. When I compare it to Oracle, if you want to use Oracle databases, you can easily get an ODI tool, so it's easier to handle. Informatica is a standalone tool—it's an independent company—and there are no databases around them, so it's quite expensive to use. Generally, large companies use PowerCenter because of the price. If companies want to expand their usage areas, they try to consider if it's easy to implement and easy to understand the pricing. I think the pricing is a barrier for Informatica."

"Its licensing is expensive in terms of scaling."

"We have found the pricing very cost-effective. The licensing is CPU and data source-based."

"We are satisfied with the pricing."

More Informatica PowerCenter pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Data Integration solutions are best for your needs.

See recommendations

921,523 professionals have used our research since 2012.

Comparison Review

it_user90069

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…

Read full review

Top Industries

By visitors reading reviews

No data available

Financial Services Firm

16%

Manufacturing Company

Outsourcing Company

Construction Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	3
Large Enterprise	4

By reviewers
Company Size	Count
Small Business	14
Midsize Enterprise	11
Large Enterprise	76

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...

See all answers

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...

See all answers

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...

See all answers

Comparisons

Oracle Data Integrator (ODI) vs Actian Pervasive Data Integrator [EOL]

Compared 10% of the time

SSIS vs Actian Pervasive Data Integrator [EOL]

Compared 10% of the time

MuleSoft Anypoint Platform vs Actian Pervasive Data Integrator [EOL]

Compared 6% of the time

IBM B2B Integrator vs Actian Pervasive Data Integrator [EOL]

Compared 5% of the time

Avada Software Infrared360 vs Actian Pervasive Data Integrator [EOL]

Compared 4% of the time

More Actian Pervasive Data Integrator [EOL] Competitors

Oracle Data Integrator (ODI) vs Informatica PowerCenter

Compared 6% of the time

Informatica Intelligent Data Management Cloud (IDMC) vs Informatica PowerCenter

Compared 5% of the time

WhereScape RED vs Informatica PowerCenter

Compared 5% of the time

SSIS vs Informatica PowerCenter

Compared 5% of the time

Pentaho Data Integration and Analytics vs Informatica PowerCenter

Compared 4% of the time

More Informatica PowerCenter Competitors

Product Reports

Buyer's Guide

Data Integration

October 2026

Actian Pervasive Data Integrator [EOL] report

Download Actian Pervasive Data Integrator [EOL] product report

Buyer's Guide

Informatica PowerCenter

October 2026

Download Informatica PowerCenter product report

Also Known As

Pervasive Data Integrator, PDI

PowerCenter

Overview

Pervasive's Data Integrator platform is a robust enterprise data integration software solution that enables you to quickly build powerful and frictionless connections between any kind of data source and application.

Actian

Informatica PowerCenter is known for its robust data integration, scalability, and user-friendly interfaces. It simplifies data processing with real-time capabilities, handling large datasets efficiently. Its adaptability with diverse sources makes it suitable for complex data environments.

Informatica PowerCenter offers extensive transformation options with features like flow designer, mapping, and error handling, enhancing development efficiency. Its GUI interface allows seamless integration across different platforms, making it suitable for managing extensive datasets. Traceability and support cater to evolving data requirements, while adaptability with multiple sources aids in driving strategic data outputs. Some areas for improvement include a more robust cloud strategy, better documentation, and improved API integrations. Enhanced automation and setup processes could further refine the experience.

What are the key features of Informatica PowerCenter?

Data Integration: Facilitates robust data handling across numerous platforms.
Real-Time Processing: Manages data workflows efficiently in real-time.
Transformation Options: Provides extensive options for data mapping and manipulation.
Error Handling: Enhances development through efficient error management.
Scalability: Supports growing data needs with adaptability across diverse systems.

What benefits should users look for?

Scalability: Supports growth with efficient data management and integration.
Efficiency: Offers user-friendly interfaces for streamlined workflows.
Support: Provides traceability and comprehensive support for large data handling.
Adaptability: Integrates seamlessly with various data platforms, enhancing flexibility.
Future-Preparedness: Ready for transition to cloud environments for better scalability.

Informatica PowerCenter plays a vital role in data integration and ETL processes for building data warehouses. Industries like banking, insurance, and healthcare utilize it for extracting, transforming, and loading data into target systems, supporting analytics, reporting, and compliance. Companies often transition to cloud environments for enhanced scalability and efficiency.

Informatica

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: October 2026.

DOWNLOAD NOW

921,523 professionals have used our research since 2012.

See our list of best Data Integration vendors.

We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.