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 Summary
 

Categories and Ranking

Informatica Intelligent Dat...
Ranking in Data Integration
3rd
Average Rating
8.0
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) (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
49th
Average Rating
8.2
Number of Reviews
15
Ranking in other categories
No ranking in other categories
 

Featured Reviews

Raj Sethupathi - PeerSpot reviewer
Jun 13, 2024
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.
SM
Jul 9, 2021
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.

Quotes from Members

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

Pros

"The solution's scalability is high."
"It's helpful in integration, and it can be moved around in SharePoint. So, from the SharePoint View, data integration and reporting, it help a lot in that way."
"It is a very stable solution...It is a scalable solution."
"The staging and hierarchical features are the most valuable."
"The product is stable."
"It is very useful for testing purposes and designing mappings for small projects. If you go for IDQ in the mapping itself, you can see the data. You can then correct it, and test it so easily. It is working fine. It is also stable, scalable, and easy to deploy."
"The most valuable feature of Informatica Axon is features, interfaces, and data mapping. It represents clusters nicely."
"One of the most valuable features is that I don't need to buy a subscription for any functionality. With Informatica Cloud Data Management, I have all the functionality and features available. If I need to make an integration, I can go to that integration service. If I need to mask, provide, or clean some information, I can easily just pick up that feature and use it. It's very simple, and I have all the functions and capabilities I need to work with data."
"I found the initial setup very easy."
"The most valuable feature is the metadata generated code."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"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."
"It has a built-in automatic scheduling environment."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"Data transformations and rollups are easy to accomplish."
 

Cons

"The initial setup was not very straightforward. Not complex, but not very simple either."
"They have too many diversified products. If you don't know Informatica, it's very confusing and feels very idiotic."
"The main issue preventing Brazilian companies from migrating to Informatica Cloud Data Integration from on-prem is the price."
"It could be improved by including a buffer that saves data when there is a connectivity issue."
"Informatica MDM can improve the data catalog and data marketplace."
"A general improvement in icons and the virtual interface would be good."
"The price modeling could be more flexible."
"There's no direct way to connect to Amazon APIs from Informatica Cloud."
"Jobs cannot be deleted via the deployment package. When deploying from dev to QA or production, a job has to be retired. The job has to be manually removed from the target environment."
"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."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"Technical support isn't the best."
"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."
"No support for change data capture or delta detection - that must be custom coded ."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
 

Pricing and Cost Advice

"The solution is very expensive."
"Informatica Cloud Data Integration is famously known for its high price. The vendor targets large enterprises, and not medium or small companies. These large companies, and organizations, handle large amounts of data. If you go into any large bank, such as American or Canadian banks, these banks use this solution because it is more reliable, secure, and has more functionality."
"You can purchase licenses for this solution at different intervals. For example, annually or every three years. They recently changed their terms for licensing and now it is more flexible."
"Informatica MDM recently changed its pricing model. It's usage-based but I don't have much insight into the current pricing."
"The platform has a premium cost. I rate the pricing as seven out of ten."
"The product is not very pocket-friendly for small and medium-sized businesses, and it is understandable because of the kind of features the tool gives."
"We got a 50% discount."
"On a scale from one to ten, where one is cheap and ten is expensive, I rate the solution's pricing nine and a half out of ten."
"Factor in the price of specialized consulting who know this product. They're hard to find and expensive."
"Speed to market of a warehouse solution at a relatively inexpensive price point."
"ROI is at least 10 times."
"Our company purchased a corporate unlimited license."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
814,649 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
13%
Manufacturing Company
10%
Government
6%
Financial Services Firm
17%
Government
10%
Insurance Company
9%
Manufacturing Company
9%
 

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
 

Learn More

Video not 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: October 2024.
814,649 professionals have used our research since 2012.