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

AWS AppSync 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

AWS AppSync
Average Rating
8.0
Reviews Sentiment
6.6
Number of Reviews
2
Ranking in other categories
Cloud Data Integration (25th)
Informatica PowerCenter
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
85
Ranking in other categories
Data Integration (4th), Data Visualization (13th)
 

Featured Reviews

Akil Saji - PeerSpot reviewer
AWS Cloud Developer at Mobil80 Solutions and Services Pvt. Ltd.
Ease of creating APIs with ongoing updates needed for automation
AWS has made it easy for developers like me to create and manage GraphQL APIs. The ease of use is a main advantage, allowing even beginners to start from scratch and learn through AppSync. Before AWS, developing and managing APIs was quite complex. AWS provided AppSync, which assists developers and startup founders. Startups blooming everywhere benefit from this service, welcoming those who lack prior knowledge. When working on AWS, I notice that Amazon regularly implements new features. For instance, with the Lambda service, AWS is transitioning from an old editor to a new one. Similarly, AppSync frequently introduces updates and changes. This trend is making the user interface more accessible, even for individuals without a technical background. Additionally, the cost is attractive, as AWS operates on a pay-as-you-go basis. These factors make AppSync both easy to use and cost-effective.
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

"AWS has made it easy for developers like me to create and manage GraphQL APIs."
"Support for multiple data sources and formats is a fantastic feature."
"The most valuable features of Informatica PowerCenter are the ease of use, and development, and is simple to find resources."
"Technical support is great. It's one of the reasons we really like them. When you compare support from IBM and support from Informatica, Informatica is much better."
"Informatica is scalable, it's perfect."
"It has a Data Catalog that uses the Model repository."
"The solution is stable."
"This is the best tool that we have."
"Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution."
"The setup is straightforward."
 

Cons

"Moving to other clouds is impossible without significantly rearchitecting your applications."
"In AppSync, assigning roles and permissions to APIs is necessary for accessing other AWS services. Automating this task when creating APIs would be beneficial."
"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."
"This solution needs the functionality to do batch processing of data. It also lacks connectivity to NoSQL, unstructured data sources."
"It is very difficult to learn."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"I would like to see the inclusion of a tool that allows you to report performance metrics."
"What needs improvement in Informatica PowerCenter is the cloud experience because, nowadays, other companies, such as AWS, Azure, and Google, have more experience in the cloud. The pricing for Informatica PowerCenter on the cloud is also very expensive for customers, so some customers prefer open-source tools or lower-priced tools, such as Azure. From my point of view, Informatica must work on the pricing policy and review the policy on the cloud for Informatica PowerCenter or propose more tools with lower pricing. Clients want the automatic integration of Informatica PowerCenter with other tools. Currently, the integration process is manual, and you have to add other tools to facilitate the integration, especially with the DevOps methodology. You need scripts and tools for the integration, and you'll need to use other integration tools if you want automatic deployment for Informatica PowerCenter, so this is another area for improvement in the solution. What I'd like to see in the next release of the solution is for the integration with APIs to be simpler, because currently, the API integration feature of Informatica PowerCenter is very difficult. It's not intuitive. You have to facilitate API integration and the real-time streaming of messages in Kafka, for example, so that should be improved."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"This product is going to decommission in the next couple of years."
 

Pricing and Cost Advice

"Licensing fees are paid on a monthly basis, and it is a pay-as-you-go model."
"Since the solution's cost is higher, I rate the pricing as a five out of ten."
"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."
"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."
"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."
"It's much more expensive, almost three times more expensive than most other solutions."
"Cost could be improved."
"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 using an annual license for Informatica PowerCenter."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
915,341 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
Comms Service Provider
21%
Manufacturing Company
17%
Healthcare Company
12%
Outsourcing Company
5%
Financial Services Firm
15%
Manufacturing Company
9%
Outsourcing Company
7%
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 AWS AppSync?
My experience with pricing, setup cost, and licensing was good and easy. About the pricing and setup cost, there is no major setup cost required for AWS AppSync, which is a really great thing becau...
What needs improvement with AWS AppSync?
The current features of AWS AppSync are enough for any developer, but it has some areas for improvement. AWS AppSync can provide first-class support for SQL RDS since writing SQL via VTL is clunky ...
What is your primary use case for AWS AppSync?
My main use case for AWS AppSync is to deploy the application by connecting my frontend and backend application. AWS AppSync serves as a GraphQL API Gateway that sits between my frontend and backen...
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

AppSync
PowerCenter
 

Overview

 

Sample Customers

ACBL, Puresec, IDT, ASU, Public Good, cookpad, ALDO, ticketmaster
University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
Find out what your peers are saying about Amazon Web Services (AWS), Informatica, Palantir and others in Cloud Data Integration. Updated: September 2026.
915,341 professionals have used our research since 2012.