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

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.7
Number of Reviews
215
Ranking in other categories
Data Integration (1st), Data Quality (1st), Business Process Management (BPM) (6th), Business-to-Business Middleware (2nd), API Management (7th), Cloud Data Integration (3rd), Data Governance (3rd), Test Data Management (2nd), 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

RC
Contractor at Sanlam
Cloud data catalog has streamlined lineage and quality while leaving more automation to improve
I have not explored IDMC's automation capabilities driven by AI and metadata too much at the moment, but it is on the cards. We are basically creating the foundation, as the whole migration has taken place recently and it is still early days. I think Informatica Intelligent Data Management Cloud (IDMC) is evolving, and as the vendors move forward, they pick up new concepts from each other. I have seen that products leapfrog each other, and from my experience over the years, the big players tend to copy features or add enhancements based on industry trends. I feel whatever the tool does not have now, there is a feedback loop allowing us to request new features, and we continually ask for different ways to do things as we have a pipeline into the product management team. It is difficult to say what additional features I would prefer to see in the next release of IDMC. I would appreciate more automation on the lineage front, with more AI to seamlessly join independent sources and create seamless lineage between different technologies, such as from file into database A into a different database and landing up in a reporting system such as Cognos, Qlik, Qlik Sense, QlikView, or Power BI.
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 solution scales well."
"It is a highly scalable solution."
"Replication allows us to fully replicate all objects from Shop Floor Data Collection (SFDC) to in-house/on-premises database in one job."
"I think that it's a good solution...It is stable because we have the experience to deploy this solution."
"We've used the solution for quite some time, so in our organization, the product is pretty mature."
"I particularly value data replication and data sync jobs."
"I give the stability a ten out of ten."
"The most valuable features are the structure masking and platform masking."
"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

"The high price of the product is an area of concern where improvements are required."
"Connectivity could be improved, it can be a little slow."
"Informatica Enterprise Data Catalog is hard to set up, so this is an area for improvement, e.g. it would be good if they make it easier to set up, because the project was made 80% of the time of the setup."
"They have too many diversified products. If you don't know Informatica, it's very confusing and feels very idiotic."
"There may be some types of limitations with the performance."
"Needs to implement the new workflow with simple steps and a quick visualization with a 360 view of the data."
"It could be improved by including a buffer that saves data when there is a connectivity issue."
"There are various areas for improvement in IDMC. Enhancements on the UI front, such as multiple templates and improved grid views, would be beneficial."
"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 an expensive solution."
"The price is comparable."
"My understanding is that Informatica is quite expensive compare to other tools that are available in the market."
"Pricing is determined by the number of licensed users as well as the number of Core CPUs."
"I rate the licensing cost of Informatica MDM a five out of ten."
"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 very expensive"
"We are quite happy with the licensing model."
"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.
908,858 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
12%
Manufacturing Company
10%
Construction Company
9%
Outsourcing Company
6%
No data available
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business51
Midsize Enterprise27
Large Enterprise155
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 Informatica, Microsoft, Palantir and others in Data Integration. Updated: July 2026.
908,858 professionals have used our research since 2012.