We performed a comparison between AWS Glue and Informatica PowerExchange based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The solution helps organizations gain flexibility in defining the structure of the data."
"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."
"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 facility to integrate with S3 and the possibility to use Jupyter Notebook inside the pipeline are the most valuable features."
"I like its integration and ability to handle all data-related tasks."
"Data catalog and triggers are the two best features for me. AWS Glue has its own data catalog, which makes it great and really easy to use. Triggers are also really good for scheduling the ETL process."
"The most valuable feature of AWS Glue is scalability."
"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 is connectivity to data sources."
"This product is easy to install and it can be done in a few hours."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"From the product feature or product capability perspective, the aspects around integration, transformation, and standardization are valuable. It's fairly easy to use. It has a GUI-based interface."
"The product’s flexibility is valuable."
"The data transformation is the solution's most valuable feature."
"Provides a significant amount of control over the landscape and overall implementation."
"The agentless RCDC enablement through PowerExchange is a great idea and has worked very well so far."
"On occasion, the solution's dashboard reports that a project failed due to runtime but it actually succeeded."
"Overall, I consider the technical support to be fine, although the response time could be faster in certain cases."
"The product has only a few built-in transformations."
"Glue could perform better. It sometimes takes too long to test a Glue job. Google Cloud Platform offers more Python scripts than AWS."
"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."
"The monitoring is not that good."
"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."
"There should be more connectors for different databases."
"The solution needs better integration with other tools."
"Technical support can be improved with respect to delays in ticket response time."
"V10.2 is very stable, but we are still struggling to make V10.5 stable. We found services that were down, and PowerExchange stopped working."
"I would like to have easier integration with cloud platforms."
"Real-time has not been enhanced that much over the past few years. There has not been as many features added like they did before."
"The product's high costs can be an area of concern where improvements are required."
"They should make it quick and easy for use of citizen data integration or for people or integrators developing at the customer side. They could be development teams within the business team. For them, the product owners can consider making it a little bit more seamless and a little bit more democratized."
"Apache Spark has a machine learning algorithm, an area where Informatica PowerExchange lacks."
AWS Glue is ranked 1st in Cloud Data Integration with 37 reviews while Informatica PowerExchange is ranked 21st in Data Integration with 19 reviews. AWS Glue is rated 7.8, while Informatica PowerExchange is rated 7.8. 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 PowerExchange writes "Handles big data better than competitors". AWS Glue is most compared with AWS Database Migration Service, Informatica PowerCenter, SSIS, Informatica Cloud Data Integration and Talend Open Studio, whereas Informatica PowerExchange is most compared with Informatica PowerCenter, Oracle GoldenGate, Azure Data Factory, SSIS and Qlik Replicate. See our AWS Glue vs. Informatica PowerExchange 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.