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 also like that you can add custom libraries like JAR files and use them. So, the ability to use a fast processing engine and embed basic jobs easily are significant advantages."
"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."
"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 most valuable feature of AWS Glue is scalability."
"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."
"One of the best features of the solution is its ability to easily integrate with other AWS services."
"Its user interface is quite good. You just need to choose some options to create a job in AWS Glue. The code-generation feature is also useful. If you don't want to customize it and simply want to read a file and store the data in the database, it can generate the code for you."
"It is an excellent ETL tool."
"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."
"Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years."
"The partitioning and optimization to help enhance our development is a very valuable aspect of Informatica PowerCenter."
"Good product if you are trying implement data quality, data integration, and data management projects."
"The most valuable features of Informatica PowerCenter are the ease of use, and development, and is simple to find resources."
"It has good standard features for ETL development."
"It provides monitoring and we can therefore be aware of what is happening when we are handling jobs."
"It would be better if it were more user-friendly. The interesting thing we found is that it was a little strange at the beginning. The way Glue works is not very straightforward. After trying different things, for example, we used just the console to create jobs. Then we realized that things were not working as expected. After researching and learning more, we realized that even though the console creates the script for the ETL processes, you need to modify or write your own script in Spark to do everything you want it to do. For example, we are pulling data from our source database and our application database, which is in Aurora. From there, we are doing the ETL to transform the data and write the results into Redshift. But what was surprising is that it's almost like whatever you want to do, you can do it with Glue because you have the option to put together your own script. Even though there are many functionalities and many connections, you have the opportunity to write your own queries to do whatever transformations you need to do. It's a little deceiving that some options are supposed to work in a certain way when you set them up in the console, but then they are not exactly working the right way or not as expected. It would be better if they provided more examples and more documentation on options."
"It fails to handle massive databases acquired from various sources."
"The price of the solution could improve."
"Only people who can code, either in Java or Python, can use the product freely. Those who don't know Java or Python might find using AWS Glue difficult."
"The mapping area and the use of the data catalog from Glue could be better."
"Cost-wise, AWS Glue is expensive, so that's an area for improvement. The process for setting up the solution was also complex, which is another area for improvement."
"We face performance issues when using AWS Glue for data transformation and integration."
"There should be more connectors for different databases."
"If we could have the option of performance improvement within Informatica, and if it could have more features, that would be ideal."
"There is some room for improvement in terms of pricing."
"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."
"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."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"The reputation of Informatica is that it is expensive."
"The licensing is difficult."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
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 Confluent, 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.