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

Informatica Intelligent Data Management Cloud (IDMC) vs WhereScape RED 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 Cloud enhances data quality and processes, with ROI influenced by master data, change management, and adoption rates.
Sentiment score
7.0
WhereScape RED offers varied returns, with some users experiencing quick ROI, efficient development, and substantial gains.
 

Customer Service

Sentiment score
6.8
Informatica offers strong support, praised for expertise but needing consistent response times; priority and contracts affect service quality.
Sentiment score
8.3
Customer service is often excellent and prompt, although some feel support wanes post-purchase and seems money-driven.
Due to the tool's maturity limitations, solutions are not always simple and often require workarounds.
 

Scalability Issues

Sentiment score
7.3
Informatica Intelligent Data Management Cloud offers scalable solutions, handling large volumes with proper planning and excellent documentation for user satisfaction.
Sentiment score
6.6
WhereScape RED efficiently scales with large data, improves ETL processing, and enhances speeds using ELT and SQL features.
As a SaaS platform, IDMC is quite scalable and provides complete flexibility.
 

Stability Issues

Sentiment score
7.7
Informatica IDMC is generally reliable despite occasional issues, with strong vendor support ensuring minimal downtime and manageable bugs.
Sentiment score
6.6
WhereScape RED's stability varies; it's praised for maturity and speed, yet some report resource and debugging challenges.
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 needs UI improvements, better automation, pricing review, enhanced support, and performance enhancements for optimal usability.
WhereScape RED suffers from scalability issues, lacking performance efficiency, enhanced documentation, better GUI, and improved support for multi-database environments.
The tool needs to mature in terms of category-specific attributes or dynamic attributes.
 

Setup Cost

Informatica IDMC pricing is high, varies by project, and often suits large enterprises with negotiable options.
WhereScape RED's flexible developer-based licensing and native SQL code provide cost-effective, vendor-independent data warehousing solutions with quick ROI potential.
It ranges from a quarter million to a couple of million a year.
 

Valuable Features

Informatica IDMC provides flexible data management with seamless integration, AI capabilities, and robust governance for efficient data handling.
WhereScape RED streamlines data warehousing with automation, agile support, user-friendly interface, and compatibility with leading methodologies.
The platform's ability to pull in data from other platforms without the need for an additional integration tool enhances its appeal.
 

Categories and Ranking

Informatica Intelligent Dat...
Ranking in Data Integration
3rd
Average Rating
7.8
Reviews Sentiment
6.8
Number of Reviews
182
Ranking in other categories
Data Quality (1st), Business Process Management (BPM) (6th), Business-to-Business Middleware (3rd), 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) (1st), Data Masking (2nd), Metadata Management (1st), Test Data Management Services (2nd), Product Information Management (PIM) (1st), Data Observability (2nd)
WhereScape RED
Ranking in Data Integration
47th
Average Rating
8.2
Reviews Sentiment
7.2
Number of Reviews
15
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of February 2025, in the Data Integration category, the mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 5.0%, down from 7.8% compared to the previous year. The mindshare of WhereScape RED is 1.0%, up from 0.9% 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.
it_user584544 - PeerSpot reviewer
The ​architecture is based on metadata and documentation is automated.
I would love to see a GUI interface for defining dependencies between build processes. RED provides a spreadsheet like interface for defining the dependencies between builds. Once the dependencies are defined, RED can produce a nice dependency diagram to give a visualization of the dependency tree. It would be easier to define complex dependency relationships if the dependency diagram were interactive. Our legacy ETL tool provided this GUI dependency definition via a drag and drop diagram which was very useful. The solution provided by WhereScape does work, and the dependency diagrams generated are helpful. It would just be nice to have the ability to define dependencies via a diagram, since dependencies relationships are much easier to understand via a diagram.
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
838,713 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
12%
Manufacturing Company
10%
Government
6%
Financial Services Firm
19%
Insurance Company
10%
Computer Software Company
8%
Healthcare Company
8%
 

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...
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 ...
Ask a question
Earn 20 points
 

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
British American Tobacco, Cornell University, Allianz Benelux, Finnair, Solarwinds and many more.
Find out what your peers are saying about Informatica Intelligent Data Management Cloud (IDMC) vs. WhereScape RED and other solutions. Updated: February 2025.
838,713 professionals have used our research since 2012.