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."
"I like its integration and ability to handle all data-related tasks."
"AWS Glue's most valuable features are the data catalog, including crawlers and tables, and Glue Studio, which means you don't have to use custom code."
"The solution integrates well with other AWS products or services."
"The solution's technical support is good. Whenever we raise a use case where we face an issue in our company, we get a response from the solution's technical team."
"AWS Glue is fast and managed by AWS. Hence, you don't have to worry about capacity and the performance of Glue jobs. It has integrations with other data stores of AWS. The product offers metadata management, logging, and ETL processing capabilities. It comes with a powerful feature, Glue Studio, which helps to do queries interactively within the community. It is a managed service and very secure. Another popular and mature service is S3."
"The product has a valuable feature for data catalog."
"What I like best about AWS Glue is its real-time data backup feature. Last week, there was a production push, and what used to take almost ten days to send out around fifty-six thousand emails now takes only two hours."
"The technical support for Informatica PowerCenter is good."
"What I like the most is that we have to deal with less while writing the queries."
"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."
"In the end, you have structured, proper data for use in an integrated BI solution."
"We can scale the product."
"We have found the PowerCenter and B2B data transformation most valuable."
"The partitioning and optimization to help enhance our development is a very valuable aspect of Informatica PowerCenter."
"What I like most about Informatica PowerCenter is that it's the best tool in the market for data integration. Currently, I work in L'Oréal, where a new system from SAP is used. Informatica PowerCenter integration with SAP is very, very fast and very, very simple, so you have the server flow from SAP, and through Informatica PowerCenter, you can ingest the data and make that data available for the business more quickly."
"Currently, it supports only two languages in the background: Python and Scala. From our customization point of view, it would be helpful if it can also support Java in the background."
"The start-up time is really high right now. For instance, when you start up a new job, you have to wait for five or eight minutes before it starts. If the start-up time is reduced to one or two minutes, it will be great. It will be better to have a direct linkage to Redshift in AWS. If we can use data catalogs from Redshift, it will be so easy to create some data catalogs. Currently, we can only use data catalogs from S3."
"We face performance issues when using AWS Glue for data transformation and integration."
"I haven't looked into Glue in terms of seeking out flaws. I've not come across missing features."
"The setup and installation is a bit complex without advanced knowledge or training."
"AWS Glue would be improved by making it easier to switch from single to multi-cloud."
"The solution should offer features for streaming data in addition to batching data."
"On occasion, the solution's dashboard reports that a project failed due to runtime but it actually succeeded."
"They should release new versions for the solution's on-premises setup."
"Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration."
"I would like to see improvements made to the custom transformations. It should be more open for users that want to write their own code and use cases."
"The solution can improve by providing more connectivity by having native ODBC or JDBC connections available. It will be easier and more people could start using it."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"I found it is kind of weird that not all of the mapping changes are treated as true changes."
"The UI is outdated and old-fashioned, at least in our current version. Also, we have experienced some stability issues with the Workflow Monitor application."
"The solution could have better documentation on basic steps or blocks that specify what to do."
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.