Try our new research platform with insights from 80,000+ expert users

Oracle Autonomous Data Warehouse vs SAP Business Warehouse 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

Oracle Autonomous Data Ware...
Ranking in Cloud Data Warehouse
10th
Average Rating
8.4
Reviews Sentiment
7.2
Number of Reviews
19
Ranking in other categories
No ranking in other categories
SAP Business Warehouse
Ranking in Cloud Data Warehouse
14th
Average Rating
7.8
Reviews Sentiment
6.3
Number of Reviews
25
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of June 2025, in the Cloud Data Warehouse category, the mindshare of Oracle Autonomous Data Warehouse is 4.8%, up from 4.1% compared to the previous year. The mindshare of SAP Business Warehouse is 1.5%, up from 1.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse
 

Featured Reviews

Kwajah Mohiuddin - PeerSpot reviewer
Provides self-repair features, but the setup is complex
We use the product for online applications. We use it in the financial industry The product has self-repair features. The tool tunes itself. It separates compute from storage. We can scale storage and compute separately. The setup is complex. Oracle is a complex tool. I have been using Oracle…
JavedKhan1 - PeerSpot reviewer
Offers powerful analytics and integration capabilities but requires improved upgrade processes
SAP Business Warehouse could have been better. There is room for improvement from a technical perspective. So, from a technical perspective, when we are upgrading a Business Warehouse server or we are migrating from one place to another, the capability required for this upgradation has many manual activities. It took us around a month to streamline our server. Let’s say there are some transaction codes. Transaction code is a set of programs, and when you want to run a program from the backend, you need to hit the transaction code. It is called a T-code. So during the upgrade, many transaction codes get affected, and as a security consultant, it is my responsibility to recheck those transaction codes which are affected. Sometimes more than 100 codes may get affected, sometimes 500, and sometimes more as well. So, it takes a hell lot of time to integrate them again. That is a limitation or defect within the SAP Business Warehouse. SAP Business Warehouse should come up with proper solutions. Upgradation is an automatic activity. It should happen by itself. We just need to initiate it, and the backend SAP server is automatically upgraded. But it should handle the transactional code as well. They should not get absolutely, and any authorization object should not get deleted from the transaction codes. So, that functionality SAP Business Warehouse should come up with.

Quotes from Members

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

Pros

"With Oracle Autonomous Data Warehouse, things are much simpler. Creating a structure, initializing the servers, extending the servers, those are all things that are very, very easy. That's the main reason we use it."
"It is a very stable tool...It is an extremely scalable tool."
"I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system."
"The solution has a self-backup, so you don't need a DBA (database administrator) to do a backup."
"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"Self-patching and runs machine-learning across its logs all the time"
"A very good integration feature that restricts access to unauthorized people."
"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"The most valuable aspect of the solution is the integration with SAP ERP."
"Out-of-the-box reports are very useful."
"The features that I have found most valuable are its capabilities to connect to Excel and to slice and dice."
"The product is very stable."
"Having the integration with the reporting tool which is provided by SAP is great."
"SAP Business Warehouse is a scalable solution."
"The real-time information is great."
"The warehouse is the solution's most valuable feature."
 

Cons

"Optimization should be better."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
"The solution lacks visibility options."
"We are not satisfied with the technical support. Their understanding is lacking."
"An improvement for us would be the inclusion of support for an internal IP, so we could use it directly with the VCN in Oracle Cloud."
"Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable."
"My main suggestion for Oracle is the configuration and key values that come for JSON files. When we create a table, especially if you see in our RedShift or some other stuff, if I create a table on top of a JSON file with multiple array columns or superset columns, those column values create some difficulty in Oracle."
"I would like to see an on-premise solution in the future."
"It's a product that is at the end of life so they will not improve it anymore."
"The way the data is stored is kind of rigid in SAP BW as a product. It could be more flexible so that when we are designing a solution, we can design our own data structures and try to improve performance."
"So far, the initial setup process in our company has not been easy enough for us to understand."
"They should reduce the product’s installation package size for easier downloading."
"More integration with Microsoft Office products (not just Excel) would be helpful."
"The problem with BW, and the factor that differentiated it from the original BW, is that you only get limited functionality with your runtime license. So, you have to pay extra for extracting data."
"It takes more work to get the data, including reporting on that data, because some coding is required, and a significant level of transformation is needed when using SAP Business Warehouse."
"What I'd like to improve in SAP Business Warehouse is its data structure, that's a little bit rigid. It could be a bit more flexible, so you can design your data structure and improve performance when creating a solution. Currently, the way data is stored in SAP Business Warehouse is rigid."
 

Pricing and Cost Advice

"Oracle Autonomous Data Warehouse's pricing is fair and reasonable compared to the other cloud vendors."
"The licensing cost of the product can vary since you can integrate it very easily with other products or other cloud products...You pay as you use it, so it is not yearly or monthly payments to be made toward Oracle."
"Cloud solutions are cheaper, but in the long run, they may not be much cheaper. They certainly have a lower initial cost. The licensing is yearly, and it is based on the size of the hardware and the number of users."
"You pay as you go, and you don't pay for services that you don't use."
"The price depends on the configuration we choose."
"On a scale from one to ten, where one is a low price and ten is a high price, I rate the pricing an eight."
"We pay approximately $70,000 per month. The cost includes maintenance and support."
"The cost is perfect with Oracle Universal credit."
"It's quite pricey. SAP changed its pricing policy, so they give you one engine and then you have to buy everything next to it, like MSS, the BPC licenses, and everything else."
"The license for SAP Business Warehouse is paid yearly, and there's no extra cost in addition to the standard licensing fees."
"SAP Business Warehouse licensing is a bit expensive compared to other products in the market."
"It's moderately expensive, but definitely has its branding and price value for it."
"I would not recommend it to small-scale companies. The price is too much."
"The licensing cost for SAP Business Warehouse depends on your revenue. Its licensing structure is a little bit complicated. The more your revenue is, the higher the price, but SAP does have different pricing structures for various companies. For small businesses, licensing isn't based on revenue, but for big companies, it's revenue-based. There's some agreement regarding pricing for huge companies, so it's different, and SAP Business Warehouse pricing isn't fixed. On a scale of one to ten, I'm rating the licensing cost for SAP Business Warehouse as five because it's very high. As your revenue grows, your licensing cost also increases, so you have to factor that in when calculating your cost."
"The solution is quite expensive."
"Overall, the pricing is not fixed and is expensive."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
859,129 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
26%
Financial Services Firm
11%
Computer Software Company
8%
Manufacturing Company
5%
Manufacturing Company
13%
Financial Services Firm
10%
Computer Software Company
9%
Energy/Utilities Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Oracle Autonomous Data Warehouse?
With Oracle Autonomous Data Warehouse, things are much simpler. Creating a structure, initializing the servers, extending the servers, those are all things that are very, very easy. That's the main...
What is your experience regarding pricing and costs for Oracle Autonomous Data Warehouse?
We pay approximately $70,000 per month. The cost includes maintenance and support.
What needs improvement with Oracle Autonomous Data Warehouse?
Optimization should be better. The SQLs are sometimes very slow. I also noticed that Java is not supported, which is not ideal.
What is your experience regarding pricing and costs for SAP Business Warehouse?
The solution is quite expensive. We paid a yearly subscription fee.
What needs improvement with SAP Business Warehouse?
Over a period, we realized that the license and maintenance costs were quite expensive. Every day, we had to run the background job ODS. Eventually, we moved away from SAP Business Warehouse and bo...
 

Overview

 

Sample Customers

Hertz, TaylorMade Golf, Outront Media, Kingold, FSmart, Drop-Tank
Medtronic, Cirque du Soleil, Antarc, B&G Manufacturing, EarlySense, eBay, Ferrero, James Austin Company, Lenovo, Sagem, RAK Ceramics, Vodafone
Find out what your peers are saying about Oracle Autonomous Data Warehouse vs. SAP Business Warehouse and other solutions. Updated: June 2025.
859,129 professionals have used our research since 2012.