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
11th
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 August 2026, in the Data Warehouse category, the mindshare of IBM Db2 Warehouse is 2.9%, up from 2.4% compared to the previous year. The mindshare of SAP BW4HANA is 3.4%, down from 4.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse Mindshare Distribution
ProductMindshare (%)
SAP BW4HANA3.4%
IBM Db2 Warehouse2.9%
Other93.7%
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

"The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data."
"IBM Db2 Warehouse is more resilient when dealing with business intelligence applications."
"It's easy and practical to use."
"The initial setup was really easy; it's Docker compliant, you just pull the image from the IBM repository and that's it, and the deployment must have taken less than an hour, making it really fast to have it completely working."
"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."
"Provides good security and reliability."
"Some of the best features are stored procedures, parallelism, and different indexing strategies."
"If you have good people designing how the data is stored, it's a marvelous tool."
"For a big customer, who is SAP-centric, with lots of SAP data or SAP business processes, this is one of the best data warehousing solutions."
"It's quite scalable."
"We benefited from BW/4HANA's ability to utilize predefined content inside, and we didn't need to start from scratch."
"It is a stable solution...The initial setup was easy."
"The most valuable feature is that we can transform a huge amount of data and apply business logic as per the requirements."
"The product has efficient performance."
"SAP BW4HANA aids in managing data from ER to front-end analysis, contributes to ROI, and fosters business growth understanding. I like that the solution breaks down components to a very granular level, allowing for customization and implementation based on specific requirements. The solution is stable. The solution is scalable."
"Overall, it's hard to compare with other products on the market, but I think it has improved quite significantly."
 

Cons

"In terms of improvement, IBM Db2 Warehouse should be more scalable."
"IBM Db2 Warehouse needs to improve its interface."
"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."
"I previously used DataStage, which I think is better than InfoSphere Warehouse."
"The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting."
"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 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."
"On a scale of one to ten, I would rate the technical support as a five. It is fairly bad."
"In the next release, I would like to see their BI component introduced with a mobile version, as it is not currently present."
"It takes too long to escalate problems from the first level of support."
"Price wise, this solution is on the higher side."
"The licensing cost could be made better."
"Other competitors provide better solutions that are more up to date with current technology. For example, machine learning and artificial intelligence."
"Regarding SAP support, I have raised many support tickets but did not receive adequate support. It took more than months to get responses."
"Not a ten because it's expensive and its ecosystem is not very open."
"We cannot integrate with third-party tools like Python or advanced integration options. You can't fine-tune tables within BW or generate specific views or reports."
 

Pricing and Cost Advice

"In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side."
"We started as early birds from the SAP side. We got this entire suite for free. I cannot really talk about the price because we didn't have to pay anything."
"The cost of ownership is higher. It's resource-intensive, and naturally, that increases costs."
"The cost and licensing depends on how the customer is going to use the solution."
"It's a little expensive compared to Microsoft Azure."
"We have a broad licensing arrangement, which is expensive but worth it for sizeable businesses."
"The price is high and currently only affordable for large organizations."
"SAP BW/4HANA is expensive."
"For the on-premises version of the product, the solution offers a perpetual-based licensing model to its users. In general, SAP offers a monthly subscription-based licensing model to its users."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
909,153 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
24%
Construction Company
11%
Comms Service Provider
6%
Manufacturing Company
6%
Financial Services Firm
11%
Manufacturing Company
10%
Retailer
9%
Construction Company
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: August 2026.
909,153 professionals have used our research since 2012.