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

Informatica Intelligent Data Management Cloud (IDMC) vs Oracle Warehouse Builder [EOL] comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 11, 2025

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...
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
214
Ranking in other categories
Data Integration (2nd), Data Quality (1st), Business Process Management (BPM) (6th), Business-to-Business Middleware (2nd), API Management (6th), Cloud Data Integration (3rd), Data Governance (3rd), Test Data Management (3rd), Cloud Master Data Management (MDM) (1st), Data Management Platforms (DMP) (2nd), Data Masking (2nd), Metadata Management (2nd), Integration Platform as a Service (iPaaS) (3rd), Test Data Management Services (3rd), Product Information Management (PIM) (1st), Data Observability (2nd), AI Data Analysis (1st)
Oracle Warehouse Builder [EOL]
Average Rating
7.0
Number of Reviews
1
Ranking in other categories
No ranking in other categories
 

Featured Reviews

Divya-Raj - PeerSpot reviewer
Sr. Consultant cum Assistant Manager & Offshore Lead at Deloitte
Handles large data volumes effectively and offers competitive pricing
There is a lot of improvement required, as we still face some cache issues most of the time, which is a challenge that we expect to see resolved in the future. Additionally, there is some limitation when we are working with a tool, especially regarding In and Out parameters, and I feel that this aspect should be improved going ahead. We face issues with the API side, as Cloud Application Integration cannot handle large volumes; according to the API page, there is a limitation of 500 records or 500 MB. The AI integrated into the Informatica Intelligent Cloud Services solution is called Application Integration, where we still face challenges when dealing with huge volumes, as previously explained.
SV
Managing Director Product & Project at Synvoll GbR
Can be enhanced with extra functionality, but no further support will be given for the solution
If the administrative setup was perfect, the use of Oracle Warehouse Builder with the graphical user interface including a wide range of supporting tool functionality could guarantee a fast and straightforward development and test process. In most cases, Oracle Warehouse Builder is flexible enough to fit for complex ETL processes and can be enhanced with extra functionality based on running a Java environment and database backbone structures. OpenAPI supported me integrating Oracle Warehouse Builder with DevOps solutions like versioning (CVS, Subversion, and Git), ticket systems (Bugzilla and Jira), and test automatization (HPQC) as well as with professional ALM solutions (HP ALM and IKAN ALM).

Quotes from Members

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

Pros

"Informatica Cloud Data Integration is stable."
"The process of using the tool's scalability option is well documented."
"The staging and hierarchical features are the most valuable."
"Informatica MDM has a defined data model we can customize with user and developer options."
"Whether we need data cleansing or data mastering, we get it all in one platform."
"The solution has the best feature for parameterization."
"The support is very good."
"The most valuable feature of Informatica MDM is hierarchy management. It's not something that's typically available and effective within ERPs."
"OpenAPI supported me integrating Oracle Warehouse Builder with DevOps solutions like versioning (CVS, Subversion, and Git), ticket systems (Bugzilla and Jira), and test automatization (HPQC) as well as with professional ALM solutions (HP ALM and IKAN ALM)."
 

Cons

"The integration process is not easy."
"The high price of the product is an area of concern where improvements are required."
"In the on-premises version, features like web service consumer and web service provider are available, but these functionalities are currently unavailable in the cloud edition."
"The initial setup was not very straightforward. Not complex, but not very simple either."
"The on-prem solution is harder to learn than the cloud-based versions."
"The integration could be a bit better. The process is something new."
"Cost-wise, it could be better."
"I definitely will not recommend Informatica Cloud Data Quality because it's very hard to manage the licensing model and the price is very high."
"Unfortunately, a next release of Oracle Warehouse Builder will not happen but a wide range of customers still use the available features together with the current Oracle 11g or 12c database environments."
 

Pricing and Cost Advice

"It is expensive. That's probably the biggest drawback. The business has heartache paying the license, but that's mainly because they don't realize what value it brings. The key thing about the MDM solution is that it is in the backend, and no one sees what it is actually doing. You don't know it is a problem until it is not there."
"My understanding is that Informatica is quite expensive compare to other tools that are available in the market."
"In terms of the licensing for Informatica Intelligent Cloud Services, we had the option of paying based on the number of users and paying based on the volume of data, and we went with the data volume licensing option. Informatica Intelligent Cloud Services isn't as expensive as CIG. The pricing for it is okay, so I'm rating it a four out of five in terms of pricing. We did use the email verification and address validation services which weren't part of the contract, so we had to pay additional fees for those services."
"I have heard from customers that the product comes with a huge license cost."
"The price of Informatica Cloud Data Integration could be reduced."
"I rate Informatica MDM's price a six on a scale of one to ten, where one is a low price, and ten is a high price."
"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."
"The product is highly-priced."
"Besides Pentaho, Oracle Warehouse Builder is a really low budget solution for those who own any kind of Oracle database license. From this point of view, it is often an unnecessary waste of time to evaluate other (pricey) solutions. Mostly, Oracle Warehouse Builder was the preferred solution because it did not cost extra for licenses when owning an Oracle database."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
881,733 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
14%
Manufacturing Company
10%
Computer Software Company
8%
Retailer
7%
No data available
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business51
Midsize Enterprise27
Large Enterprise153
No data available
 

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, Address Verification, Persistent Data Masking
Warehouse Builder, OWB
 

Overview

 

Sample Customers

The Travel Company, Carbonite
Editores Nacionales Gršficos Editogran SA, ADMIRAL Casinos & Entertainment AG, Aseguradora del Sur CA, Sascar, Banca Transilvania, UL, RBS
Find out what your peers are saying about Microsoft, Informatica, IBM and others in Data Integration. Updated: January 2026.
881,733 professionals have used our research since 2012.