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

Ascend.io vs Informatica PowerCenter 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

Ascend.io
Ranking in Data Integration
42nd
Average Rating
9.0
Reviews Sentiment
4.9
Number of Reviews
2
Ranking in other categories
No ranking in other categories
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)
 

Mindshare comparison

As of August 2026, in the Data Integration category, the mindshare of Ascend.io is 0.4%, up from 0.1% compared to the previous year. The mindshare of Informatica PowerCenter is 3.4%, down from 7.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Mindshare Distribution
ProductMindshare (%)
Informatica PowerCenter3.4%
Ascend.io0.4%
Other96.2%
Data Integration
 

Featured Reviews

reviewer2784462 - PeerSpot reviewer
Software Engineer at a tech vendor with 10,001+ employees
Automated data pipelines have transformed complex workloads and now deliver faster, reliable insight
The standout feature is the Data Awareness Engine, in my opinion the intelligent control plane. Unlike traditional orchestrators that run tasks based on schedules or external events, Ascend.io understands the state of the data. If a source file changes or transformation logic is updated, the engine automatically identifies only the impacted data partitions and recalculates exclusively those. This eliminated the need to write complex logic for partial reloads and ensures that downstream data is always consistent with the latest version of the code. Ascend.io impacted my organization positively because it helped me solve my problem by solving our operational maintenance crisis. Previously, every time a Spark job failed, we had to manually intervene to clean up partial data and restart the pipeline. With Ascend.io, infrastructure management and checkpointing are fully automated. It drastically reduced our technical debt, allowing our data engineers to focus on business logic rather than cluster management or writing boilerplate ingestion code. Code reduction eliminated 60% to 70% of custom Spark code. Operational cost saw a 30% reduction in man-hours dedicated to pipeline maintenance and incident management. The meantime to recovery reduced from hours to minutes due to automatic failure tracking. With Ascend.io, you write what you want, not how to do it. It is a declarative approach and reduces code by 80%. This is very important to me. A good feature is the integrated lineage because an instant visualization of data flow across all components is very useful.
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.

Quotes from Members

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

Pros

"One of the best features Ascend.io offers is Agentic analytics, which applies Agentic AI within systems to verify and operationalize data products, and it is live, allowing you to build systems and visualizations that turn data and different data sets into production-ready workflows."
"With Ascend.io, infrastructure management and checkpointing are fully automated, drastically reducing our technical debt, allowing our data engineers to focus on business logic rather than cluster management or writing boilerplate ingestion code."
"The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness."
"The performance and design of Informatica have been very valuable, and I find the performance faster than, say, Oracle Data Integrator or DataStage."
"My overall experience with Informatica PowerCenter is positive."
"The most valuable features are the dynamic reading of the file metadata profile, and the ability to define business rules that are used to verify and validate the uploaded files."
"The greatest feature is that it is very easy to have someone come in and jump right in. It is one of the nicest tools in terms of getting a person acquainted quickly."
"Once you figure it out, it is a powerful and simple ETL tool. Its stability has been very satisfactory."
"Informatica PowerCenter is worth the money to use for its benefits."
"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."
 

Cons

"Ascend.io can be improved regarding the initial learning curve because for those used to writing pure Spark code, a mindset shift is required to trust the tool's automation."
"Ascend.io can be improved by perhaps expanding its reach beyond small industries to get into big industries or large investment companies and big financial industries, revolutionizing how data plays certain roles in leadership and decision-making."
"It would be better if I could do all the work within a single window. If I'm working on any mapping and if I have to switch to sessions, I have to open a new window altogether. If I have to get into workflows, I have to open a new window. It was also very expensive. In the next release, I would like it to be more user-friendly."
"They should release new versions for the solution's on-premises setup."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"It would be better if I could do all the work within a single window. It was also very expensive."
"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."
"The UI is a little outdated."
"Its interface can be modernized. It is an old product. I have been working with it for 14 years, and it still looks the same. It hasn't been modernized much. It also needs to handle more modern formats, such as JSON files. It works with the old text files and databases, but it does not always work with the newer, modern stuff. You need to make your own programs to support that kind of stuff. Support is also a kind of difficult with Informatica. They don't do direct support and rely on using their distributors around the globe for support, which means that you kind of have to go through this layer of different companies before you get help."
"The solution does not scale."
 

Pricing and Cost Advice

Information not available
"The price of this solution is high."
"Our client has purchased the license, and we are using 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."
"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 are using an annual license for Informatica PowerCenter."
"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."
"The price is mostly reasonable."
"We have a site license, but we do pay by the division."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
910,479 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
Construction Company
37%
Government
9%
Financial Services Firm
7%
Manufacturing Company
7%
Financial Services Firm
15%
Manufacturing Company
8%
Government
6%
Insurance Company
6%
 

Company Size

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

Questions from the Community

What is your experience regarding pricing and costs for Ascend.io?
Our experience has been very positive due to the AWS Marketplace integration. The customer shared this feedback with us. Regarding setup cost, they were remarkably low because Ascend.io is a SaaS p...
What needs improvement with Ascend.io?
Ascend.io can be improved regarding the initial learning curve because for those used to writing pure Spark code, a mindset shift is required to trust the tool's automation. Another area for improv...
What is your primary use case for Ascend.io?
My main use case for Ascend.io is that we have been working with an e-commerce client that was struggling to manage the complexity of their ETL pipelines. The team was spending 80% of their time wr...
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...
 

Also Known As

No data available
PowerCenter
 

Overview

 

Sample Customers

Information Not Available
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: August 2026.
910,479 professionals have used our research since 2012.