Informatica Intelligent Data Management Cloud (IDMC) vs WhereScape RED comparison

Informatica and WhereScape are both solutions in the Data Integration category. Informatica is ranked #3 with an average rating of 7.8, while WhereScape is ranked #48. Additionally, 93% of Informatica users are willing to recommend the solution, compared to 95% of WhereScape users who would recommend it.

Informatica Intelligent Dat...

Read 181 Informatica Intelligent Data Management Cloud (IDMC) reviews

13,019 Views
9,444 Comparison Views

93% willing to recommend

WhereScape RED

Read 15 WhereScape RED reviews

1,778 Views
1,210 Comparison Views

95% willing to recommend

Informatica Intelligent Dat...

WhereScape RED

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Dec 19, 2024

WhereScape RED and Informatica IDMC compete in the data integration and governance category. WhereScape RED holds an advantage in automation and cost-effectiveness, while Informatica IDMC leads in cloud compatibility and comprehensive data integration features.

Features: WhereScape RED is highly regarded for its automation in generating metadata-driven ETL processes and comprehensive documentation, ideal for agile development. Users also benefit from warehouse automation, impact analysis, and serverless ETL execution. Informatica IDMC is noted for its robust data integration and governance capabilities, supporting numerous data sources with strong cloud compatibility. Users appreciate its performance and connectivity.

Room for Improvement: WhereScape RED is challenged by performance and scalability with high data volumes, a lack of change data capture support, and the inability to share metadata repositories. It could also enhance task scheduling and error logging. Informatica IDMC could simplify its UI and reduce complexity, particularly for new users, and improve integration with certain platforms and large data handling. Users seek better pricing flexibility and on-prem to cloud functionality.

Ease of Deployment and Customer Service: Both products offer flexible deployment options, with WhereScape RED focusing on on-premises and Informatica extensively supporting cloud environments. WhereScape RED receives praise for personalized technical support, though post-purchase support experiences may diminish over time. Informatica IDMC receives positive feedback for strong customer support and comprehensive deployment assistance.

Pricing and ROI: WhereScape RED is seen as a cost-effective solution with straightforward licensing focused on developer seats, noted for significant ROI by reducing time-to-market and maintenance costs. Its flexible licensing supports easy scalability without CPU concerns. Informatica IDMC is perceived as expensive with complex pricing, yet offers robust functionality that justifies the cost for larger enterprises, even leading some users to explore alternatives.

To learn more, read our detailed Informatica Intelligent Data Management Cloud (IDMC) vs. WhereScape RED Report (Updated: January 2025).

Buyer's Guide

Informatica Intelligent Data Management Cloud (IDMC) vs. WhereScape RED

January 2025

Download the complete report

Helped 831,265 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

Informatica Intelligent Dat...

Ranking in Data Integration

3rd

Average Rating

8.0

Reviews Sentiment

6.8

Number of Reviews

181

Ranking in other categories

Data Quality (1st), Business Process Management (BPM) (7th), 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

48th

Average Rating

8.2

Reviews Sentiment

7.2

Number of Reviews

Ranking in other categories

No ranking in other categories

Featured Reviews

Raj Sethupathi

Data Integration Consultant GCP/AWS at Infogrators Inc

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.

Read full review

it_user584544

Manager Data Warehousing at a university with 10,001+ employees

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.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"You can extract and transfer your data as you wish it to be consumed later."

"I know that there are two good features, APN and ServiceNow but we haven't explored all of its features yet."

"The serverless capability and the packaging application of the solution are valuable."

"Informatica Cloud Data Integration is stable."

"Informatica MDM's most valuable feature is the interconnection between multiple Master Data domains."

"I like the fact that you can find almost any product connection that you need and the list is always expanding."

"The most valuable feature of Informatica Enterprise Data Catalog is it provides clients with a full view of the enterprise data assets. For example, how many data assets they have and who owns them."

"Data synchronization tasks."

More Informatica Intelligent Data Management Cloud (IDMC) pros

"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."

"RED has provided us the ability to integrate, stage, and transform data from diverse sources into an enterprise-grade data warehouse which meets the needs of my organization, but it also enables us to easily and quickly make ETL or DW changes."

"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."

"Naturally produces a way to easily debug your DW data solutions."

"The tool supports multiple target update methods."

"WhereScape's deployment package is a fantastic feature. The application allows for selecting specific objects that you would like to deploy from one environment to another rather than deploying the entire database."

"The most valuable feature is the metadata generated code."

"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."

More WhereScape RED pros

Cons

"Informatica MDM could improve the interdependency with integration. The solution sometimes becomes a bit difficult to change considering a lot of interdependency with the integration. There can be some improvement in the workflows and they can introduce more artificial intelligence."

"The tools required to migrate existing mappings and server rules through cloud data quality are not available."

"Certain applications are not being synced with the ION."

"Error reporting and debugging need improvement."

"It is not easy to set up and configure the tool."

"While my company operates on the cloud, we have seen that Informatica Cloud Data Integration has some performance issues causing it to lag."

"This is a costly solution. We have several customers who evaluate it but then look for other solutions because of the cost. At present, Informatica MDM comes as an on-premises or cloud-based solution. I would like to see them offer a SaaS-based MDM model. I think they are working on it."

"The solution still is a bit manual in its functionality. We want t to be more automation-driven."

More Informatica Intelligent Data Management Cloud (IDMC) cons

"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."

"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."

"Improve the object renaming ability (it works, but it could be more automated)."

"The solution can be a little more user-friendly on enterprise-level where people use it."

"The scheduled jobs which are run by the WhereScape scheduler seem to be a strangely separate animal. Unlike all other WhereScape objects, jobs cannot be added to WhereScape projects. Also, unlike all other objects, jobs also cannot be deleted using a WhereScape deployment application."

"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."

"Project-based searching of data objects in the data warehouse browser needs to be improved."

"No support for change data capture or delta detection - that must be custom coded ."

More WhereScape RED cons

Pricing and Cost Advice

"It's a costly solution"

"We are quite happy with the licensing model."

"The pricing structure is good, but having to pay for extra drivers to be used in an ICS environment makes me a little nervous."

"The licensing price of the product depends on the organization's requirements."

"My understanding is that Informatica is quite expensive compare to other tools that are available in the market."

"It's a very expensive solution"

"The solution's pricing model is easy, but it is very expensive."

"Informatica MDM's pricetag should come down. They have to cut some costs."

More Informatica Intelligent Data Management Cloud (IDMC) pricing and cost advice

"ROI is at least 10 times."

"Our company purchased a corporate unlimited license."

"Speed to market of a warehouse solution at a relatively inexpensive price point."

"Factor in the price of specialized consulting who know this product. They're hard to find and expensive."

See which vendors are best for you

Use our free recommendation engine to learn which Data Integration solutions are best for your needs.

See recommendations

831,265 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

Financial Services Firm

19%

Insurance Company

Government

Computer Software Company

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...

See all answers

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...

See all answers

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 ...

See all answers

Ask a question

Earn 20 points

Comparisons

Informatica PowerCenter vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 8% of the time

Azure Data Factory vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 7% of the time

Reltio Cloud vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 5% of the time

Microsoft Purview Data Governance vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 4% of the time

AWS Glue vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 4% of the time

More Informatica Intelligent Data Management Cloud (IDMC) Competitors

Informatica PowerCenter vs WhereScape RED

Compared 19% of the time

Azure Data Factory vs WhereScape RED

Compared 18% of the time

SSIS vs WhereScape RED

Compared 11% of the time

Matillion ETL vs WhereScape RED

Compared 9% of the time

Toad Data Point vs WhereScape RED

Compared 4% of the time

More WhereScape RED Competitors

Product Reports

Buyer's Guide

Informatica Intelligent Data Management Cloud (IDMC)

January 2025

Informatica Intelligent Data Management Cloud (IDMC) report

Download Informatica Intelligent Data Management Cloud (IDMC) product report

Buyer's Guide

WhereScape RED

December 2024

Download WhereScape RED product report

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

Learn More

Informatica

Video not available

WhereScape

Overview

Informatica Intelligent Data Management Cloud (IDMC) is a robust platform used by banks, financial institutions, and health sector organizations for data management, governance, and compliance.

IDMC provides comprehensive tools for data discovery, profiling, masking, and transformation. It supports Salesforce integration, real-time data streaming, and scalable data management solutions. Health organizations manage national product catalogs while financial entities focus on data protection and regulatory compliance. Its intuitive interface, flexible features, and robust tools make it valuable across sectors, though enhancements in data integration and human workflow are being sought.

What are the most important features?

Data discovery: Facilitates identifying and understanding data sources.
Data profiling: Analyzes old databases for data quality.
Data and platform masking: Ensures data protection.
Salesforce integration: Seamless connectivity with Salesforce.
Mastering data: Centralizing and standardizing data.
UI intuitiveness: User-friendly interface.
Feature map flexibility: Adapts to user needs.
Business glossary creation: Defines business terms.
Data lineage: Tracks data flow and transformations.
Automation: Streamlines data processes.
Enterprise data cataloging: Organizes extensive data assets.
Scalability: Supports expanding data requirements.
Easy setup: Quick deployment process.
Bulk upload: Efficiently handles large data volumes.
Customizable data management: Tailors data solutions.
Real-time data streaming: Manages live data streams.
Integration with Hadoop and NoSQL: Connects with big data platforms.

What benefits and ROI should be considered?

Regulatory compliance: Ensures adherence to regulations.
Data protection: Safeguards sensitive information.
Enhanced data quality: Improves accuracy and reliability.
Centralized data: Consolidates data for better management.
Process automation: Reduces manual tasks and errors.

Banks and financial institutions use IDMC for data masking, transformation, and compliance, while health sector organizations leverage it for national product catalogs. Industry applications focus on automating business processes, centralizing data, and managing data catalogs to meet regulatory demands and ensure data protection.

WhereScape is data warehouse software that automates the Data Warehouse lifecycle. From implementation to maintenance, WhereScape will ensure your data warehouse projects are completed up to 5x faster than manual coding.

Sample Customers

The Travel Company, Carbonite

British American Tobacco, Cornell University, Allianz Benelux, Finnair, Solarwinds and many more.

Buyer's Guide

Informatica Intelligent Data Management Cloud (IDMC) vs. WhereScape RED

January 2025

Free Report: Informatica Intelligent Data Management Cloud (IDMC) vs. WhereScape RED

Find out what your peers are saying about Informatica Intelligent Data Management Cloud (IDMC) vs. WhereScape RED and other solutions. Updated: January 2025.

DOWNLOAD NOW

831,265 professionals have used our research since 2012.

See our Informatica Intelligent Data Management Cloud (IDMC) vs. WhereScape RED report.

See our list of best Data Integration vendors and best Cloud Data Integration vendors.

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.