We performed a comparison between AWS Glue and Informatica Intelligent Cloud Services based on real PeerSpot user reviews.
Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration."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."
"The most valuable feature of AWS Glue is scalability."
"The most valuable features currently are glue studio, jobs, and triggers."
"We no longer had to worry much about infrastructure management because AWS Glue is serverless, and Amazon takes care of the underlying infrastructure."
"The solution helps organizations gain flexibility in defining the structure of the data."
"The facility to integrate with S3 and the possibility to use Jupyter Notebook inside the pipeline are the most valuable features."
"It is a stable and scalable solution."
"Our entire use case was very easily handled or solved using this solution."
"This solution allows you to easily access and make use of information that you have in your on-premises environment."
"The data integration and synchronization features in IICS improve the data handling processes."
"The feature I found most valuable in Informatica Intelligent Cloud Services is the mapping. You just drag, and it maps the data. Mapping is very easy, and it's no code. When you migrate data or when the data interaction happens at the source and destination, the challenge is that you'll get different formats. The validation has to be done in the middleware, and the transformation should happen. In Informatica Intelligent Cloud Services, it's very easy to do data validation and transformation compared to any other tool."
"I rate the solution's scalability a ten out of ten."
"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."
"While working on AWS Glue, I could not find any training material for it."
"Glue could perform better. It sometimes takes too long to test a Glue job. Google Cloud Platform offers more Python scripts than AWS."
"We face performance issues when using AWS Glue for data transformation and integration."
"I would like to see a more robust interface on the no-code side. This would be nice to be able to split cells."
"The monitoring is not that good."
"The solution’s stability could be improved."
"The solution should offer features for streaming data in addition to batching data."
"Synchronicity is an area for improvement in Informatica Intelligent Cloud Services. For example, when you want real-time or immediate response from the solution when multiple technologies are involved, the integration with Informatica Intelligent Cloud isn't seamless, whether it's the MQ, JMS, or BES service, so the connectivity should be improved a bit. The data governance is good, but what's lacking is a demo. For example, if there's a new feature in Informatica Intelligent Cloud Services, the documentation for that new feature is limited, so if Informatica could give a more complete documentation and more demos, that would be better for the users. Right now, there isn't any issue with any of the features of the solution. It's the new feature awareness or user training, and improved connectivity that I'd like to see in the next version of Informatica Intelligent Cloud Services."
"There's definitely room for improvement in terms of user-friendliness. One example is that you can't search for jobs directly by file name. You can only search by job name. So, if you want to find a job that works with a specific file, you have to go through each job individually to find the right one. So, I'd like to see a faster search, one where I can search directly by file name."
"The product's pricing is definitely an area where a bit of improvement is needed."
"This service could be more cost-effective."
More Informatica Intelligent Cloud Services Pricing and Cost Advice →
AWS Glue is ranked 1st in Cloud Data Integration with 37 reviews while Informatica Intelligent Cloud Services is ranked 14th in Integration Platform as a Service (iPaaS) with 4 reviews. AWS Glue is rated 7.8, while Informatica Intelligent Cloud Services is rated 8.2. 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 Intelligent Cloud Services writes "Good tool, especially if you're using cloud services and an S3 bucket". AWS Glue is most compared with AWS Database Migration Service, Informatica PowerCenter, SSIS, Informatica Cloud Data Integration and Talend Open Studio, whereas Informatica Intelligent Cloud Services is most compared with Microsoft Azure Logic Apps.
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.
They both have many features that you will need.
AWS Glue will be easier to maintain and integrate because it is a platform on AWS. Informatica is cloud-agnostic.
For a large company, you are better off keeping your options open to move to another cloud.
Both of these tools do not achieve Cloud Integration entirety.
Have you looked at CData Connect Cloud? It provides real-time connectivity to 280+ data sources and is a true SaaS offering for Cloud integration.
@Sandeep Suram, can you please elaborate your use case? What exactly are your requirements?