Informatica Intelligent Data Management Cloud (IDMC) and AWS Glue compete in the data management and integration category. Informatica IDMC appears to have an edge in versatility due to its multiple interconnected modules and flexibility offered by Informatica Processing Units (IPUs).
Features: Informatica IDMC offers features like data cleansing, data masking, and API management, enhancing its integration capabilities under one umbrella. Users appreciate the flexibility of using IPUs across services. AWS Glue provides robust integration with AWS services, supporting serverless architecture, real-time data processing, and cost-effectiveness in data cataloging. Its easy integration with other AWS services and ability to handle large data sets are highly valued.
Room for Improvement: Informatica IDMC could improve its internal tech support, UI, and scalability, with users seeking more automation and easier configuration similar to on-premise solutions. AWS Glue faces limitations due to its AWS-only ecosystem, language support constraints, and pricing concerns. Enhancing user accessibility and support efficiency is crucial for both, with AWS Glue notably challenged by its AWS-exclusive constraints.
Ease of Deployment and Customer Service: Informatica IDMC is flexible in deploying across on-premises, private, public, and hybrid clouds, appealing to diverse setups. However, customer service is mixed, with varying responsiveness. AWS Glue is adaptable in public and hybrid clouds, praised for prompt user support. Both solutions need improvements in deployment guides and consistency in service.
Pricing and ROI: Informatica IDMC is perceived as high-cost, with scalable pricing based on data volume, accepted by users for its comprehensive features. AWS Glue's pay-as-you-go model can lead to unpredictable expenses but is seen as cost-effective for less intensive workloads. Informatica demands higher licensing and operational costs, while AWS Glue's flexibility may appeal more but can result in high cumulative costs for intensive use.
I advocate using Glue in such cases.
Upgrades occur every four months, and new developments coincide with version updates.
Due to the tool's maturity limitations, solutions are not always simple and often require workarounds.
The response time is pretty good because we have someone in-house, who is an expert from Informatica, in our team who can help us with any sort of queries usually.
For jobs requiring multiple RAM usage, we increase the number of workers accordingly.
It can easily handle data from one terabyte to 100 terabytes or more, scaling nicely with larger datasets.
As a SaaS platform, IDMC is quite scalable and provides complete flexibility.
As a managed service, it reduces management burdens.
Stability is crucial because IDMC holds business-critical data, and it needs to be available all the time for business users.
A more user-friendly and simpler process would help speed up the deployment process.
With AWS, I gather data from multiple sources, clean it up, normalize it, de-duplicate it, and make it presentable.
Learning the latest functionalities is crucial, and while challenging, it is a vital part of staying current and ensuring an efficient ETL process.
I also want to see integration with other Informatica products, such as IICS, to leverage the metadata from EDC.
The tool needs to mature in terms of category-specific attributes or dynamic attributes.
The smallest cost for a project is around €700, while the largest can reach up to €7,000 based on the scale of the usage.
AWS charges based on runtime, which can be quite pricey.
Costing depends on resource usage, and cost optimization may involve redesigning jobs for flexibility.
It ranges from a quarter million to a couple of million a year.
I think the costs are reasonable for the kinds of features that Informatica Intelligent Data Management Cloud (IDMC) has.
For ETL, I feel the performance is excellent. If I create jobs in a standard way, the performance is great, and maintenance is also seamless.
AWS Glue's most valuable features include its transformation capabilities, which provide data quality and shape for processing in ML or AI models.
I think if I'm working with big data, common languages like Python work quite nicely, which is advantageous.
The platform's ability to pull in data from other platforms without the need for an additional integration tool enhances its appeal.
Informatica Intelligent Data Management Cloud (IDMC) can connect to pretty much any application, including Oracle Analytics and Power BI, and it works quite seamlessly.
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:
AWS Glue Benefits
AWS Glue offers a wide range of benefits for its users. These benefits include:
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?
What benefits and ROI should be considered?
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.
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.
