No more typing reviews! Try our Samantha, our new voice AI agent.

Oracle Data Integrator Cloud Service vs WhereScape RED comparison

 

Comparison Buyer's Guide

Executive Summary

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

Oracle Data Integrator Clou...
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
7
Ranking in other categories
Cloud Data Integration (27th)
WhereScape RED
Average Rating
8.2
Reviews Sentiment
7.2
Number of Reviews
15
Ranking in other categories
Data Integration (45th)
 

Featured Reviews

AD
Senior Solution Architect at a financial services firm with 10,001+ employees
A well-established product that meets all our specifications in terms of usability
In the initial stage when we went with Data Integrator Cloud Service it was primarily the nativity factor that was key for us. Having a single vendor supporting the entire suite of applications, and the ability to configure activities and direct integration with various other Oracle products, were the main attractive features within ODI. This is a well-established product that's good to have if you hold an Oracle suite of applications. It meets all our specifications in terms of usability.
reviewer1618884 - PeerSpot reviewer
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.

Quotes from Members

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

Pros

"It's on the cloud, so it's scalable and quite easy to work with."
"This is a well-established product that's good to have if you hold an Oracle suite of applications."
"The most valuable thing to me is its simplicity. A person with zero knowledge can also develop the integration without having extensive technology knowledgebase. They can also work on creating their own integration."
"Oracle integration cloud has got the adapters for all their products, which makes the integration a little faster and makes it easier to implement the integration quickly."
"Oracle Data Integrator helps us build tables and data marts and allows us to schedule them daily, for nearly real-time data warehousing."
"The data is stored in the cloud, making it easy to download data simultaneously into multiple smaller servers, effectively downsizing the process."
"It's on the cloud, so it's scalable and quite easy to work with."
"Oracle integration cloud has got the adapters for all their products, which makes integration faster."
"I like the data vault implementations, the ELT feature, and the automatic generation of logic as it saves time."
"I like the data vault implementations."
"The tool supports multiple target update methods."
"Support is absolutely excellent, efficient, and timely."
"Embedding of standards and design patterns into the tool yields substantial quality and consistency gains."
"We are now 2.5 years into using WhereScape and all warehouse code we have converted from our old tool to WhereScape has performed faster; anywhere from 20-80% reduction in processing time."
"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."
"ROI has been huge; we have a very large healthcare data warehouse and the amount of ETL code we have produced and continue to maintain would not be possible without a tool as cost effective as RED."
 

Cons

"It can be made much easier for users. They should be allowed to easily monitor the data extraction and flow, allowing them to observe real-time data flow within the software, making the process straightforward."
"This is an expensive solution compared to other products on the market."
"The solution is expensive."
"It's lacking a lot of mapping features that Oracle OSB and SOA have. It needs to evolve a lot."
"I've found technical support not very effective. They should work to improve their services."
"The solution could be improved when it comes to bulk uploading; there are problems with it when you hit the upper limit."
"Bulk uploading can be a problem when you hit the upper limit."
"It's lacking a lot of mapping features that Oracle OSB and SOA have. It needs to evolve a lot."
"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."
"Customization could be better. When you need to modify or write some custom code, it can get a little messy."
"Data discovery would be more powerful with machine learning features."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"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)."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
 

Pricing and Cost Advice

"The price is competitive compared to Boomi which is much higher."
"Our company purchased a corporate unlimited license."
"Speed to market of a warehouse solution at a relatively inexpensive price point."
"ROI is at least 10 times."
"Factor in the price of specialized consulting who know this product. They're hard to find and expensive."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
885,376 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
No data available
Healthcare Company
10%
Insurance Company
8%
Government
7%
Financial Services Firm
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business3
Large Enterprise4
By reviewers
Company SizeCount
Small Business6
Midsize Enterprise4
Large Enterprise11
 

Overview

 

Sample Customers

Amplifon
British American Tobacco, Cornell University, Allianz Benelux, Finnair, Solarwinds and many more.
Find out what your peers are saying about Oracle Data Integrator Cloud Service vs. WhereScape RED and other solutions. Updated: March 2026.
885,376 professionals have used our research since 2012.