We performed a comparison between AWS Glue and Informatica PowerCenter based on our users’ reviews in four categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Of the two solutions, users prefer Informatica PowerCenter because AWS Glue only integrates with AWS services.
"The key role for Glue is that it hosts our metadata before rolling out our actual data. This is the major advantage of using this solution and our clients client have been very satisfied with it."
"The solution is serverless so it allows us to transform data while optimizing the cost and performance of Spark jobs."
"It's fairly straightforward as a product; it's not very complicated."
"I like that it's flexible, powerful, and allows you to write your own queries and scripts to get the needed transformations."
"AWS Glue's best features are scalability and cloud-based features."
"Data catalog and triggers are the two best features for me. AWS Glue has its own data catalog, which makes it great and really easy to use. Triggers are also really good for scheduling the ETL process."
"AWS Glue is quite better than other tools, but you have to learn it properly before you start using it."
"The most valuable features currently are glue studio, jobs, and triggers."
"It's very easy to use it to develop mappings and workflows."
"Good product if you are trying implement data quality, data integration, and data management projects."
"We have found the PowerCenter and B2B data transformation most valuable."
"The support is valuable. There are also open-source ETL products, which work very well, but there is no support. When we face a production problem, being able to get support is valuable, and it brings efficiency. With an open-source solution, we can't engage anyone to resolve the problem as quickly as possible."
"Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse."
"The setup is very simple."
"Deployment was simple and straightforward."
"The reliability of the product and the way of orchestration of different services is valuable to us."
"I haven't looked into Glue in terms of seeking out flaws. I've not come across missing features."
"In terms of improvement, the performance of AWS Glue could be faster."
"One area that could be improved is the ETL view. The drag-and-drop interface is not as user-friendly as some other ETL tools."
"It is not clear how the partition discovery would have been affected by more data coming in."
"The solution's visual ETL tool is of no use for actual implementation."
"Glue could perform better. It sometimes takes too long to test a Glue job. Google Cloud Platform offers more Python scripts than AWS."
"The solution could be cheaper. The price of the solution is an area that needs improvement."
"It fails to handle massive databases acquired from various sources."
"The performance of Informatica PowerCenter could improve."
"PowerCenter could integrate better with cloud applications. We had to do a lot of configuration work using API integrations to connect with cloud applications. Informatica Cloud Data Integration has a generic connector that you can use directly, so it's much easier."
"Informatica are very rigid when it comes to cloud migrations which discourages customers in moving their solution to the cloud."
"It should be more cloud-centric than on-prem-centric."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"This product is going to decommission in the next couple of years."
"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."
"Integration with Artificial Intelligence would benefit this solution."
AWS Glue is ranked 1st in Cloud Data Integration with 37 reviews while Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews. AWS Glue is rated 7.8, while Informatica PowerCenter is rated 8.0. The top reviewer of AWS Glue writes "Provides serverless mechanism, easy data transformation and automated infrastructure management". On the other hand, the top reviewer of Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". AWS Glue is most compared with AWS Database Migration Service, Informatica Cloud Data Integration, SSIS, Talend Open Studio and Oracle Integration Cloud Service, whereas Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and Oracle Data Integrator (ODI). See our AWS Glue vs. Informatica PowerCenter report.
See our list of best Cloud Data Integration vendors.
We monitor all Cloud Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.