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

Informatica Intelligent Data Management Cloud (IDMC) vs StreamSets comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 11, 2025

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's cloud platform enhances data management efficiency, cost savings, and data security, requiring effective change management for optimal results.
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.9
Informatica's customer service is generally rated positively for quick, knowledgeable support, though some report occasional delays and inconsistencies.
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 Intelligent Data Management Cloud is praised for scalability and flexibility in handling large datasets, despite pricing concerns.
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.7
Users generally find IDMC stable, with occasional challenges after updates, especially in older versions or specific integrations.
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

Informatica IDMC needs UI improvements, better connectivity, streamlined configuration, cheaper pricing, and enhanced support with AI integration.
StreamSets struggles with integration, real-time processing, clarity in UI, memory issues, security, documentation, and cloud storage performance.
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
If the development interface could be optimized to have fewer modules, it would be greatly beneficial.
Data Integration Architect at Endeavour Foundation
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 provides a robust but expensive pricing model with complex licensing and potential negotiation discounts for enterprises.
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 offers seamless data integration, AI-enhanced features, and efficient governance, enhancing user experience and operational efficiency.
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
2nd
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
214
Ranking in other categories
Data Quality (1st), Business Process Management (BPM) (7th), Business-to-Business Middleware (3rd), API Management (6th), Cloud Data Integration (3rd), Data Governance (3rd), Test Data Management (3rd), Cloud Master Data Management (MDM) (1st), Data Management Platforms (DMP) (2nd), Data Masking (1st), Metadata Management (1st), Integration Platform as a Service (iPaaS) (3rd), Test Data Management Services (3rd), Product Information Management (PIM) (1st), Data Observability (1st), 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 January 2026, in the Data Integration category, the mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 3.7%, down from 5.5% 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 Market Share Distribution
ProductMarket Share (%)
Informatica Intelligent Data Management Cloud (IDMC)3.7%
StreamSets1.2%
Other95.1%
Data Integration
 

Featured Reviews

Divya-Raj - PeerSpot reviewer
Sr. Consultant cum Assistant Manager & Offshore Lead at Deloitte
Handles large data volumes effectively and offers competitive pricing
There is a lot of improvement required, as we still face some cache issues most of the time, which is a challenge that we expect to see resolved in the future. Additionally, there is some limitation when we are working with a tool, especially regarding In and Out parameters, and I feel that this aspect should be improved going ahead. We face issues with the API side, as Cloud Application Integration cannot handle large volumes; according to the API page, there is a limitation of 500 records or 500 MB. The AI integrated into the Informatica Intelligent Cloud Services solution is called Application Integration, where we still face challenges when dealing with huge volumes, as previously explained.
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.
879,768 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
14%
Manufacturing Company
10%
Computer Software Company
9%
Retailer
7%
Financial Services Firm
9%
Computer Software Company
8%
Insurance Company
8%
Manufacturing Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business51
Midsize Enterprise27
Large Enterprise153
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 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...
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.
 

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: December 2025.
879,768 professionals have used our research since 2012.