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 solution helps organizations gain flexibility in defining the structure of the data."
"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."
"AWS Glue's best features are scalability and cloud-based features."
"We no longer had to worry much about infrastructure management because AWS Glue is serverless, and Amazon takes care of the underlying infrastructure."
"AWS Glue is a good solution for developers, they have the ability to write code in different languages and other software."
"The most valuable feature of AWS Glue is scalability."
"The solution is serverless so it allows us to transform data while optimizing the cost and performance of Spark jobs."
"We have found it beneficial when moving data from one source to another."
"It works with any multi-databases, so it works with Sybase, SQL Server. Also, the performance is really good and it is easy to use."
"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."
"We use Informatica PowerCenter to transfer the transitional database to and from the data warehouse. This is very efficient as it enables us to quickly find our data reports and the data, so we can build AI models."
"To me, what's most valuable in Informatica PowerCenter is the flexibility in building the integration pipeline. Usually, you need to have a platform to be able to integrate with different technologies, including legacy data such as the mainframe. The platform should also be rich enough to transform the data per your business requirement, with no restrictions. Rich integration and rich transformation capabilities are the two key capabilities in Informatica PowerCenter. The solution also offers ease of use. Another valuable feature of Informatica PowerCenter is the drag-and-drop integration because it's GUI-based, similar to IBM and Oracle."
"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."
"Informatica PowerCenter is a very good ETL tool."
"The ability to scale through partitions helped us to improve the performance."
"The partitioning and optimization to help enhance our development is a very valuable aspect of Informatica PowerCenter."
"We face performance issues when using AWS Glue for data transformation and integration."
"AWS Glue would be improved by making it easier to switch from single to multi-cloud."
"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."
"There should be more connectors for different databases."
"I have encountered challenges with multi-region support."
"It fails to handle massive databases acquired from various sources."
"I haven't looked into Glue in terms of seeking out flaws. I've not come across missing features."
"The interface for AWS Glue could improve, they do not put a lot of details. You can write the code, in PySpark or in Scala, which is a big advantage, it is only easy to use for a developer. It will be difficult for new users to enter the cloud environment."
"I would like to see an improvement in the digital adoption."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"Integrating new tools can be tricky and challenging."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"In the future, I would like to see Informatica PowerCenter integrate a more powerful dashboard."
"There is some room for improvement in terms of pricing."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
AWS Glue is ranked 1st in Cloud Data Integration with 32 reviews while Informatica PowerCenter is ranked 3rd in Data Integration with 30 reviews. AWS Glue is rated 7.8, while Informatica PowerCenter is rated 8.0. The top reviewer of AWS Glue writes "It has a real-time backup feature and records and backs up information every single moment, but its cost is high, and setting it up is complex". 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, SSIS, Informatica Cloud Data Integration, Talend Open Studio and Confluent, whereas Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and Informatica PowerExchange. 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.