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 19, 2024

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 IDMC enhances data quality, efficiency, and analytics, offering secure integration and reduced cloud migration costs for businesses.
Sentiment score
8.1
StreamSets speeds up data processing, boosts efficiency and revenue, simplifies tasks, enhances security, and reduces costs significantly.
We see return on investment from this solution in terms of time; time reduction or cost benefits is what we are getting very good results from.
 

Customer Service

Sentiment score
6.9
Informatica's customer service is praised for quick, knowledgeable support, though response times can vary with customization and membership levels.
Sentiment score
6.7
StreamSets support is responsive and knowledgeable, offering effective solutions, though response times and technical handling could improve.
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.
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.
I would rate it as nine out of ten for Informatica PowerCenter kind of products or the Informatica integration products.
IBM technical support sometimes transfers tickets between different teams due to shift changes, which can be frustrating.
 

Scalability Issues

Sentiment score
7.3
Informatica IDMC delivers scalable, flexible data management across cloud and on-premise environments, accommodating diverse enterprise needs efficiently.
Sentiment score
7.6
StreamSets is scalable and flexible, favored for cloud use but could improve auto-scaling for large data migrations.
I find Informatica Intelligent Data Management Cloud (IDMC) to be a sustainable and scalable solution.
As a SaaS platform, IDMC is quite scalable and provides complete flexibility.
 

Stability Issues

Sentiment score
7.7
Informatica Cloud is highly rated for stability, despite occasional issues; support effectively resolves any reported bugs.
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.
 

Room For Improvement

Informatica IDMC requires improvements in integration, user interface, performance, support consistency, connectivity, automation, data tagging, and pricing.
StreamSets struggles with integration, real-time processing, clarity in UI, memory issues, security, documentation, and cloud storage performance.
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.
One of my clients has a requirement; they want to integrate metadata into the process, which means, for example, if I just want to implement a new field into my database, that field needs to be reflected throughout, let's say, 200 mappings. This highlights the need for a data-driven approach.
I also want to see integration with other Informatica products, such as IICS, to leverage the metadata from EDC.
It would be beneficial if StreamSets addressed any potential memory leak issues to prevent unnecessary upgrades.
 

Setup Cost

Informatica IDMC, a costly solution for large enterprises, offers extensive features and flexibility, justifying its premium pricing.
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.
 

Valuable Features

Informatica IDMC excels in data management with strong integration, AI-driven analytics, and a flexible user interface.
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.
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.
It allows a hybrid installation approach, rather than being completely cloud-based or on-premises.
 

Categories and Ranking

Informatica Intelligent Dat...
Ranking in Data Integration
4th
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
186
Ranking in other categories
Data Quality (1st), Business Process Management (BPM) (11th), Business-to-Business Middleware (6th), 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 (1st), Metadata Management (1st), Test Data Management Services (3rd), Product Information Management (PIM) (1st), Data Observability (2nd)
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 September 2025, in the Data Integration category, the mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 3.6%, down from 6.3% compared to the previous year. The mindshare of StreamSets is 1.4%, down from 1.5% 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.6%
StreamSets1.4%
Other95.0%
Data Integration
 

Featured Reviews

SaurabhGaonshindhe - PeerSpot reviewer
Modular structure and AI features stream new reporting processes
One of my clients has a requirement; they want to integrate metadata into the process, which means, for example, if I just want to implement a new field into my database, that field needs to be reflected throughout, let's say, 200 mappings. This highlights the need for a data-driven approach. My experience with technical support from Informatica is quite interesting; I would rate it as nine out of ten for Informatica PowerCenter kind of products or the Informatica integration products, because my team can do some hands-on using their free licenses or one-month kind of products. However, for products Master Data Management or related to MDM or Data Governance, there is no way by which we can directly practice, and my team struggles at that point.
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.
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
867,370 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
16%
Computer Software Company
10%
Manufacturing Company
10%
Insurance Company
7%
Computer Software Company
11%
Manufacturing Company
9%
Financial Services Firm
9%
Insurance Company
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business42
Midsize Enterprise24
Large Enterprise134
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, 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

 

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: September 2025.
867,370 professionals have used our research since 2012.