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

Ascend.io vs Informatica PowerCenter comparison

Why PeerSpot?
 

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
45th
Average Rating
8.8
Reviews Sentiment
5.0
Number of Reviews
4
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 November 2026, in the Data Integration category, the mindshare of Ascend.io is 0.4%, up from 0.3% compared to the previous year. The mindshare of Informatica PowerCenter is 3.7%, down from 5.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Mindshare Distribution
ProductMindshare (%)
Informatica PowerCenter3.7%
Ascend.io0.4%
Other95.9%
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.
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.

Quotes from Members

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

Pros

"Ascend.io has positively impacted my organization by making getting data much easier; it handles all those delta changes and other details from repeat calls, making the engineering aspect much easier, which means revisions and transformations could happen more frequently because our time was freed up."
"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."
"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."
"We have seen positive results, particularly in the time spent monitoring and troubleshooting the data pipelines, as Ascend.io has reduced manual investigation effort by approximately 30 to 40% because we can see pipeline dependencies, execution history, and data quality results in one place."
"In general, it is a great tool."
"The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness."
"UI-based ability to create data mapping."
"It is an excellent ETL tool."
"The support is valuable; when we face a production problem, being able to get support is valuable and it brings efficiency."
"Informatica PowerCenter provides multiple transformations in one particular toolset. You don't need to apply any coding."
"Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse."
"The solution has the best user interface and it's the most user-friendly of all data integration tools."
 

Cons

"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."
"Ascend.io can be improved because it is very expensive to scale on top of utilizing Snowflake, which itself is exceptionally expensive, making it very hard for any small to medium-sized business to validate that expense."
"Ascend.io could be improved by making the initial setup and onboarding more straightforward, especially for teams that are new to data engineering platforms."
"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."
"I would like to see it be able to import data from NoSQL."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"The developer tool documentation can be enhanced with a more clear explanation of each utility, accompanied by relevant examples, so that developers are able to create programs with ease."
"The UI is a little outdated."
"Its maintenance is expensive."
"The solution currently requires quite an established data center in place because there is no option for software as a service so the best option to install the platform is on-prem."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"Improvement is needed in terms of some new transformation because API integration and all those things are very critical nowadays."
 

Pricing and Cost Advice

Information not available
"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."
"The solution is in the middle price range compared to other solutions."
"I would rate the pricing for this solution a six out of ten. The exact pricing depends on various products that you have."
"The price of Informatica PowerCenter is expensive, but it does give value."
"The price could be better. It's very expensive. On a scale from one to five, I would give Informatica PowerCenter's price a one."
"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."
"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."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
921,523 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
31%
Comms Service Provider
13%
Government
8%
Financial Services Firm
7%
Financial Services Firm
17%
Manufacturing Company
8%
Outsourcing Company
8%
Construction 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?
My experience with pricing, setup cost, and licensing was that the setup was fine and good, licensing was okay, but the pricing was the most challenging part, especially because Ascend.io used our ...
What needs improvement with Ascend.io?
Ascend.io could be improved by making the initial setup and onboarding more straightforward, especially for teams that are new to data engineering platforms. This could include more guided tutorial...
What is your primary use case for Ascend.io?
My main use case for Ascend.io is testing and validating data pipelines and integrations, where I use it to monitor data flows from source to destination, verify the transformations are working cor...
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 Ascend.io vs. Informatica PowerCenter and other solutions. Updated: November 2026.
921,523 professionals have used our research since 2012.