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

IBM Db2 Warehouse vs SAP BW4HANA comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 18, 2024

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

IBM Db2 Warehouse
Ranking in Data Warehouse
13th
Average Rating
7.8
Reviews Sentiment
6.1
Number of Reviews
12
Ranking in other categories
No ranking in other categories
SAP BW4HANA
Ranking in Data Warehouse
9th
Average Rating
7.6
Reviews Sentiment
6.4
Number of Reviews
45
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of June 2026, in the Data Warehouse category, the mindshare of IBM Db2 Warehouse is 3.2%, up from 2.1% compared to the previous year. The mindshare of SAP BW4HANA is 3.2%, down from 4.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse Mindshare Distribution
ProductMindshare (%)
SAP BW4HANA3.2%
IBM Db2 Warehouse3.2%
Other93.6%
Data Warehouse
 

Featured Reviews

Sherpard  Muzuva - PeerSpot reviewer
Senior Technical Manager at SYSTEMS INTEGRATED LTD (SYMPHONY)
Advanced features enhance business intelligence, but complex management calls for improved user guidance
While my experience with IBM Db2 Warehouse is somewhat limited, when compared to other databases such as Oracle, there are areas for improvement. They need to enhance the database to make it more user-friendly and easier to master. They should implement a more comprehensive graphical user interface with additional features. For instance, when users encounter problems, the system should provide better guidelines and troubleshooting directions, except for hardware-related issues. They need to implement tools that would help users perform basic troubleshooting rather than solely relying on support. Other databases have features where users can investigate specific issues using error codes. From my experience, many minor issues could be resolved before escalating to support.
Ritesh Durvasha - PeerSpot reviewer
Senior consultant at a consultancy with 10,001+ employees
Has supported efficient data processing and streamlined reporting for large-scale sales operations
The capability to handle a large amount of data and perform ETL operations is most valuable. Additionally, sending data out of SAP BW4HANA through Open Hub, which is a free service, is another valuable feature. In contrast, many other products charge for sending data out of their systems, such as Data Sphere or BDC, which charge premium service fees. Regarding advanced analytic tools in SAP BW4HANA, users can directly connect to Analysis for Office without additional charges. It's convenient as users don't have to download data into Excel since it's already connected to the system. From an integration capabilities perspective, it's easy to connect to SAP systems, though integration with non-SAP systems presents more challenges.

Quotes from Members

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

Pros

"Provides good security and reliability."
"Some of the best features are stored procedures, parallelism, and different indexing strategies."
"It's easy and practical to use."
"IBM Db2 Warehouse is more resilient when dealing with business intelligence applications."
"If you have good people designing how the data is stored, it's a marvelous tool."
"The most valuable features of IBM Db2 Warehouse include its availability, easy integration, ability to deal with a large size of data, excellent performance with no delays, powerful security mechanisms, and effective support."
"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."
"It can scale effectively as long as resources are available."
"Overall, it's hard to compare with other products on the market, but I think it has improved quite significantly."
"We like that it is an SAP product, so we can easily connect with the SAP ERP system."
"Its direct approach is the most valuable. You get more real time and capabilities than BW."
"We benefited from BW/4HANA's ability to utilize predefined content inside, and we didn't need to start from scratch."
"The solution saves time and cost."
"The most valuable feature is the dashboard."
"The processes are the most valuable aspect of this solution."
"It is a stable solution...The initial setup was easy."
 

Cons

"The biggest challenge anyone could have with Db2 Warehouse is their references or online resources and documentation. They are very, very, very limited on the web."
"The primary challenges customers face with IBM Db2 Warehouse are related to its complexity in usage. It requires highly skilled professionals who understand Db2, and both training and support are challenging to obtain."
"Responding to support tickets takes a lot of time. It can range from two to four days, even for critical issues."
"I previously used DataStage, which I think is better than InfoSphere Warehouse."
"IBM Db2 Warehouse needs to improve its interface."
"There should be more material available for training and training should be free."
"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."
"The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting."
"The tool is not easy to use for an end user."
"Regarding SAP support, I have raised many support tickets but did not receive adequate support. It took more than months to get responses."
"Support could be more reliable."
"In the next release, I would like to see their BI component introduced with a mobile version, as it is not currently present."
"There should be a direct pipeline from Azure to SAP."
"One thing that could be enhanced in SAP BW4HANA is the user interface for process chains."
"The solution is not scalable. It does not have a data streaming feature as well."
"Pricing would be a good improvement. A lot of customers think that it's very expensive and especially support is very expensive."
 

Pricing and Cost Advice

"In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side."
"We have a broad licensing arrangement, which is expensive but worth it for sizeable businesses."
"For some, the rates offered by SAP can be costly while for others it may seem cheap. The price ultimately depends on how you have negotiated your contract with SAP."
"The SAP HANA application still hasn't been leveraged to the fullest extent, but it's a five-year enterprise license."
"The product is free if we have the ECC license."
"The tool is affordable."
"It's a little expensive compared to Microsoft Azure."
"The price is high and currently only affordable for large organizations."
"SAP BW/4HANA is expensive."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
900,747 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
27%
Construction Company
9%
Manufacturing Company
6%
Government
5%
Financial Services Firm
12%
Manufacturing Company
10%
Construction Company
9%
Retailer
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business5
Midsize Enterprise3
Large Enterprise5
By reviewers
Company SizeCount
Small Business16
Midsize Enterprise4
Large Enterprise30
 

Questions from the Community

What is your experience regarding pricing and costs for IBM Db2 Warehouse?
The pricing for medium and large environments is almost the same as Oracle. I rate the pricing as six out of ten.
What needs improvement with IBM Db2 Warehouse?
While my experience with IBM Db2 Warehouse is somewhat limited, when compared to other databases such as Oracle, there are areas for improvement. They need to enhance the database to make it more u...
What is your primary use case for IBM Db2 Warehouse?
The main advantages of IBM Db2 Warehouse become apparent when dealing with business intelligence applications. I worked with it when it was installed for one of our customers, a utilities company, ...
What needs improvement with SAP BW4HANA?
For improvement, I think AWS for HANA could be better, but it is an on-premise solution. SAP is asking us to move to one client approach and suggested moving to data warehouse cloud, which should h...
What is your primary use case for SAP BW4HANA?
My use cases involve the client I am working with, who already has a BW ON HANA system, and we are currently migrating and redeveloping things in SAP BW4HANA; they are decommissioning the BW On HAN...
 

Also Known As

InfoSphere Warehouse, IBM InfoSphere Warehouse
SAP BW/4HANA
 

Overview

 

Sample Customers

Alameda County Social Services Agency, Sui Southern Gas Company Limited
Information Not Available
Find out what your peers are saying about IBM Db2 Warehouse vs. SAP BW4HANA and other solutions. Updated: June 2026.
900,747 professionals have used our research since 2012.