No more typing reviews! Try our Samantha, our new voice AI agent.

Informatica Intelligent Data Management Cloud (IDMC) vs StreamSets comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Mar 15, 2026

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
6.5
Informatica Cloud enhances data management ROI through analytics and efficiency, but benefits vary with adoption and tool preference.
Sentiment score
8.1
StreamSets speeds up data processing, boosts efficiency and revenue, simplifies tasks, enhances security, and reduces costs significantly.
Leadership prefers to utilize third-party tools, such as Snowflake, which has both storage and ELT features.
Sr. Consultant cum Assistant Manager & Offshore Lead at Deloitte
The stability and performance remain issues.
consultant at a energy/utilities company with 5,001-10,000 employees
Compared to Collibra Catalog, where the value is noticeable within six months.
Data and Analytics Manager at a insurance company with 10,001+ employees
 

Customer Service

Sentiment score
6.8
Informatica IDMC offers strong customer service, with variability in response times and support quality based on issue priority.
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.
Consulting Principal & Founder at Digital Data Consultancy
Even after going out of service support, they still reached back to me whenever I raised tickets.
IT Manager - Data Quality and Migration at a manufacturing company with 10,001+ employees
We expect more responsive assistance because they have the expertise since Informatica is their tool, but I don't see enough expertise on the Informatica support side.
Sr. Consultant cum Assistant Manager & Offshore Lead at Deloitte
IBM technical support sometimes transfers tickets between different teams due to shift changes, which can be frustrating.
Enterprise Solutions Architect at a energy/utilities company with 1,001-5,000 employees
 

Scalability Issues

Sentiment score
7.3
Informatica IDMC is highly scalable and adaptable, catering to enterprise-level tasks with flexible cloud-based architecture.
Sentiment score
7.6
StreamSets is scalable and flexible, favored for cloud use but could improve auto-scaling for large data migrations.
I have used the product over multiple systems and was able to write reports for large data sets without any performance issues.
IT Manager - Data Quality and Migration at a manufacturing company with 10,001+ employees
As a SaaS platform, IDMC is quite scalable and provides complete flexibility.
Consulting Principal & Founder at Digital Data Consultancy
There are many options available, and the licensing model is quite good, supporting our needs effectively.
Data Integration Architect at Endeavour Foundation
 

Stability Issues

Sentiment score
7.6
Informatica Intelligent Data Management Cloud is generally stable, with minor issues, praised for scalability and reliability, rated highly.
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.
Consulting Principal & Founder at Digital Data Consultancy
There are substantial stability issues with Informatica Cloud Data Quality on the cloud.
consultant at a energy/utilities company with 5,001-10,000 employees
I find the stability to be good, with occasional restarts required every two to three months due to glitches.
IT Manager - Data Quality and Migration at a manufacturing company with 10,001+ employees
 

Room For Improvement

IDMC faces integration, pricing, customization, and usability challenges, needing improvements in performance, support, AI, and functionalities.
StreamSets struggles with integration, real-time processing, clarity in UI, memory issues, security, documentation, and cloud storage performance.
I feel whatever the tool does not have now, there is a feedback loop allowing us to request new features, and we continually ask for different ways to do things as we have a pipeline into the product management team.
Contractor at Sanlam
The tool needs to mature in terms of category-specific attributes or dynamic attributes.
Consulting Principal & Founder at Digital Data Consultancy
The current solution requires code-writing and tweaking, while other solutions offer material-level matches.
IT Manager - Data Quality and Migration at a manufacturing company with 10,001+ employees
It would be beneficial if StreamSets addressed any potential memory leak issues to prevent unnecessary upgrades.
Enterprise Solutions Architect at a energy/utilities company with 1,001-5,000 employees
 

Setup Cost

Informatica IDMC is a costly, feature-rich solution for large enterprises, with pricing concerns partly mitigated by negotiable discounts.
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.
Consulting Principal & Founder at Digital Data Consultancy
Informatica Intelligent Cloud Services is affordable for my specific use cases, with the pricing being rated three or four on a scale where one is very cheap.
Data Integration Architect at Endeavour Foundation
Regarding pricing, compared to other tools I have worked with, Informatica offers competitive pricing, which I find not high in terms of starting strategy.
Sr. Consultant cum Assistant Manager & Offshore Lead at Deloitte
 

Valuable Features

Informatica IDMC is praised for seamless data integration, quality management, flexibility, and robust AI-driven data features.
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.
Consulting Principal & Founder at Digital Data Consultancy
The connectors serve as the main functionality, making data integration processes more efficient by saving time and effort.
Data Integration Architect at Endeavour Foundation
We could run data quality rules as part of Service Bus, which ensured the integrity of customer information before it was entered into our database.
Data and Analytics Manager at a insurance company with 10,001+ employees
It allows a hybrid installation approach, rather than being completely cloud-based or on-premises.
Enterprise Solutions Architect at a energy/utilities company with 1,001-5,000 employees
 

Categories and Ranking

Informatica Intelligent Dat...
Ranking in Data Integration
1st
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
215
Ranking in other categories
Data Quality (1st), Business Process Management (BPM) (7th), Business-to-Business Middleware (2nd), API Management (5th), Cloud Data Integration (2nd), Data Governance (3rd), Test Data Management (2nd), Cloud Master Data Management (MDM) (1st), Data Management Platforms (DMP) (2nd), Data Masking (2nd), Metadata Management (2nd), Integration Platform as a Service (iPaaS) (4th), Test Data Management Services (3rd), Product Information Management (PIM) (1st), Data Observability (2nd), AI Data Analysis (1st)
StreamSets
Ranking in Data Integration
22nd
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 June 2026, in the Data Integration category, the mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 3.7%, down from 4.6% compared to the previous year. The mindshare of StreamSets is 1.2%, down from 1.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Mindshare Distribution
ProductMindshare (%)
Informatica Intelligent Data Management Cloud (IDMC)3.7%
StreamSets1.2%
Other95.1%
Data Integration
 

Featured Reviews

RC
Contractor at Sanlam
Cloud data catalog has streamlined lineage and quality while leaving more automation to improve
I have not explored IDMC's automation capabilities driven by AI and metadata too much at the moment, but it is on the cards. We are basically creating the foundation, as the whole migration has taken place recently and it is still early days. I think Informatica Intelligent Data Management Cloud (IDMC) is evolving, and as the vendors move forward, they pick up new concepts from each other. I have seen that products leapfrog each other, and from my experience over the years, the big players tend to copy features or add enhancements based on industry trends. I feel whatever the tool does not have now, there is a feedback loop allowing us to request new features, and we continually ask for different ways to do things as we have a pipeline into the product management team. It is difficult to say what additional features I would prefer to see in the next release of IDMC. I would appreciate more automation on the lineage front, with more AI to seamlessly join independent sources and create seamless lineage between different technologies, such as from file into database A into a different database and landing up in a reporting system such as Cognos, Qlik, Qlik Sense, QlikView, or Power BI.
SS
Enterprise Solutions Architect at a energy/utilities company with 1,001-5,000 employees
Enables effective batch loading with visual interface and enterprise support
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 infrastructure. I had to switch to a new EC2 box, even though the processor was not fully utilized. It would be beneficial if StreamSets addressed any potential memory leak issues to prevent unnecessary upgrades. Additionally, it would be a great enhancement if StreamSets could produce a lineage graph to visualize how the data has passed through the system.
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
900,644 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
13%
Manufacturing Company
11%
Construction Company
7%
Computer Software Company
6%
Financial Services Firm
12%
Manufacturing Company
7%
Insurance Company
7%
Computer Software Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business51
Midsize Enterprise27
Large Enterprise155
By reviewers
Company SizeCount
Small Business9
Midsize Enterprise2
Large Enterprise11
 

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...
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 ...
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...
What is your primary use case for StreamSets?
We are using StreamSets for batch loading.
What advice do you have for others considering StreamSets?
If asked, I definitely recommend StreamSets to other users. My overall rating for the solution is nine.
 

Also Known As

ActiveVOS, Active Endpoints, Address Verification, Persistent Data Masking
No data available
 

Overview

 

Sample Customers

The Travel Company, Carbonite
Availity, BT Group, Humana, Deluxe, GSK, RingCentral, IBM, Shell, SamTrans, State of Ohio, TalentFulfilled, TechBridge
Find out what your peers are saying about Informatica Intelligent Data Management Cloud (IDMC) vs. StreamSets and other solutions. Updated: June 2026.
900,644 professionals have used our research since 2012.