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.
"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."
"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."
"It is a stable and scalable solution."
"It's fairly straightforward as a product; it's not very complicated."
"I like its integration and ability to handle all data-related tasks."
"The solution is highly user-friendly, and its features are easy to use. The new addition of AWS Glue Data Catalog is also very beneficial, making the tool even more helpful for its users."
"The solution integrates well with other AWS products or services."
"The number of docs has been reduced drastically, which is very good."
"Enterprise-scale ETL solution that's very stable and is easy to scale. It integrates and connects with multiple new systems, both structured and semi-structured."
"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."
"Good product if you are trying implement data quality, data integration, and data management projects."
"Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution."
"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."
"It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"If the systems get migrated or upgraded, the amount of resources required are very minimal. We can change the connections and establish a new connection. It's very helpful."
"It is not clear how the partition discovery would have been affected by more data coming in."
"While working on AWS Glue, I could not find any training material for it."
"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."
"The setup and installation is a bit complex without advanced knowledge or training."
"The product has only a few built-in transformations."
"In terms of improvement, the performance of AWS Glue could be faster."
"The solution's visual ETL tool is of no use for actual implementation."
"I haven't looked into Glue in terms of seeking out flaws. I've not come across missing features."
"The documentation could be improved."
"I would like to see it be able to import data from NoSQL."
"Its interface can be modernized. It is an old product. I have been working with it for 14 years, and it still looks the same. It hasn't been modernized much. It also needs to handle more modern formats, such as JSON files. It works with the old text files and databases, but it does not always work with the newer, modern stuff. You need to make your own programs to support that kind of stuff. Support is also a kind of difficult with Informatica. They don't do direct support and rely on using their distributors around the globe for support, which means that you kind of have to go through this layer of different companies before you get help."
"The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement."
"The pricing could be improved."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"Integrating new tools can be tricky and challenging."
"Informatica are very rigid when it comes to cloud migrations which discourages customers in moving their solution to the cloud."
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, SSIS, Informatica Cloud Data Integration, 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.