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 ability to scale through partitions helped us to improve the performance."
"The product's initial setup phase is very easy."
"Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years."
"It's a very powerful tool you can use to load data, get data, do the drawing between the tables, and put into the packet in a very fast way."
"The most valuable features of Informatica PowerCenter are the ease of use, and development, and is simple to find resources."
"The most valuable features are the metadata repository and the data warehouse application console."
"The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand."
"Once you figure it out, it is a powerful and simple ETL tool. Its stability has been very satisfactory."
"Customer service is excellent, and I would rate it between eight point five to nine out of ten."
"The most prominent feature of Upsolver is its function as an ETL tool, allowing data to be moved across platforms and different data technologies."
"It was easy to use and set up, with a nearly no-code interface that relied mostly on drag-and-drop functionality."
 

Cons

"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"PowerCenter has three clients. I wish they would consolidate everything into one GUI, not three. Also, we had a persistent issue with the Informatica Developer tool but it was solved when we migrated to the newest one."
"The solution could have better documentation on basic steps or blocks that specify what to do."
"I would like to see it be able to import data from NoSQL."
"There is some room for improvement in terms of pricing."
"We had stability issues, mostly with JVM size."
"Its licensing can be improved. It should be features-wise and not bundle-wise. A bundle will definitely be costly. In addition, we might use one or two features. That's why the pricing model should be based on the features. The model should be flexible enough based on the features. Their support should also be more responsive to premium customers."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"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

"I consider this to be an expensive product."
"I would rate the pricing for this solution a six out of ten. The exact pricing depends on various products that you have."
"We are satisfied with the pricing."
"According to what I've heard and read on various blogs, it's quite expensive when compared to similar competitive products."
"It's much more expensive, almost three times more expensive than most other solutions."
"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 found the pricing very cost-effective. The licensing is CPU and data source-based."
"The price is mostly reasonable."
"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.
832,765 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
7%
Government
7%
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.
832,765 professionals have used our research since 2012.