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

Informatica Intelligent Data Management Cloud (IDMC) vs StreamSets comparison

Informatica and IBM are both solutions in the Data Integration category. Informatica is ranked #3 with an average rating of 7.7, while IBM is ranked #23 with an average rating of 8.8. Informatica holds a 4.2% mindshare in DI, compared to IBM’s 1.6% mindshare. Additionally, 93% of Informatica users are willing to recommend the solution, compared to 100% of IBM users who would recommend it.
Informatica Intelligent Dat...
Read 185 Informatica Intelligent Data Management Cloud (IDMC) reviews
  • 7,761 Views
  • 4,961 Comparison Views
93% willing to recommend
StreamSets
Read 21 StreamSets reviews
  • 2,082 Views
  • 1,312 Comparison Views
100% willing to recommend
 

Comparison Buyer's Guide

Download the report
Executive SummaryUpdated on Dec 19, 2024

Informatica IDMC and StreamSets compete in the data management space. Overall, Informatica IDMC seems to have the upper hand due to its comprehensive feature set and better customer service ratings.

Features: Informatica IDMC offers a comprehensive integration of data management modules, strong data quality and governance features, and a flexible architecture supporting various data styles and domains. StreamSets provides a user-friendly pipeline design interface, excels in batch and streaming data processes, and offers robust data drift and CDC capabilities.

Room for Improvement: Informatica IDMC could enhance its user interface and integration with leading business applications. Users suggest improving intuitive error reporting and preconfigured business rules. StreamSets could improve logging mechanisms, GUI, and security features, while also addressing challenges with non-Java platforms integration and real-time processing.

Ease of Deployment and Customer Service: Informatica IDMC supports both on-premises and cloud environments, whereas StreamSets focuses on hybrid and public cloud setups. Informatica IDMC receives slightly better customer service ratings due to its organized and responsive support system, while StreamSets is appreciated for straightforward customer interactions.

Pricing and ROI: Informatica IDMC's pricing is perceived as high with a complex licensing model, yet it offers flexibility aligned with organizational needs, providing significant ROI over time. StreamSets, with options like an open-source model, appeals to various business sizes but can be expensive for smaller companies. Informatica users see ROI through improved data management processes, while StreamSets users benefit from cost savings via efficient data pipeline management.

DOWNLOAD THE COMPLETE REPORT
To learn more, read our detailed Informatica Intelligent Data Management Cloud (IDMC) vs. StreamSets Report (Updated: May 2025).
Buyer's Guide
Informatica Intelligent Data Management Cloud (IDMC) vs. StreamSets
May 2025
Download the complete report
Helped 860,592 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:
 

ROI

Sentiment score
7.1
Organizations benefit from improved data quality, time savings, and ROI with Informatica Cloud, enhancing processes and security.
Sentiment score
8.1
StreamSets speeds up data processing, boosts efficiency and revenue, simplifies tasks, enhances security, and reduces costs significantly.
 

Customer Service

Sentiment score
6.9
Informatica's customer service is effective, praised for responsiveness but criticized for occasional delays and inconsistency.
Sentiment score
6.7
StreamSets support is responsive and knowledgeable, offering effective solutions, though response times and technical handling could improve.
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.
Due to the tool's maturity limitations, solutions are not always simple and often require workarounds.
If they are unsure how to resolve an issue, they keep customers informed, providing updates about progress and ensuring communication with the product team to deliver accurate responses.
For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report
IBM technical support sometimes transfers tickets between different teams due to shift changes, which can be frustrating.
For more quotes and insights, download the StreamSets report
AC
Saikat Ghosh - PeerSpot reviewer
SK
SS
 

Scalability Issues

Sentiment score
7.3
Informatica IDMC is highly scalable and adaptable, though optimal design and documentation are crucial for large-scale operations.
Sentiment score
7.6
StreamSets is scalable and flexible, favored for cloud use but could improve auto-scaling for large data migrations.
As a SaaS platform, IDMC is quite scalable and provides complete flexibility.
For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report
No quotes available
For more quotes and insights, download the StreamSets report
 

Stability Issues

Sentiment score
7.7
Informatica Intelligent Data Management Cloud is generally stable, with newer versions being more reliable and support enhancing consistency.
Sentiment score
7.8
StreamSets is praised for stability and reliability, despite minor memory issues, with high user ratings and market competitiveness.
Stability is crucial because IDMC holds business-critical data, and it needs to be available all the time for business users.
For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report
No quotes available
For more quotes and insights, download the StreamSets report
 

Room For Improvement

IDMC requires UI improvements, better system connectivity, performance enhancements, cost reduction, AI features, and improved support and observability.
StreamSets struggles with integration, real-time processing, clarity in UI, memory issues, security, documentation, and cloud storage performance.
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 observability concept in Informatica Intelligent Data Management Cloud (IDMC) needs improvement as the capabilities are not up to the mark compared to the industry.
For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report
It would be beneficial if StreamSets addressed any potential memory leak issues to prevent unnecessary upgrades.
For more quotes and insights, download the StreamSets report
AC
Saikat Ghosh - PeerSpot reviewer
PC
SS
 

Setup Cost

Informatica IDMC's pricing is seen as high, with nuanced licensing, leading to user concerns compared to competitors.
StreamSets provides flexible pricing models, with varied user satisfaction, favoring larger enterprises over smaller companies due to cost.
It ranges from a quarter million to a couple of million a year.
The licenses are too expensive compared to before, which is why customers are now preferring other data metadata management tools like OneTrust, Collibra, and Azure Purview.
I think the costs are reasonable for the kinds of features that Informatica Intelligent Data Management Cloud (IDMC) has.
For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report
No quotes available
For more quotes and insights, download the StreamSets report
Saikat Ghosh - PeerSpot reviewer
SK
AC
 

Valuable Features

Informatica IDMC is a robust cloud platform offering seamless data integration, real-time streaming, and comprehensive data management features.
StreamSets offers intuitive interface, extensive connectors, and features accessible to non-technical users for seamless data integration and manipulation.
In on-premise, we call it EDC for metadata management, while in cloud-based technologies, it is known as the Metadata Command Center, which serves the same purpose as EDC concerning CDGC.
Informatica Intelligent Data Management Cloud (IDMC) can connect to pretty much any application, including Oracle Analytics and Power BI, and it works quite seamlessly.
The platform's ability to pull in data from other platforms without the need for an additional integration tool enhances its appeal.
For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report
It allows a hybrid installation approach, rather than being completely cloud-based or on-premises.
For more quotes and insights, download the StreamSets report
SK
AC
Saikat Ghosh - PeerSpot reviewer
SS
 

Categories and Ranking

Informatica Intelligent Dat...
Ranking in Data Integration
3rd
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
185
Ranking in other categories
Data Quality (1st), Business Process Management (BPM) (10th), Business-to-Business Middleware (5th), 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 (3rd), Product Information Management (PIM) (1st), Data Observability (2nd)
StreamSets
Ranking in Data Integration
23rd
Average Rating
8.4
Reviews Sentiment
7.0
Number of Reviews
21
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of July 2025, in the Data Integration category, the mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 4.2%, down from 6.7% compared to the previous year. The mindshare of StreamSets is 1.6%, up from 1.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

Saikat Ghosh - PeerSpot reviewer
Match and merge functionality is still the best but cloud version needs more functionality
There are various areas for improvement in IDMC. Enhancements on basic data management functionality and the UI front, such as multiple templates and improved grid views, would be beneficial. Bulk data management features could be improved from the UI perspective to get to the level of the on prem versions of Informatica MDM. The tool needs to mature but missing small but important features, like restricted dynamic attributes functionality, data inheritance rules in master hierachies, identifiers not being passed in jobs is a drawback.
Read full review
Ved Prakash Yadav - PeerSpot reviewer
Useful for data transformation and helps with column encryption
We use various tools and alerting systems to notify us of pipeline errors or failures. StreamSets supports data governance and compliance by allowing us to encrypt incoming data based on specified rules. We can easily encrypt columns by providing the column name and hash key. If you're considering using StreamSets for the first time, I would advise first understanding why you want to use it and how it will benefit you. If you're dealing with change tracking or handling large amounts of data, it could be cost-effective compared to services like Amazon. It's easy to schedule and manage tasks with the tool, and you can enhance your skills as an ETL developer. You can easily migrate traditional pipelines built on platforms like Informatica or Talend to StreamSets. I rate the overall solution an eight out of ten.
Read full review
report
See which vendors are best for you
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
See recommendations
860,592 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
12%
Manufacturing Company
9%
Insurance Company
6%
Financial Services Firm
12%
Computer Software Company
11%
Manufacturing Company
10%
Insurance Company
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

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...
See all answers
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...
See all answers
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 ...
See all answers
What do you like most about StreamSets?
The best thing about StreamSets is its plugins, which are very useful and work well with almost every data source. It's also easy to use, especially if you're comfortable with SQL. You can customiz...
See all answers
What needs improvement with StreamSets?
One issue I observed with StreamSets is that the memory runs out quickly when processing large volumes of data. Because of this memory issue, we have to upgrade our EC2 boxes in the Amazon AWS infr...
See all answers
What is your primary use case for StreamSets?
We are using StreamSets for batch loading.
See all answers
 

Comparisons

Microsoft Purview Data Governance vs Informatica Intelligent Data Management Cloud (IDMC) Logo
Microsoft Purview Data Governance vs Informatica Intelligent Data Management Cloud (IDMC)
Compared 5% of the time
Informatica PowerCenter vs Informatica Intelligent Data Management Cloud (IDMC) Logo
Informatica PowerCenter vs Informatica Intelligent Data Management Cloud (IDMC)
Compared 4% of the time
Azure Data Factory vs Informatica Intelligent Data Management Cloud (IDMC) Logo
Azure Data Factory vs Informatica Intelligent Data Management Cloud (IDMC)
Compared 4% of the time
Reltio Cloud vs Informatica Intelligent Data Management Cloud (IDMC) Logo
Reltio Cloud vs Informatica Intelligent Data Management Cloud (IDMC)
Compared 4% of the time
Collibra Governance vs Informatica Intelligent Data Management Cloud (IDMC) Logo
Collibra Governance vs Informatica Intelligent Data Management Cloud (IDMC)
Compared 4% of the time
More Informatica Intelligent Data Management Cloud (IDMC) Competitors
Informatica PowerCenter vs StreamSets Logo
Informatica PowerCenter vs StreamSets
Compared 13% of the time
IBM InfoSphere DataStage vs StreamSets Logo
IBM InfoSphere DataStage vs StreamSets
Compared 12% of the time
webMethods.io vs StreamSets Logo
webMethods.io vs StreamSets
Compared 9% of the time
Azure Data Factory vs StreamSets Logo
Azure Data Factory vs StreamSets
Compared 7% of the time
Fivetran vs StreamSets Logo
Fivetran vs StreamSets
Compared 6% of the time
More StreamSets Competitors
 

Product Reports

Buyer's Guide
Informatica Intelligent Data Management Cloud (IDMC)
April 2025
Informatica Intelligent Data Management Cloud (IDMC) reportDownload Informatica Intelligent Data Management Cloud (IDMC) product report
Buyer's Guide
StreamSets
June 2025
StreamSets reportDownload StreamSets product report
 

Also Known As

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
No data available
 

Overview

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.

Informatica

StreamSets is a data integration platform that enables organizations to efficiently move and process data across various systems. It offers a user-friendly interface for designing, deploying, and managing data pipelines, allowing users to easily connect to various data sources and destinations. StreamSets also provides real-time monitoring and alerting capabilities, ensuring that data is flowing smoothly and any issues are quickly addressed.

IBM
 

Sample Customers

The Travel Company, Carbonite
Availity, BT Group, Humana, Deluxe, GSK, RingCentral, IBM, Shell, SamTrans, State of Ohio, TalentFulfilled, TechBridge
Buyer's Guide
Informatica Intelligent Data Management Cloud (IDMC) vs. StreamSets
May 2025
Free Report: Informatica Intelligent Data Management Cloud (IDMC) vs. StreamSets
Find out what your peers are saying about Informatica Intelligent Data Management Cloud (IDMC) vs. StreamSets and other solutions. Updated: May 2025.
DOWNLOAD NOW
860,592 professionals have used our research since 2012.
See our Informatica Intelligent Data Management Cloud (IDMC) vs. StreamSets report.
See our list of best Data Integration vendors and best Cloud Data Integration vendors.

We monitor all 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.