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

Informatica PowerCenter vs Python Connectors comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive SummaryUpdated on Jun 3, 2026

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

Informatica PowerCenter
Ranking in Data Integration
4th
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
85
Ranking in other categories
Data Visualization (13th)
Python Connectors
Ranking in Data Integration
38th
Average Rating
10.0
Reviews Sentiment
8.5
Number of Reviews
1
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2026, in the Data Integration category, the mindshare of Informatica PowerCenter is 3.7%, down from 5.1% compared to the previous year. The mindshare of Python Connectors is 0.5%, up from 0.5% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Mindshare Distribution
ProductMindshare (%)
Informatica PowerCenter3.7%
Python Connectors0.5%
Other95.8%
Data Integration
 

Featured Reviews

Hemanthreddy Vakiti - PeerSpot reviewer
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.
reviewer2761659 - PeerSpot reviewer
Product Engineer at a tech vendor with 10,001+ employees
Has improved data integration speeds and strengthened security through secure authentication
In my experience, the best features Python Connectors offers are easy database connectivity, support for secure authentication, and encryption options. We have used encrypted connections and secure authentication methods, so no plain text credentials have helped us, and we found it effective. We found that Python Connectors is compliance-friendly, very secure, and has no plain text passwords or anything.

Quotes from Members

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

Pros

"In summary, this is a good product, and other than integrating with other tools, I don't face any challenges."
"Deployment was simple and straightforward."
"Informatica PowerCenter is very good for integrating a huge amount of data in a very short duration, such as a minute. It is also very easy to use. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team."
"Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years."
"It provides monitoring and we can therefore be aware of what is happening when we are handling jobs."
"It is very easy to use it to develop mappings and workflows."
"Real time is amazing; if you have AI use cases, you can predict if it's a threat or if it's a positive or negative transaction."
"It is an excellent ETL tool."
"Since we started to use Python Connectors, we found it very reliable, and there are many measurable benefits of this."
 

Cons

"I would like to see it be able to import data from NoSQL."
"The performance of Informatica PowerCenter could improve."
"Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design."
"Its maintenance is expensive."
"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."
"They should release new versions for the solution's on-premises setup."
"Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic."
"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."
"Python Connectors might get a little less costly, making it a common tool rather than being an expensive or fancy tool."
 

Pricing and Cost Advice

"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."
"We have a site license, but we do pay by the division."
"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."
"We are using an annual license for Informatica PowerCenter."
"Licensing costs are excessive and pose an obstacle to someone who lacks familiarity with the solution and wishes to have a proper understanding of it."
"I rate the solution's pricing a four out of ten. The price is very high, and it doesn't understand the market now."
"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."
"The solution is in the middle price range compared to other solutions."
Information not available
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
920,769 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
Financial Services Firm
16%
Manufacturing Company
8%
Outsourcing Company
8%
Construction Company
6%
Financial Services Firm
16%
Manufacturing Company
12%
Comms Service Provider
11%
Construction Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business14
Midsize Enterprise11
Large Enterprise76
No data available
 

Questions from the Community

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...
What needs improvement with Python Connectors?
Python Connectors might get a little less costly, making it a common tool rather than being an expensive or fancy tool. It is much costlier than other products, but considering Python language bein...
What is your primary use case for Python Connectors?
Python Connectors are mainly used to connect between the front-end and back-end of a project. It may seem like an API or a framework. We have used Python Connectors to create an employee dashboard....
What advice do you have for others considering Python Connectors?
Python Connectors is actually very easy and user-friendly and accessible, and the most reliable feature is that it is user-friendly. The person who knows Python from top to end feels a master in it...
 

Also Known As

PowerCenter
No data available
 

Overview

 

Sample Customers

University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
Information Not Available
Find out what your peers are saying about Informatica, Microsoft, Palantir and others in Data Integration. Updated: October 2026.
920,769 professionals have used our research since 2012.