IBM Db2 Warehouse vs Oracle Database Appliance comparison

IBM and Oracle are both solutions in the Data Warehouse category. IBM is ranked #11 with an average rating of 7.6, while Oracle is ranked #8 with an average rating of 7.8. IBM holds a 1.9% mindshare in Data Warehouse, compared to Oracle’s 5.4% mindshare. Additionally, 77% of IBM users are willing to recommend the solution, compared to 85% of Oracle users who would recommend it.

IBM Db2 Warehouse

Read 10 IBM Db2 Warehouse reviews

1,129 Views
452 Comparison Views

77% willing to recommend

Oracle Database Appliance

Read 43 Oracle Database Appliance reviews

2,277 Views
1,634 Comparison Views

85% willing to recommend

IBM Db2 Warehouse

Oracle Database Appliance

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between IBM Db2 Warehouse and Oracle Database Appliance based on real PeerSpot user reviews.

Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed IBM Db2 Warehouse vs. Oracle Database Appliance Report (Updated: November 2024).

Buyer's Guide

IBM Db2 Warehouse vs. Oracle Database Appliance

November 2024

Download the complete report

Helped 816,406 peers since 2012

Categories and Ranking

IBM Db2 Warehouse

Ranking in Data Warehouse

11th

Average Rating

7.8

Reviews Sentiment

5.3

Number of Reviews

Ranking in other categories

No ranking in other categories

Oracle Database Appliance

Ranking in Data Warehouse

8th

Average Rating

8.0

Reviews Sentiment

6.1

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of November 2024, in the Data Warehouse category, the mindshare of IBM Db2 Warehouse is 1.9%, up from 1.6% compared to the previous year. The mindshare of Oracle Database Appliance is 5.4%, down from 6.5% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Warehouse

Featured Reviews

Josef Kraus

Owner at S.K. Consulting Services GmbH

Useful for ETL process and has good documentation

The tool's most beneficial feature for our data management tasks has been the ETL process. Additionally, we utilized Windows and Linux. IBM Db2 Warehouse's scalability has significantly impacted our data storage capabilities. We needed to order new disks for storage every week within this hosting environment. Additionally, we implemented protection measures for production use. The tools are readily available, and if you're willing to invest in them, you can access a good data warehouse without any issues.

Read full review

AdnanNaseem

Senior Database Administrator at Techlogix

Offers built-in utilities and tools that simplify management

Oracle often releases updated versions of Database Appliance with improvements. However, I think Oracle should focus on further automating database management and IT-related tasks, such as backups. They've made progress with daily database stat automation, which is a good feature. Moreover, every product benefits from new functionality over time. I would like to see a centralized terminal where we can easily manage the database and its components with drag-and-drop functionality instead of relying solely on commands. So, I would like to see a centralized dashboard. Other areas of improvement include customer service and support, and scalability.

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

"I think it scales really well and as long as you take enough time to learn a little bit about it, it works really well."

"The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data."

"The solution is stable."

"It can be mounted on the cloud, which is a huge plus. If the client, for example, starts small with on-premise deployment and then it rapidly needs to grow, we can transfer this to the cloud easily."

"It can scale effectively as long as resources are available."

"Provides good security and reliability."

"The analytics engine is not bad at forecasting predictions."

"Some of the best features are stored procedures, parallelism, and different indexing strategies."

"The database is solid."

"We use the solution for our Java applications."

"Oracle offers ETL with PL/SQL as a programming language for SQL programming, which is majorly used in data engineering."

"The solution is stable. The product is scalable. The technical support is very helpful. The initial setup is straightforward. I consider the product a strong solution for our customers."

"The product’s valuable feature is its capability to pre-configure and pre-install the settings."

"The most valuable feature of the solution is the ability to combine all the data without the need for additional devices."

"The main feature is the management and manageability of the tool. We can create a VM on a laptop within a couple of clicks."

"The most valuable features of the solution revolve around its performance, simplicity, and its installation phase."

More Oracle Database Appliance pros

Cons

"IBM Db2 Warehouse needs to improve its interface."

"The biggest problems we have is when the backup solution is failing or slow and we run out of log space, which has happened probably a couple of times in the last four years."

"There should be more material available for training and training should be free."

"In terms of improvement, IBM Db2 Warehouse should be more scalable."

"Lacks sufficient documentation and particularly in Spanish."

"Responding to support tickets takes a lot of time. It can range from two to four days, even for critical issues."

"There were some initial challenges with IBM Db2 Warehouse about eight months ago when I worked in this environment. When I coordinated with IBM support, they mentioned that the memory was insufficient for our needs. Our business environment required significantly more memory than the previous cluster could provide. Consequently, we have worked closely with on-site IBM technical personnel to address this issue."

"The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting."

More IBM Db2 Warehouse cons

"Sometimes, we cannot upgrade or patch it easily. The performance needs to improve."

"In my opinion only one single command should be used for all ODA models, as it’s confusing."

"It isn't as popular as AWS, GCP, or Azure as it lacks scalability and cloud-native services like containerization."

"The main thing would be to make ODA more affordable, to make it a more economical machine. Also, I would like to see virtualization, so you could implement all of your functions on one machine. Finally, improvement in the speed and performance would be good."

"The setup is a bit complex."

"Virtualization features could also be improved. A web-based GUI would be a good start."

"Oracle Database Appliance is stopping support for the standard edition and only continuing support for the RAC One Node. They did not inform us and we are having problems with our customers. We are not having to change our systems from standard to something else."

"Even though the solution can handle a lot of data, it's just too expensive currently."

More Oracle Database Appliance cons

Pricing and Cost Advice

"In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side."

"The solution's pricing is very high."

"You must pay for the license."

"Compared to Oracle Exadata, Oracle Database Appliance is affordable."

"Oracle Database Appliance is a very expensive solution. If you have opted for the on-premises licenses from Oracle, then you have to pay yearly. If you have opted for the cloud subscriptions offered by Oracle, then you can pay either monthly or yearly."

"Get benefit from the capacity-on-demand features. License your cores according to your licenses."

"I don’t know ODA and alternative system prices. But Oracle the database license is quite expensive and a lot of my customers plan to migrate to open source databases like PostgreSQL."

"In regards to licensing, it is cheaper to maintain for Oracle applications, and it's an all-in-one solution."

"The price of the solution should be less expensive. However, they will increase the price more."

More Oracle Database Appliance pricing and cost advice

See which vendors are best for you

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

See recommendations

816,406 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Educational Organization

59%

Financial Services Firm

Computer Software Company

Insurance Company

Financial Services Firm

29%

Computer Software Company

11%

Government

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about IBM Db2 Warehouse?

The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data.

See all answers

What is your experience regarding pricing and costs for IBM Db2 Warehouse?

Db2 Warehouse or IBM products are pretty expensive. There are cheaper tools on the market. However, if the client is satisfied with paying for the Db2 Warehouse license, especially for cloud-based ...

See all answers

What needs improvement with IBM Db2 Warehouse?

Responding to support tickets takes a lot of time. It can range from two to four days, even for critical issues. The technical support quality is good, but the response time needs improvement.

See all answers

What do you like most about Oracle Database Appliance?

Oracle Database Appliance provides high stability.

See all answers

What is your experience regarding pricing and costs for Oracle Database Appliance?

Oracle solutions are a bit overpriced, especially for small or medium businesses. I would prefer a slightly lower price point.

See all answers

What needs improvement with Oracle Database Appliance?

All improvements for ODA are already applied or enhanced in Exadata. ODA is mainly for small businesses or limited businesses and is used predominantly for database warehouses and not for OLTP data...

See all answers

Comparisons

Oracle Exadata vs IBM Db2 Warehouse

Compared 29% of the time

Snowflake vs IBM Db2 Warehouse

Compared 28% of the time

Teradata vs IBM Db2 Warehouse

Compared 14% of the time

Amazon Redshift vs IBM Db2 Warehouse

Compared 10% of the time

IBM Db2 Warehouse on Cloud vs IBM Db2 Warehouse

Compared 9% of the time

More IBM Db2 Warehouse Competitors

Oracle Exadata vs Oracle Database Appliance

Compared 69% of the time

VMware Tanzu Data Solutions vs Oracle Database Appliance

Compared 14% of the time

Dremio vs Oracle Database Appliance

Compared 7% of the time

Actian Ingres vs Oracle Database Appliance

Compared 4% of the time

Teradata vs Oracle Database Appliance

Compared 3% of the time

More Oracle Database Appliance Competitors

Product Reports

Buyer's Guide

IBM Db2 Warehouse

November 2024

Download IBM Db2 Warehouse product report

Buyer's Guide

Oracle Database Appliance

November 2024

Download Oracle Database Appliance product report

Also Known As

InfoSphere Warehouse, IBM InfoSphere Warehouse

X5-2

Learn More

Video not available

IBM

Oracle

Overview

InfoSphere Warehouse is a suite of products that combines the strength of DB2 with a data warehousing infrastructure from IBM. You can use InfoSphere Warehouse to build a complete data warehousing solution that includes a highly scalable relational database, data access capabilities, and front-end analysis tools.

Oracle Database Appliance is the easiest and most affordable way for small or medium-size organizations to run Oracle databases and applications and is an ideal platform for remote and edge computing environments. Customers reduce Oracle Database deployment times and management workloads using a prebuilt integrated system with management automation. As demonstrated in IDC’s business value study (PDF), Oracle Database Appliance lets customers grow revenue and control costs, delivering up to a 498% return on investment (ROI) over five years.

Sample Customers

Alameda County Social Services Agency, Sui Southern Gas Company Limited

LifeLock, Incarlopsa, Al Yusur Industrial Contracting

Buyer's Guide

IBM Db2 Warehouse vs. Oracle Database Appliance

November 2024

Free Report: IBM Db2 Warehouse vs. Oracle Database Appliance

Find out what your peers are saying about IBM Db2 Warehouse vs. Oracle Database Appliance and other solutions. Updated: November 2024.

DOWNLOAD NOW

816,406 professionals have used our research since 2012.

See our IBM Db2 Warehouse vs. Oracle Database Appliance report.

See our list of best Data Warehouse vendors.

We monitor all Data Warehouse 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.