Try our new research platform with insights from 80,000+ expert users

Informatica Data Engineering Streaming vs Informatica Intelligent Data Management Cloud (IDMC) comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Informatica Data Engineerin...
Average Rating
8.0
Number of Reviews
1
Ranking in other categories
Streaming Analytics (16th)
Informatica Intelligent Dat...
Average Rating
8.0
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), Cloud Data Integration (3rd), Data Governance (2nd), Test Data Management (3rd), Cloud Master Data Management (MDM) Solutions (1st), Data Management Platforms (DMP) (2nd), Data Masking (2nd), Metadata Management (1st), Test Data Management Services (4th), Product Information Management (PIM) (1st), Data Observability (2nd)
 

Featured Reviews

DK
May 16, 2024
Helps with real-time data processing and improves decision-making overall
We implement business intelligence solutions, including data warehousing tools, data integration to load data into warehouses, and then creating reports It improves decision-making overall for the company. Informatica is usually the tool for setting up the data, streaming the data into your data…
Raj Sethupathi - PeerSpot reviewer
Jun 13, 2024
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.

Quotes from Members

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

Pros

"It improves the performance."
"The user interface which is very easy to use if we have any problems to solve."
"What I like best about Informatica MDM is its structured, table-based approach. Unlike Reltio, where data is only visible through the UI and cloud-based, the solution allows access to normalized tables. This means I can directly query and see data in each table. For instance, I can easily get all customer details from the customer table. However, for more complex queries, like seeing all customer interactions with the organization, some SQL knowledge is needed to join different tables and retrieve the details."
"Multifeatured and easily scalable data catalog, with good data domain discovery and data profiling features."
"I like that Informatica MDM has robust matching technology. Informatica MDM is also porting the external Java applications for validations. I can consider that a must-have. It is also exposed to Rest API calls, and we can engage in real-time integrations with any third-party systems."
"It has improved our organization because it has made our data more reliable. Data is the most important asset these days, and in order to trust your data, you need these tools to make sure that your data is clean and reliable."
"The tool's most valuable feature is bulk upload. We upload files in CSV or Excel format."
"It's a stable product without any bugs or glitches."
"I like EDC's self-service capabilities. You can put the catalog on the intranet inside the organization, so users can search for something. People in the research world have specialized systems, and you might find data from various places that sound similar."
 

Cons

"Skill requirement is required. There is a learning curve."
"There is room for improvement in the Data Marketplace aspect."
"Informatica's issue is the licensing. Right now, there are a lot of new gen MDMs that are offering a lot in a single licensing model."
"Some functionalities can be a challenge in the cloud."
"New machine learning could be added to Informatica MDM because the solution is outdated and is not moving with the current trends. The solution is good, but it definitely needs a lot of improvement and needs to speed up as per the market."
"One thing Informatica could improve is the way IPUs are used. Each customer purchases a certain amount of IPUs per month, but you can use more or less than that defined quantity. The only problem is if you don't use the all your IPUs, they don't carry over into the next month. I think customers should have the ability to transfer unused IPUs into the next month or year. This improvement could help give customers more flexibility, especially since cloud solutions need flexibility in how we use and pay for them."
"Most of the new features added by Informatica are through Elastic Mapping. It would be helpful to have features like multithreading or partitioning for Salesforce to enhance performance."
"The solution doesn't directly connect to any of the analytical tools."
"I would like to see better visuals for business users, such as a dashboard where they can precisely track where problems are."
 

Pricing and Cost Advice

Information not available
"The product is not very pocket-friendly for small and medium-sized businesses, and it is understandable because of the kind of features the tool gives."
"I rate the product's pricing a nine on a scale of one to ten, where one is low price, and ten is high price."
"It's a costly solution"
"It is an expensive solution. I would say it is the most expensive solution in the market."
"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 pretty high for us. It's more on the higher side, like low to middle high."
"I rate Informatica MDM's price a six on a scale of one to ten, where one is a low price, and ten is a high price."
"It is cost effective and an easily accessible tool."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
814,763 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Manufacturing Company
17%
Computer Software Company
16%
Healthcare Company
6%
Financial Services Firm
17%
Computer Software Company
13%
Manufacturing Company
10%
Government
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What needs improvement with Informatica Data Engineering Streaming?
Skill requirement is required. There is a learning curve.
What is your primary use case for Informatica Data Engineering Streaming?
We implement business intelligence solutions, including data warehousing tools, data integration to load data into warehouses, and then creating reports.
What advice do you have for others considering Informatica Data Engineering Streaming?
Overall, I would rate the solution an eight out of ten. Usually, Informatica is for big clients because of its pricing, and it also requires some skill sets. It requires investment into a proper da...
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 ...
 

Also Known As

Big Data Streaming, Informatica Intelligent Streaming, Intelligent Streaming
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
 

Overview

 

Sample Customers

Jewelry TV
The Travel Company, Carbonite
Find out what your peers are saying about Amazon Web Services (AWS), Informatica, Salesforce and others in Cloud Data Integration. Updated: October 2024.
814,763 professionals have used our research since 2012.