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

Why PeerSpot?

Informatica and Oracle are both solutions in the Data Integration category. Additionally, 92% of Informatica users are willing to recommend the solution, compared to 100% of Oracle users who would recommend it.

Informatica Intelligent Dat...

Read 215 Informatica Intelligent Data Management Cloud (IDMC) reviews

50,984 Views
14,785 Comparison Views

92% willing to recommend

Oracle Warehouse Builder [EOL]

Read 1 Oracle Warehouse Builder [EOL] review

100% willing to recommend

Informatica Intelligent Dat...

Oracle Warehouse Builder [EOL]

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Mar 15, 2026

Informatica Intelligent Data Management Cloud (IDMC) and Oracle Warehouse Builder compete in the data management space. Informatica IDMC tends to have the upper hand as it provides modern features and flexibility that align with current business needs.

Features: Informatica IDMC offers an integrated suite for data integration, quality, and governance within a cloud-native environment. It supports AI-driven insights and big data applications. Oracle Warehouse Builder historically provided a robust framework supporting ETL processes and data modeling, but it lacks the advanced and flexible capabilities featured in Informatica IDMC that meet today's technological demands.

Ease of Deployment and Customer Service: Informatica IDMC provides seamless deployment using a cloud-based model, which simplifies setup and scaling, coupled with consistent customer support. Oracle Warehouse Builder, which was an on-premises solution until it reached end-of-life, required extensive configuration and maintenance efforts, affecting ease of use and support efficiency.

Pricing and ROI: Informatica IDMC generally requires a lower initial setup cost due to its SaaS model, promoting better ROI through scalable operations and reduced infrastructure expenses. Conversely, Oracle Warehouse Builder involved significant upfront investment in hardware and software, offering a less favorable ROI over time, especially after its discontinuation.

To learn more, read our detailed Data Integration Report (Updated: October 2026).

Buyer's Guide

Data Integration

October 2026

Download the complete report

Helped 920,929 peers since 2012

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) (9th), Business-to-Business Middleware (4th), API Management (18th), Cloud Data Integration (4th), Data Governance (3rd), Test Data Management (4th), Cloud Master Data Management (MDM) (1st), Data Management Platforms (DMP) (2nd), Data Masking (2nd), Metadata Management (2nd), Integration Platform as a Service (iPaaS) (5th), Test Data Management Services (5th), Product Information Management (PIM) (1st), Data Observability (2nd), AI Data Analysis (3rd)

Oracle Warehouse Builder [EOL]

Average Rating

7.0

Number of Reviews

Ranking in other categories

No ranking in other categories

Featured Reviews

Raymond Croxford

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.

Read full review

it_user1350675

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

Read full review

Quotes from Members

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

Pros

"Some of Axon's valuable features include creating your business glossaries, importing DQ rules, and creating change management."

"The serverless capability and the packaging application of the solution are valuable."

"Customer service and technical support are excellent."

"The valuable features include ease of use and quick response time with Informatica Intelligent Cloud Services; the performance and response time are notably faster."

"Performance and flexibility-wise, they're very user-friendly."

"The tool does give a good ROI."

"The Mapping Designer allows for declarative ETL development (visual scripting) that leverages a wide array of different transformations."

"Informatica Cloud Data Integration is good overall."

More Informatica Intelligent Data Management Cloud (IDMC) pros

"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 initial setup is complex. It isn't easy because it needs a separate server of its own."

"Informatica MDM could improve the interdependency with integration. The solution sometimes becomes a bit difficult to change considering a lot of interdependency with the integration. There can be some improvement in the workflows and they can introduce more artificial intelligence."

"The cloud version of the Informatica, it's a very substandard product. They might say it's enterprise-ready but it's not at all ready. They need to add more features, such as improved data replication features. If you look at other tools, such as Matillion they are now cloud-native and flexible. Additionally, Informatica Cloud Data Integration should have a good migration strategy from Informatica PowerCenter to Informatica Cloud Data Integration."

"I have received feedback from certain teams and there is a steep learning curve to use this solution."

"We'd like to see the microservices, which don't run yet because the solution is not yet fully cloud-based."

"Informatica's issue is the licensing."

"Informatica MDM could be improved by adding drag and drop options, business data insights, and visualization reporting."

"An area for improvement would be that the pricing model is not very visible, which makes it hard to understand how much things will cost."

More Informatica Intelligent Data Management Cloud (IDMC) cons

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

"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

"The pricing structure is good, but having to pay for extra drivers to be used in an ICS environment makes me a little nervous."

"The price is high, but the competitors are even higher, like Collibra."

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

"A yearly subscription is paid based on the number of people using the solution. Price-wise, it falls under the medium range since it is neither very costly nor too cheap."

"Its pricing model can be improved."

"It's an expensive solution."

"Informatica MDM is very expensive. Apart from licensing fees, they have broken down their products into multiple products, and they charge for each and every product. If the data is huge, they charge for the data. At times, we have to use third party services for data cleaning, and they charge for that as well."

"Informatica MDM is a costly solution because it comes as a bundle. They are also globally positioning themselves and are definitely working on very upgraded technologies. If someone wanted to do it on the cloud, they have a lot of flexibility because they upgrade themselves according to the current needs. It definitely comes with a lot of features and that's the reason why it's costly. The licensing cost should be approximately one million dollars. It's about four to five times that of other vendors."

More Informatica Intelligent Data Management Cloud (IDMC) pricing and cost advice

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

See which vendors are best for you

Use our free recommendation engine to learn which Data Integration solutions are best for your needs.

See recommendations

920,929 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

11%

Manufacturing Company

10%

Outsourcing Company

Construction Company

No data available

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	51
Midsize Enterprise	27
Large Enterprise	155

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

See all answers

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

See all answers

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

See all answers

Ask a question

Earn 20 points

Comparisons

Informatica PowerCenter vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 2% of the time

Collibra Platform vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 2% of the time

Semarchy xDM vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 2% of the time

Qlik Talend Cloud vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 1% of the time

SnapLogic vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 1% of the time

More Informatica Intelligent Data Management Cloud (IDMC) Competitors

No data available

Product Reports

Buyer's Guide

Informatica Intelligent Data Management Cloud (IDMC)

October 2026

Informatica Intelligent Data Management Cloud (IDMC) report

Download Informatica Intelligent Data Management Cloud (IDMC) product report

Buyer's Guide

Data Integration

October 2026

Download Oracle Warehouse Builder [EOL] product report

Also Known As

ActiveVOS, Active Endpoints, Address Verification, Persistent Data Masking

Warehouse Builder, OWB

Overview

Informatica Intelligent Data Management Cloud (IDMC) offers seamless integration of master data management, data quality, and data integration with a cloud-native architecture supporting multiple data management styles, optimizing data governance through metadata management.

IDMC enhances data synchronization and mapping tasks, utilizing a broad range of connectors to interact efficiently with data sources. Its precise address validation via AddressDoctor and intuitive navigation bolster user empowerment, delivering agility, scalability, and security in data governance. Despite its strengths, areas like ease of use, SAP integration, and reporting could benefit from enhancements. Connectivity issues and workflow complexities are noted, needing improvements in performance, support, and licensing cost. Users demand expanded ETL capabilities, real-time processing, and broader data source support to address growing data needs.

What are the key features of IDMC?

Integration Capabilities: Ensures seamless connectivity between on-premise and cloud environments.
Master Data Management: Centralizes and streamlines data processes for enhanced quality.
Data Quality: Employs tools for cleansing and standardizing data accuracy.
Address Validation: Features AddressDoctor for precise address verification.
Real-Time Processing: Supports real-time data handling for critical operations.
Connectivity Options: Offers a wide array of connectors for easy data source interaction.

What benefits and ROI should users consider?

Scalability: Cloud-native design boosts system agility, adapting to data volume changes.
Security: Enhances data protection with robust encryption and compliance measures.
Efficiency: Automates processes to reduce manual effort and errors.
Flexibility: Supports diverse data management styles, offering adaptability to business changes.
Governance: Empowers effective data governance through comprehensive metadata management.

In industries such as banking, healthcare, and telecom, IDMC is implemented for data integration, cloud migration, and enhancing data quality. Its capabilities are crucial for metadata management, lineage tracking, and real-time processing, ensuring high data quality and streamlined operations.

Informatica

Oracle Warehouse Builder is a single, comprehensive tool for all aspects of data integration. Warehouse Builder leverages Oracle Database to transform data into high-quality information. It provides data quality, data auditing, fully integrated relational and dimensional modeling, and full lifecycle management of data and metadata. Warehouse Builder enables you to create data warehouses, migrate data from legacy systems, consolidate data from disparate data sources, clean and transform data to provide quality information, and manage corporate metadata.

Oracle

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: October 2026.

DOWNLOAD NOW

920,929 professionals have used our research since 2012.

See our list of best Data Integration vendors and best Cloud Data Integration vendors.

We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.