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

Informatica PowerCenter vs Python Connectors comparison

 

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
35th
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 August 2026, in the Data Integration category, the mindshare of Informatica PowerCenter is 3.4%, down from 7.8% compared to the previous year. The mindshare of Python Connectors is 0.6%, up from 0.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Mindshare Distribution
ProductMindshare (%)
Informatica PowerCenter3.4%
Python Connectors0.6%
Other96.0%
Data Integration
 

Featured Reviews

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

"It works with any multi-databases, so it works with Sybase, SQL Server. Also, the performance is really good and it is easy to use."
"Once you have learned Informatica, it is very easy to use."
"The number of docs has been reduced drastically, which is very good."
"I found the map links, work links, and workflows valuable. They are important features."
"Good interface, reasonable documentation."
"The ability to scale through partitions helped us to improve the performance."
"Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology."
"The setup is very simple."
"Since we started to use Python Connectors, we found it very reliable, and there are many measurable benefits of this."
 

Cons

"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"I would like to see the inclusion of a tool that allows you to report performance metrics."
"It would be nice to have all tools in one place. CDC needs more effort, as it's only easy to develop if you are familiar with Linux."
"I would like to see an improvement in the digital adoption. It would be nice if they could be cheaper, because the training is very expensive as they do everything online."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"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."
"Now they are migrating to a new version, and they have something that is called Informatica Developer. Previously, they just had PowerCenter. Now, when they move everything to Informatica Developer it's not as good or stable like it was when it was PowerCenter, though it has some nice features. This Developer tool could be better."
"With all these no code/low code platforms, Informatica still forces us to use the ANSI format of SQL for joins, especially left outer join."
"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

"The solution is in the middle price range compared to other solutions."
"Its maintenance is expensive."
"We have found the pricing very cost-effective. The licensing is CPU and data source-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."
"I rate the solution's pricing a four out of ten. The price is very high, and it doesn't understand the market now."
"The licensing fees are paid on a yearly basis."
"The pricing for Informatica PowerCenter is expensive. Some clients have simple needs and only want to integrate and store data. Some clients have small needs, while some clients have bigger needs and focus more on performance and time. The licensing cost for Informatica PowerCenter isn't good. In my project, if I remember correctly, the company pays €20,000 per year for the Informatica PowerCenter license. I'm not aware of additional costs that you need to pay for some features of the solution. On a scale of one to five, I'm rating its price a three."
"Our client has purchased the license, and we are using it."
Information not available
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
908,800 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
15%
Manufacturing Company
8%
Government
7%
Insurance Company
6%
Financial Services Firm
18%
Manufacturing Company
9%
Construction Company
9%
Healthcare 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: July 2026.
908,800 professionals have used our research since 2012.