AWS Glue vs Informatica Intelligent Data Management Cloud (IDMC) comparison

AWS Glue vs. Informatica Intelligent Data Management Cloud (IDMC)

Download the complete report

Helped 831,158 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

AWS Glue

Ranking in Cloud Data Integration

1st

Average Rating

7.8

Reviews Sentiment

7.0

Number of Reviews

Ranking in other categories

No ranking in other categories

Informatica Intelligent Dat...

Ranking in Cloud Data Integration

3rd

Average Rating

8.0

Reviews Sentiment

6.8

Number of Reviews

181

Ranking in other categories

Data Integration (3rd), Data Quality (1st), Business Process Management (BPM) (7th), Business-to-Business Middleware (3rd), API Management (7th), Data Governance (2nd), Test Data Management (3rd), Cloud Master Data Management (MDM) Solutions (1st), Data Management Platforms (DMP) (1st), Data Masking (2nd), Metadata Management (1st), Test Data Management Services (2nd), Product Information Management (PIM) (1st), Data Observability (2nd)

Featured Reviews

Muthuvel Sivaraman

AVP at a manufacturing company with 10,001+ employees

Handles a huge volume of data and is serverless, but it can be considered costly by some users

We use Amazon's services to provide technical support for the product. If you want to have support, Oracle and others offer a single support, and other tools have a direct support window. For Amazon, we need to pay 10 percent of my billing amount for the tool to get support services. Whether to raise a support ticket or not is an issue since ten percent is a huge amount. My company ends up using all the options without help from support. It is very difficult for any common man to understand why there is a need to pay ten percent for support. If I find an issue in the product, and I need to get support from AWS to fix it, then I need to pay ten percent of the tool's bill amount to Amazon. AWS is a very tricky tool because everything is evolving nowadays. AWS engineers are getting hired from other places, and even after that, if I am not getting any technical support, then things will be very nasty. There are some good engineers who help users outside the normal support cycle, but it doesn't meet their needs. I rate the technical support a four out of ten.

Read full review

Raj Sethupathi

Data Integration Consultant GCP/AWS at Infogrators Inc

Offers profiling and address standardization but can be complicated

Informatica Data Quality has its data warehouse, primarily using Oracle and some SQL databases. You need a database to host the data. The cleansed version of the data is stored in the data warehouse. It integrates with PowerCenter and other Informatica tools. The integration details can be complex, but a regional setup is involved in this process. Profiling smaller datasets, such as 10,000-50,000 records, worked fine. However, unexpected issues could arise with larger datasets, such as thousands of records or more, especially with tables containing many columns. Handling tables with fifty or more columns can be challenging, even in Excel. A mismatch in data types could cause the entire system to crash. Continual enhancements are being made to address these issues, which can be unique to specific industries like finance and healthcare.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"It's fairly straightforward as a product; it's not very complicated."

"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."

"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."

"I like its integration and ability to handle all data-related tasks."

"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."

"It is AWS-integrated. There is end-to-end integration with the other AWS services. It is also user-friendly."

"The solution is stable and reliable."

"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."

More AWS Glue pros

"The solution is easier to use compared to the other solutions."

"The serverless capability and the packaging application of the solution are valuable."

"It's got a reputation in the industry as one of the best solutions for master data management. So, it's what we see in the Gartner top right quadrant as the best product in that space."

"Informatica Business Process Manager is easy to use and learn."

"It is quite easy to use and flexible."

"The solution allows the complete governance process, starting from the data quality, those definitions, and it can get the data quality in the EDC."

"It is very useful for testing purposes and designing mappings for small projects. If you go for IDQ in the mapping itself, you can see the data. You can then correct it, and test it so easily. It is working fine. It is also stable, scalable, and easy to deploy."

"The most valuable feature is data discovery. This is the most exciting feature for all of the banks."

More Informatica Intelligent Data Management Cloud (IDMC) pros

Cons

"The process of entering environment variables in AWS Glue requires navigating to a different page, which could be streamlined."

"The price of the solution could improve."

"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."

"AWS Glue should be more reliable and faster in processing. Enhancing the speed of data processing would be beneficial."

"There should be more connectors for different databases."

"The solution’s stability could be improved."

"It fails to handle massive databases acquired from various sources."

"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."

More AWS Glue cons

"I would like to see better visuals for business users, such as a dashboard where they can precisely track where problems are."

"Informatica Cloud Data Integration can improve by being more user-friendly. When you're working with the solution a lot of technical knowledge is required. It's not a solution that anyone can use properly, you need knowledge of what's happening at the back end, such as SQL. When you get stuck, you need to look into your logic. For other tools, such as Dell Boomi, anyone can use them."

"Informatica is very expensive."

"The initial setup was not very straightforward. Not complex, but not very simple either."

"Certain applications are not being synced with the ION."

"The tools required to migrate existing mappings and server rules through cloud data quality are not available."

"The scalability is tough."

"The pricing model is problematic."

More Informatica Intelligent Data Management Cloud (IDMC) cons

Pricing and Cost Advice

"AWS Glue follows a pay-as-you-go model, wherein the cost of the data you use will be counted as a monthly bill."

"The solution's pricing is based on DPUs so it is a good idea to optimize use or it can get expensive."

"I rate the product's pricing a five on a scale of one to ten, where one is a high price, and ten is a low price."

"I rate the tool an eight on a scale of one to ten, where one is expensive, and ten is expensive."

"The overall cost of AWS Glue could be better. It cost approximately $1,000 a month. There is paid support available from AWS Glue."

"It is an expensive product. I rate its pricing a nine out of ten."

"I rate the tool's pricing a four out of ten."

"The current cost is around forty to fifty thousand a month."

More AWS Glue pricing and cost advice

"The price is very high and has become a big concern for our customers who require the solution in order for their business to function smoothly."

"Informatica MDM is very expensive. Apart from licensing fees, they have broken down their products into multiple products, and they charge for each and every product. If the data is huge, they charge for the data. At times, we have to use third party services for data cleaning, and they charge for that as well."

"It's an expensive solution."

"It is expensive. That's probably the biggest drawback. The business has heartache paying the license, but that's mainly because they don't realize what value it brings. The key thing about the MDM solution is that it is in the backend, and no one sees what it is actually doing. You don't know it is a problem until it is not there."

"it's expensive, but if you're looking for a stable solution, Informatica MDM is a good one to choose."

"I rate the licensing cost of Informatica MDM a five out of ten."

"Informatica Cloud Data Integration is famously known for its high price. The vendor targets large enterprises, and not medium or small companies. These large companies, and organizations, handle large amounts of data. If you go into any large bank, such as American or Canadian banks, these banks use this solution because it is more reliable, secure, and has more functionality."

"We switched to Informatica PIM because it was cheaper than the Oracle solution. It is cheaper initially, but they will bundle it later. This is what happens in the industry."

More Informatica Intelligent Data Management Cloud (IDMC) pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.

See recommendations

831,158 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

22%

Computer Software Company

13%

Manufacturing Company

Insurance Company

Financial Services Firm

17%

Computer Software Company

12%

Manufacturing Company

10%

Government

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

How do you select the right cloud ETL tool?

AWS Glue and Azure Data factory for ELT best performance cloud services.

How does Talend Open Studio compare with AWS Glue?

We reviewed AWS Glue before choosing Talend Open Studio. AWS Glue is the managed ETL (extract, transform, and load) from Amazon Web Services. AWS Glue enables AWS users to create and manage jobs in...

What are the most common use cases for AWS Glue?

AWS Glue's main use case is for allowing users to discover, prepare, move, and integrate data from multiple sources. The product lets you use this data for analytics, application development, or ma...

How does Azure Data Factory compare with Informatica Cloud Data Integration?

Azure Data Factory is a solid product offering many transformation functions; It has pre-load and post-load transformations, allowing users to apply transformations either in code by using Power Q...

Which Informatica product would you choose - PowerCenter or Cloud Data Integration?

Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a real data governance strategy. Additionally, PowerCenter is able to manage huge...

What are the biggest benefits of using Informatica Cloud Data Integration?

When it comes to cloud data integration, this solution can provide you with multiple benefits, including: Overhead reduction by integrating data on any cloud in various ways Effective integration ...

AWS Database Migration Service vs AWS Glue

Comparisons

Compared 35% of the time

Informatica PowerCenter vs AWS Glue

Compared 5% of the time

SSIS vs AWS Glue

Compared 5% of the time

Talend Open Studio vs AWS Glue

Compared 4% of the time

SnapLogic vs AWS Glue

Compared 4% of the time

More AWS Glue Competitors

Informatica PowerCenter vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 8% of the time

Azure Data Factory vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 7% of the time

Reltio Cloud vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 5% of the time

Microsoft Purview Data Governance vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 4% of the time

SAP Master Data Governance vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 3% of the time

More Informatica Intelligent Data Management Cloud (IDMC) Competitors

Product Reports

AWS Glue

Download AWS Glue product report

Informatica Intelligent Data Management Cloud (IDMC)

Download Informatica Intelligent Data Management Cloud (IDMC) product report

Informatica Intelligent Data Management Cloud (IDMC) report

Also Known As

No data available

ActiveVOS, Active Endpoints, BPM, Address Verification, Persistent Data Masking, Cloud Test Data Management, PIM, , Enterprise Data Catalog, Data Integration Hub, Cloud Data Integration, Data Quality, Cloud API and App Integration

Learn More

Amazon Web Services (AWS)

Informatica

Overview

AWS Glue is a serverless cloud data integration tool that facilitates the discovery, preparation, movement, and integration of data from multiple sources for machine learning (ML), analytics, and application development. The solution includes additional productivity and data ops tooling for running jobs, implementing business workflows, and authoring.

AWS Glue allows users to connect to more than 70 diverse data sources and manage data in a centralized data catalog. The solution facilitates visual creation, running, and monitoring of extract, transform, and load (ETL) pipelines to load data into users' data lakes. This Amazon product seamlessly integrates with other native applications of the brand and allows users to search and query cataloged data using Amazon EMR, Amazon Athena, and Amazon Redshift Spectrum.

The solution also utilizes application programming interface (API) operations to transform users' data, create runtime logs, store job logic, and create notifications for monitoring job runs. The console of AWS Glue connects all of these services into a managed application, facilitating the monitoring and operational processes. The solution also performs provisioning and management of the resources required to run users' workloads in order to minimize manual work time for organizations.

AWS Glue Features

AWS Glue groups its features into four categories - discover, prepare, integrate, and transform. Within those groups are the following features:

Automatic schema discovery: AWS Glue crawlers connect to the organization's source or target data source through a prioritized list of classifiers to determine the schema for users' data. This feature creates metadata in companies' AWS Glue Data Catalog.
Schemas for data stream management: The AWS Glue Schema Registry enables users to validate and control the evolution of streaming data through registered Apache Avro schemas for no additional charge.
Automatic scaling based on workload: This feature dynamically scales resources up and down based on workload. The feature controls job resources, removing them depending on how much the workload can be split up.
FindMatches: This feature is for machine learning-based data deduplication and cleansing, and works by finding records that are imperfect matches of each other to remove useless data copies.
Edit, debug, and test ETL code: This feature helps users who have chosen to interactively develop their ETL code by providing development endpoints for editing, debugging, and testing the code it generates for them.
AWS Glue DataBrew: An interactive, point-and-click visual interface for specialists to clean and normalize data without the need to write any code.
AWS Glue Interactive Sessions: This feature simplifies the development of data integration jobs by enabling data engineers to interactively prepare and explore data.
AWS Glue Studio Job Notebooks: This AWS Glue feature provides serverless notebooks with minimal setup, allowing developers to start working in a timely manner.
Complex ETL pipeline building: This feature allows the product to be invoked on a schedule, on demand, or based on an event, allowing users to start multiple jobs in parallel or specify dependencies to build complex ETL pipelines.
AWS Glue Studio: This AWS Glue feature allows users to visually transform data through a drag-and-drop interface. The product automatically generates the code for ETL processes for users' data.

AWS Glue Benefits

AWS Glue offers a wide range of benefits for its users. These benefits include:

Users of other AWS products can easily onboard with AWS Glue, as it is integrated across a wide range of the company's services.
The solution is serverless, which allows for a lower total cost of ownership.
AWS Glue offers more power for users, as it automates much of the effort in building, maintaining, and running ETL jobs.
The product allows customers to easily discover and search across all their AWS datasets through AWS Glue Data Catalog.
AWS Glue does not require additional payment for managing and enforcing schemas for data streams.
The solution facilitates the authority of scalable ETL jobs for beginners and non-coding experts through a drag-and-drop interface.

Reviews from Real Users

Mustapha A., a cloud data engineer at Jems Groupe, likes AWS Glue because it is a product that is great for serverless data transformations.

Liana I., CEO at Quark Technologies SRL, describes AWS Glue as a highly scalable, reliable, and beneficial pay-as-you-go pricing model.

Informatica Intelligent Data Management Cloud (IDMC) is a robust platform used by banks, financial institutions, and health sector organizations for data management, governance, and compliance.

IDMC provides comprehensive tools for data discovery, profiling, masking, and transformation. It supports Salesforce integration, real-time data streaming, and scalable data management solutions. Health organizations manage national product catalogs while financial entities focus on data protection and regulatory compliance. Its intuitive interface, flexible features, and robust tools make it valuable across sectors, though enhancements in data integration and human workflow are being sought.

What are the most important features?

Data discovery: Facilitates identifying and understanding data sources.
Data profiling: Analyzes old databases for data quality.
Data and platform masking: Ensures data protection.
Salesforce integration: Seamless connectivity with Salesforce.
Mastering data: Centralizing and standardizing data.
UI intuitiveness: User-friendly interface.
Feature map flexibility: Adapts to user needs.
Business glossary creation: Defines business terms.
Data lineage: Tracks data flow and transformations.
Automation: Streamlines data processes.
Enterprise data cataloging: Organizes extensive data assets.
Scalability: Supports expanding data requirements.
Easy setup: Quick deployment process.
Bulk upload: Efficiently handles large data volumes.
Customizable data management: Tailors data solutions.
Real-time data streaming: Manages live data streams.
Integration with Hadoop and NoSQL: Connects with big data platforms.

What benefits and ROI should be considered?

Regulatory compliance: Ensures adherence to regulations.
Data protection: Safeguards sensitive information.
Enhanced data quality: Improves accuracy and reliability.
Centralized data: Consolidates data for better management.
Process automation: Reduces manual tasks and errors.

Banks and financial institutions use IDMC for data masking, transformation, and compliance, while health sector organizations leverage it for national product catalogs. Industry applications focus on automating business processes, centralizing data, and managing data catalogs to meet regulatory demands and ensure data protection.

Sample Customers

bp, Cerner, Expedia, Finra, HESS, intuit, Kellog's, Philips, TIME, workday

The Travel Company, Carbonite

AWS Glue vs. Informatica Intelligent Data Management Cloud (IDMC)