

Informatica Intelligent Data Management Cloud (IDMC) and StreamSets compete in the data management and integration category. Based on feature set and deployment flexibility, IDMC appears to have a slight edge due to its comprehensive features and highly rated customer service.
Features: IDMC offers a robust suite of features such as seamless integration of MDM, data quality, and data integration modules, supporting multiple domains with a flexible architecture. It includes valuable features like declarative ETL development and data synchronization tasks. StreamSets provides ease of use with its Control Hub for managing data loads, drag-and-drop functionality, and supports both batch and streaming processes, offering a user-friendly option for data pipeline creation.
Room for Improvement: IDMC needs enhancements in its user interface, especially for data stewardship and integration with non-Unicode systems like SAP. Its pricing model and licensing complexity are also noted as areas for improvement. StreamSets could bolster its security features, offer better logging mechanisms, and improve pipeline organization for handling large data volumes more efficiently. Enhancements in documentation and log management user experience are also suggested.
Ease of Deployment and Customer Service: IDMC’s adaptability to public, private, and hybrid cloud environments offers flexible deployment options, with highly rated customer service and technical support. StreamSets, operating primarily in public and hybrid clouds, is praised for its ease of deployment due to its containerized application nature. However, variability in customer support emphasizes the need for knowledgeable in-house personnel.
Pricing and ROI: IDMC’s pricing model based on Informatica Processing Units is often seen as expensive, though the comprehensive features often justify the cost through long-term ROI. StreamSets provides both free and licensed options, with pricing considered less flexible and more enterprise-oriented. While small setups benefit from cost-effectiveness, additional feature licensing can increase costs.
Leadership prefers to utilize third-party tools, such as Snowflake, which has both storage and ELT features.
The stability and performance remain issues.
Compared to Collibra Catalog, where the value is noticeable within six months.
Due to the tool's maturity limitations, solutions are not always simple and often require workarounds.
Even after going out of service support, they still reached back to me whenever I raised tickets.
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.
IBM technical support sometimes transfers tickets between different teams due to shift changes, which can be frustrating.
I have used the product over multiple systems and was able to write reports for large data sets without any performance issues.
As a SaaS platform, IDMC is quite scalable and provides complete flexibility.
There are many options available, and the licensing model is quite good, supporting our needs effectively.
Stability is crucial because IDMC holds business-critical data, and it needs to be available all the time for business users.
There are substantial stability issues with Informatica Cloud Data Quality on the cloud.
I find the stability to be good, with occasional restarts required every two to three months due to glitches.
The tool needs to mature in terms of category-specific attributes or dynamic attributes.
The current solution requires code-writing and tweaking, while other solutions offer material-level matches.
If the development interface could be optimized to have fewer modules, it would be greatly beneficial.
It would be beneficial if StreamSets addressed any potential memory leak issues to prevent unnecessary upgrades.
It ranges from a quarter million to a couple of million a year.
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.
Regarding pricing, compared to other tools I have worked with, Informatica offers competitive pricing, which I find not high in terms of starting strategy.
The platform's ability to pull in data from other platforms without the need for an additional integration tool enhances its appeal.
The connectors serve as the main functionality, making data integration processes more efficient by saving time and effort.
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.
It allows a hybrid installation approach, rather than being completely cloud-based or on-premises.
| Product | Market Share (%) |
|---|---|
| Informatica Intelligent Data Management Cloud (IDMC) | 3.7% |
| StreamSets | 1.2% |
| Other | 95.1% |

| Company Size | Count |
|---|---|
| Small Business | 51 |
| Midsize Enterprise | 27 |
| Large Enterprise | 153 |
| Company Size | Count |
|---|---|
| Small Business | 9 |
| Midsize Enterprise | 2 |
| Large Enterprise | 11 |
Informatica Intelligent Data Management Cloud (IDMC) offers seamless integration of master data management, data quality, and data integration with a cloud-native architecture supporting multiple data management styles, optimizing data governance through metadata management.
IDMC enhances data synchronization and mapping tasks, utilizing a broad range of connectors to interact efficiently with data sources. Its precise address validation via AddressDoctor and intuitive navigation bolster user empowerment, delivering agility, scalability, and security in data governance. Despite its strengths, areas like ease of use, SAP integration, and reporting could benefit from enhancements. Connectivity issues and workflow complexities are noted, needing improvements in performance, support, and licensing cost. Users demand expanded ETL capabilities, real-time processing, and broader data source support to address growing data needs.
What are the key features of IDMC?In industries such as banking, healthcare, and telecom, IDMC is implemented for data integration, cloud migration, and enhancing data quality. Its capabilities are crucial for metadata management, lineage tracking, and real-time processing, ensuring high data quality and streamlined operations.
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.
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.