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 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

Informatica Intelligent Dat...
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
185
Ranking in other categories
Data Integration (3rd), Data Quality (1st), Business Process Management (BPM) (10th), Business-to-Business Middleware (5th), 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 (1st), Metadata Management (1st), Test Data Management Services (3rd), Product Information Management (PIM) (1st), Data Observability (2nd)
Oracle Warehouse Builder [EOL]
Average Rating
7.0
Number of Reviews
1
Ranking in other categories
No ranking in other categories
 

Featured Reviews

SaurabhGaonshindhe - PeerSpot reviewer
Modular structure and AI features stream new reporting processes
One of my clients has a requirement; they want to integrate metadata into the process, which means, for example, if I just want to implement a new field into my database, that field needs to be reflected throughout, let's say, 200 mappings. This highlights the need for a data-driven approach. My experience with technical support from Informatica is quite interesting; I would rate it as nine out of ten for Informatica PowerCenter kind of products or the Informatica integration products, because my team can do some hands-on using their free licenses or one-month kind of products. However, for products Master Data Management or related to MDM or Data Governance, there is no way by which we can directly practice, and my team struggles at that point.
SV
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 MDM has data quality, mastering the data's capability."
"Data integration is the most valuable feature. The ability to connect to any of the sources and enterprise applications makes our lives easier."
"The product's most valuable feature is the ability to select the data flow and lineage."
"The serverless capability and the packaging application of the solution are valuable."
"The solution's initial setup is quite straightforward."
"The most valuable feature is the building of mockups and tasks."
"The solution provides increased efficiency while still being user-friendly and easy to operate."
"The best thing about Informatica Axon is that it integrates with the Electronic Data Capture and the Axon system."
"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 main issue probably has nothing to do with end users, but installation can definitely be simplified."
"I think everything related to the APIs and the manageability of the APIs in Informatica MDM are areas where improvements are required."
"The GUI needs to be a little more user-friendly and appealing."
"The model is somewhat flexible. There are certain aspects of the model that are not as flexible as we would like. It doesn't do certain things to a great level of depth. So, in situations where we want to drill in to do something specific, we have to essentially copy that data into our own structures in order to add that additional layer of flexibility."
"Though EDC has maximum coverage, a few things were not available to scan, but I think EDC is evolving to address this issue."
"One area that needs to improve is the user experience because it is very complex. The trial version is very complex so it's not easy to start using the program immediately. You must study the rules first."
"Informatica's issue is the licensing. Right now, there are a lot of new gen MDMs that are offering a lot in a single licensing model."
"If I want to scan the metadata from the data lineage or the Python code, such areas can get tedious in the tool."
"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

"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."
"It's a costly solution"
"The price is very high and has become a big concern for our customers who require the solution in order for their business to function smoothly."
"I'm not sure about the most recent pricing trends, but I don't believe it's significantly different from PowerCenter. I believe it is nearly the same."
"It's a very expensive solution"
"Cost-wise, I think it is on the higher side, and that is why we are looking for some better options. Licensing costs are huge compared to other players in the market and for my company."
"We saw an ROI. We have been able to get data from various sources and consolidate it into a data lake, which is helping us in data analytics."
"My understanding is that Informatica is quite expensive compare to other tools that are available in the market."
"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.
869,832 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
15%
Manufacturing Company
10%
Computer Software Company
10%
Insurance Company
7%
No data available
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business42
Midsize Enterprise24
Large Enterprise134
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, 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
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, Talend and others in Data Integration. Updated: September 2025.
869,832 professionals have used our research since 2012.