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 #16 with an average rating of 8.6. Informatica holds a 4.4% 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 183 Informatica Intelligent Data Management Cloud (IDMC) reviews
  • 9,213 Views
  • 6,644 Comparison Views
93% willing to recommend
StreamSets
Read 21 StreamSets reviews
  • 2,256 Views
  • 1,582 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 851,604 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
Informatica Cloud users benefit from improved data quality and efficiency, emphasizing proper use for long-term ROI and digital transformation.
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
IDMC customer service is praised for competence but faces occasional delays influenced by time zones and contract levels.
Sentiment score
6.7
StreamSets support is responsive and knowledgeable, offering effective solutions, though response times and technical handling could improve.
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 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
Saikat Ghosh - PeerSpot reviewer
AC
SS
 

Scalability Issues

Sentiment score
7.3
Informatica IDMC excels in scalable data management, handling large volumes and global deployments, with adaptability in cloud environments.
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 IDMC is generally stable, with occasional issues in older versions or specific features, often resolved by support updates.
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 needs enhancements in user interface, data integration, security, automation, cloud support, documentation, and customer service.
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.
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
SS
 

Setup Cost

Informatica IDMC's pricing is complex and expensive, with negotiable options, prompting consideration of alternatives despite its robust features.
StreamSets provides flexible pricing models, with varied user satisfaction, favoring larger enterprises over smaller companies due to cost.
IDMC is often described as the 'Ferrari of Master Data Solutions,' implying that while expensive, it is business-critical and, therefore, justified.
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
 

Valuable Features

Informatica IDMC offers seamless integration, flexible architecture, and robust data management with real-time processing and user-friendly interface.
StreamSets offers intuitive interface, extensive connectors, and features accessible to non-technical users for seamless data integration and manipulation.
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.
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
Saikat Ghosh - PeerSpot reviewer
AC
SS
 

Categories and Ranking

Informatica Intelligent Dat...
Ranking in Data Integration
3rd
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
183
Ranking in other categories
Data Quality (1st), Business Process Management (BPM) (13th), Business-to-Business Middleware (4th), API Management (8th), 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
16th
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 May 2025, in the Data Integration category, the mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 4.4%, down from 7.2% 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

Raj Sethupathi - PeerSpot reviewer
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
Karthik Rajamani - PeerSpot reviewer
Integrates with different enterprise systems and enables us to easily build data pipelines without knowing how to code
There are a few things that can be better. We create pipelines or jobs in StreamSets Control Hub. It is a great feature, but if there is a way to have a folder structure or organize the pipelines and jobs in Control Hub, it would be great. I submitted a ticket for this some time back. There are certain features that are only available at certain stages. For example, HTTP Client has some great features when it is used as a processor, but those features are not available in HTTP Client as a destination. There could be some improvements on the group side. Currently, if I want to know which users are a part of certain groups, it is not straightforward to see. You have to go to each and every user and check the groups he or she is a part of. They could improve it in that direction. Currently, we have to put in a manual effort. In case something goes wrong, we have to go to each and every user account to check whether he or she is a part of a certain group or not.
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
851,604 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
13%
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

Informatica PowerCenter vs Informatica Intelligent Data Management Cloud (IDMC) Logo
Informatica PowerCenter vs Informatica Intelligent Data Management Cloud (IDMC)
Compared 5% 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 5% of the time
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
Reltio Cloud vs Informatica Intelligent Data Management Cloud (IDMC) Logo
Reltio Cloud vs Informatica Intelligent Data Management Cloud (IDMC)
Compared 4% of the time
TIBCO EBX vs Informatica Intelligent Data Management Cloud (IDMC) Logo
TIBCO EBX 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 12% 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
Fivetran vs StreamSets Logo
Fivetran vs StreamSets
Compared 7% of the time
Azure Data Factory vs StreamSets Logo
Azure Data Factory vs StreamSets
Compared 7% 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
April 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
851,604 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.