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 Mar 15, 2026

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) (5th), 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) (4th), 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

"The OAuth feature is the most valuable feature for authentication."
"The solution is applicable for both technical and business users."
"Data synchronization tasks."
"Mapping designer seems to be easier to use even when compared with PowerCenter which is a great improvement."
"The application integration will give you more flexibility when dealing with APIs."
"We reduced product data setup time from 1.5 hours to 30 minutes."
"With my firm, our use of Informatica Cloud is primarily to implement a set of financial integrations from various accounting systems into a Salesforce environment, and by leveraging Informatica Cloud Mapping Designer, we were able to create sets of reusable templates that were source agnostic, making supporting the integration for hundreds of customers feasible with just a small team of integration specialists."
"It can automatically connect or associate business terms with various options, providing flexibility beyond general capabilities."
"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)."
"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."
 

Cons

"Pre-sales technical support is much better than post-sales technical support."
"Informatica's support understands the solution, but they lack the experience we need for our use case. That was one thing that we prioritized when we started searching for this kind of solution."
"There's certainly room for improvement. One crucial area is generating detailed reports on file statuses. Presently, this is represented visually, often as graphs or charts. Such reporting could offer comprehensive insights into the areas that demand attention and further scrutiny."
"The GUI needs to be a little more user-friendly and appealing."
"The stability and the integration of the solution have room for improvement."
"Some functionalities can be a challenge in the cloud."
"The tool is quite good overall, but sometimes the number of modules can be overwhelming. If the development interface could be optimized to have fewer modules, it would be greatly beneficial."
"Certain shortcomings in the product's UI make it an area where improvements are required."
"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."
"According to the features above the Oracle Warehouse Builder was long time promised to be enhanced by a native versioning integration solution, but Oracle never got forward on this and preferred to force users switching to the paid solution Oracle Data Integrator, which urges a lot of work and challenges on switching from Oracle Warehouse Builder."
 

Pricing and Cost Advice

"It's pretty high for us. It's more on the higher side, like low to middle high."
"The solution's pricing model is easy, but it is very expensive."
"The solution is very expensive."
"The licenses attached to the solution are highly priced."
"I rate the product's pricing a five on a scale of one to ten, where one is cheap and ten is expensive."
"Comparatively, their prices are a little bit too high."
"Our customers sometimes are able to negotiate a much better price for Informatica Cloud Data Integration based on their relationship with the vendor."
"I have no idea what the price actually is. It is probably not going to be the cheapest, but it is a pretty stable and robust platform from the backend standpoint."
"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.
884,933 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
14%
Manufacturing Company
11%
Computer Software Company
7%
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, Qlik and others in Data Integration. Updated: February 2026.
884,933 professionals have used our research since 2012.