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.
"I appreciate AWS Glue for its cost-effectiveness."
"The solution is stable and reliable."
"AWS Glue is a good solution for developers, they have the ability to write code in different languages and other software."
"Our entire use case was very easily handled or solved using this solution."
"The most valuable feature of AWS Glue is its ease of use and good documentation. Additionally, we can do all the transformations that we need."
"It is AWS-integrated. There is end-to-end integration with the other AWS services. It is also user-friendly."
"I like that it's flexible, powerful, and allows you to write your own queries and scripts to get the needed transformations."
"The most valuable features currently are glue studio, jobs, and triggers."
"The interface is very clean and clear."
"It reduces a lot of legacy coding."
"The setup is very simple."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"I found the map links, work links, and workflows valuable. They are important features."
"It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"Good product if you are trying implement data quality, data integration, and data management projects."
"It has good standard features for ETL development."
"In terms of performance, if they can further optimize the execution time for serverless jobs, it would be a welcome improvement."
"The technical support for this solution could be improved. In future, we would like to connect more services like Athena or Kinesis to help control more loads of data."
"In terms of improvement, the performance of AWS Glue could be faster."
"If there's a cluster-related configuration, we have to make worker notes, which is quite a headache when processing a large amount of data."
"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."
"On occasion, the solution's dashboard reports that a project failed due to runtime but it actually succeeded."
"There is a learning curve to this tool."
"The solution could be cheaper. The price of the solution is an area that needs improvement."
"As a connector to big data, it is not well developed. We've had problems connecting Informatica with Hadoop. The functionality to connect Informatica with Hadoop, for me it's not good."
"Informatica PowerCenter could improve by having a single interface because half of the system is still in the legacy interface and many other elements are moved to the developer client. It would be good if there was a single interface for the end user and developers."
"Informatica, in my opinion, is very rigid and not very flexible, whereas platforms like Alteryx or Matillion are very flexible and agile."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it."
"The price of the product is an area of concern where improvements are required, considering the fact that the present licensing charges of the tool are expensive."
"Now they are migrating to a new version, and they have something that is called Informatica Developer. Previously, they just had PowerCenter. Now, when they move everything to Informatica Developer it's not as good or stable like it was when it was PowerCenter, though it has some nice features. This Developer tool could be better."
"We had stability issues, mostly with JVM size."
"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."
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.
