Try our new research platform with insights from 80,000+ expert users

Informatica PowerCenter vs Upsolver 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

Informatica PowerCenter
Ranking in Data Integration
2nd
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
80
Ranking in other categories
Data Visualization (8th)
Upsolver
Ranking in Data Integration
37th
Average Rating
8.6
Reviews Sentiment
7.6
Number of Reviews
2
Ranking in other categories
Streaming Analytics (18th)
 

Mindshare comparison

As of February 2025, in the Data Integration category, the mindshare of Informatica PowerCenter is 10.3%, down from 12.1% compared to the previous year. The mindshare of Upsolver is 0.1%, down from 0.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

Lars Borchers - PeerSpot reviewer
A stable and reliable product that provides a variety of features for data integration
The solution is not for newcomers. It has an old touch. The solution must improve the integration with new services. It was part of the program at Informatica when they moved to their cloud platform. It is integrated. However, from an on-premise perspective, we need to buy licenses for PowerExchange. If we want a native driver to access a special service, we need to extend our license to those services. It is expensive. I don't like that it's not all included in the solution.
Snehasish Das - PeerSpot reviewer
Allows for data to be moved across platforms and different data technologies
The most prominent feature of Upsolver is its function as an ETL tool, allowing data to be moved across platforms and different data technologies. Upsolver does this in a quick time, unlike traditional processes which are time-consuming. Additionally, it offers scalability for large volumes of data, with performance and ease of cloud-native integration.

Quotes from Members

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

Pros

"The technical support for Informatica PowerCenter is good."
"We can scale the product."
"It has helped us monetize."
"The interface is very clean and clear."
"Good interface, reasonable documentation."
"It has very good monitoring and process monitoring."
"The number of docs has been reduced drastically, which is very good."
"Informatica PowerCenter is a very good ETL tool."
"The most prominent feature of Upsolver is its function as an ETL tool, allowing data to be moved across platforms and different data technologies."
"Customer service is excellent, and I would rate it between eight point five to nine out of ten."
"It was easy to use and set up, with a nearly no-code interface that relied mostly on drag-and-drop functionality."
 

Cons

"Some of the conversions are done inside the product. We use work tables that are created by the engine itself, but the names of the work tables are very long, and they don't have any meaning, which makes it a bit difficult to understand and follow exactly what is happening inside."
"In terms of performance improvement and tuning, there should be a bit more guidance and documentation."
"This product is going to decommission in the next couple of years."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"Requires an established data center because there is no option for software as a service."
"Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration."
"Compared to solutions offering similar functionalities, Informatica PowerCenter is not very flexible regarding customized integrations."
"The solution can improve by providing more connectivity by having native ODBC or JDBC connections available. It will be easier and more people could start using it."
"There is room for improvement in query tuning."
"On the stability side, I would rate it seven out of ten. Using multiple cloud providers and data engineering technologies creates complexity, and managing different plugins is not always easy, but they are working on it."
"Upsolver excels in ETL and data aggregation, while ThoughtSpot is strong in natural language processing for querying datasets. Combining these tools can be very effective: Upsolver handles aggregation and ETL, and ThoughtSpot allows for natural language queries. There’s potential for highlighting these integrations in the future."
 

Pricing and Cost Advice

"It's much more expensive, almost three times more expensive than most other solutions."
"The pricing is a little expensive, but in the same range as IBM and other competitors."
"Our customers pay a licensing fee yearly."
"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."
"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."
"Since the solution's cost is higher, I rate the pricing as a five out of ten."
"The price of this solution is high."
"I would rate the pricing for this solution a six out of ten. The exact pricing depends on various products that you have."
"Upsolver is affordable at approximately $225 per terabyte per year."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
837,501 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
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
18%
Computer Software Company
12%
Manufacturing Company
8%
Insurance Company
6%
No data available
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
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 is your experience regarding pricing and costs for Upsolver?
Upsolver is affordable at approximately $225 per terabyte per year. Compared to what I know from others, it's cheaper than many other products.
What needs improvement with Upsolver?
There is room for improvement in query tuning. Upsolver could do a more in-depth analysis in employing machine power, such as CPU and memory, to enhance query performance. Furthermore, allocating C...
What is your primary use case for Upsolver?
I am working as a consultant and currently have my own consultancy services. I provide services to companies that are data-heavy and looking for data engineering solutions for their business needs....
 

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 PowerCenter vs. Upsolver and other solutions. Updated: January 2025.
837,501 professionals have used our research since 2012.