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

14,140 Views
10,140 Comparison Views

93% willing to recommend

WhereScape RED

Read 15 WhereScape RED reviews

1,879 Views
1,283 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: November 2024).

Buyer's Guide

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

November 2024

Download the complete report

Helped 824,067 peers since 2012

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) (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) (2nd), Data Masking (2nd), Metadata Management (1st), Test Data Management Services (4th), Product Information Management (PIM) (1st), Data Observability (2nd)

WhereScape RED

Ranking in Data Integration

46th

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

reviewer1618884

BI Analyst DW Architect at a mining and metals company with 10,001+ employees

Quick to set up, flexible, and stable

The scheduling part I don't like due to the fact that it allows you to schedule as a parent and child and other things, however, the error trackability has to be a little more user-friendly. It's also not user-friendly in the sense that it loads all the jobs and there are not enough filters so that it doesn't need to load everything. If the job fails, you don't get any type of alert or email. It would be ideal if there was some sort of automated alert message. Technical support isn't the best. It would be ideal if we understood how to do it in a card exception regarding exclusion, where the card is captured separately rather than filling the whole process on the data inbound side. Certain workloads like this are organized in such a way where you seem to be doubling the work as opposed to streamlining the process.

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

"The fuzzy matching capability is a great feature."

"The most valuable feature of Informatica MDM is hierarchy management. It's not something that's typically available and effective within ERPs."

"The solution's scalability is high."

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

"The scalability is very high."

"It provides all the typical MDM capabilities like deduplication and machine survivorship."

"The most valuable features of Informatica Cloud Data Integration for our clients are the AI capabilities within Informatica Intelligent Cloud Services."

"The solution's most valuable features are its data quality, match-merge engine, and CLAIRE AI engine, which helps with AI automation."

More Informatica Intelligent Data Management Cloud (IDMC) pros

"I like the data vault implementations."

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

"WhereScape is really helpful in terms of architecture data. Everything is one of automation. Two people can do thousands of tables in one day or two. It saves a lot of time."

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

"Data transformations and rollups are easy to accomplish."

"WhereScape RED has improved our business's ability to generate needed reporting without requiring a large team of developers to manually code all of the necessary plumbing."

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

"I found the initial setup very easy."

More WhereScape RED pros

Cons

"I have encountered some issues using the substitution, which is one of the techniques of data masking."

"The solution is quite expensive."

"Informatica Cloud Data Integration can improve by being more user-friendly. When you're working with the solution a lot of technical knowledge is required. It's not a solution that anyone can use properly, you need knowledge of what's happening at the back end, such as SQL. When you get stuck, you need to look into your logic. For other tools, such as Dell Boomi, anyone can use them."

"Interoperability is one area where EDC has room for improvement. It was challenging when the faculty took over the data world and had specific vendors they wanted to use, and some were not particularly open platforms."

"Informatica Axon needs more integration connectors so that it can connect to systems and different kinds of datasets."

"Connectivity could be improved, it can be a little slow."

"Pre-sales technical support is much better than post-sales technical support."

"I have received feedback from certain teams and there is a steep learning curve to use this solution."

More Informatica Intelligent Data Management Cloud (IDMC) cons

"Customization could be better."

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

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

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

"Technical support isn't the best."

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

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

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

More WhereScape RED cons

Pricing and Cost Advice

"The price is neither too high nor too low."

"Informatica MDM is a costly solution because it comes as a bundle. They are also globally positioning themselves and are definitely working on very upgraded technologies. If someone wanted to do it on the cloud, they have a lot of flexibility because they upgrade themselves according to the current needs. It definitely comes with a lot of features and that's the reason why it's costly. The licensing cost should be approximately one million dollars. It's about four to five times that of other vendors."

"I rate the product's pricing a nine on a scale of one to ten, where one is low price, and ten is high price."

"Informatica Axon is a costly solution. I rate Informatica Axon a four out of ten for its pricing."

"The product is highly-priced."

"Informatica Axon is expensive."

"You pay for this solution based on IPUs, Informatica Processing Units. This depends on how much data you process and how much memory you consume from the cloud provider, and you pay as you go."

"Informatica MDM's price could be lower."

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

"ROI is at least 10 times."

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

"Our company purchased a corporate unlimited license."

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

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

824,067 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

Manufacturing 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 21% of the time

Azure Data Factory vs WhereScape RED

Compared 19% of the time

SSIS vs WhereScape RED

Compared 10% of the time

Matillion ETL vs WhereScape RED

Compared 9% of the time

ibi Open Data Hub for Mainframe vs WhereScape RED

Compared 4% of the time

More WhereScape RED Competitors

Product Reports

Buyer's Guide

Informatica Intelligent Data Management Cloud (IDMC)

December 2024

Informatica Intelligent Data Management Cloud (IDMC) report

Download Informatica Intelligent Data Management Cloud (IDMC) product report

Buyer's Guide

WhereScape RED

November 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

November 2024

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: November 2024.

DOWNLOAD NOW

824,067 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.