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

Amazon Redshift 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

Amazon Redshift
Ranking in Cloud Data Warehouse
8th
Average Rating
7.8
Reviews Sentiment
6.8
Number of Reviews
72
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 October 2025, in the Cloud Data Warehouse category, the mindshare of Amazon Redshift is 7.6%, up from 7.1% compared to the previous year. The mindshare of SAP Business Warehouse is 2.1%, up from 1.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse Market Share Distribution
ProductMarket Share (%)
Amazon Redshift7.6%
SAP Business Warehouse2.1%
Other90.3%
Cloud Data Warehouse
 

Featured Reviews

StevenLai - PeerSpot reviewer
Has supported data analysis needs but still requires improvements in support responsiveness and setup clarity
I work in the real estate industry, and the best features I appreciate about Amazon Redshift include its efficiency in managing large datasets. Amazon Redshift's security features help meet our compliance needs, and I have experience with its pricing and licensing which I find reasonable. I utilize Redshift's workload management.
Srini-Dhanaraj - PeerSpot reviewer
The solution enables seamless connection, but it is expensive, and the information is one day old
Out-of-the-box reports are very useful. The product provides a seamless connection between the SAP operation system and the data warehouse. It also moves the data from the operating system to the data warehouse in a 3D format. The report generation is easy. It’s a drag-and-drop process. People who want to do a project need not reinvent the wheel. Everything is designed, built, and delivered out of the box. All we have to do is interact with the customers to understand the kind of reports they need and check whether they are already available in the out-of-the-box report. If they are available, we just have to enable them and give the URLs to the customers. The Integration between the SAP operating system and data warehouse is excellent. The UI is good.

Quotes from Members

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

Pros

"The most valuable feature is that the solution is fully embedded in the AWS stack."
"Amazon Redshift's performance optimization and scalability are quite helpful, providing functionalities such as scaling up and down."
"The initial setup of this solution is straightforward."
"I work in the real estate industry, and the best features I appreciate about Amazon Redshift include its efficiency in managing large datasets."
"With the tools we have, Amazon Redshift has the features to query efficiently."
"Redshift COPY command, because much of my work involved helping customers migrate large amounts of data into Redshift."
"The most valuable feature is the scalability, as it grows according to our needs."
"The most valuable feature of Redshift is its cluster."
"Predominantly, our company uses SAP Business Warehouse for reporting purposes across various departments, especially for managers to gain a quick understanding of their current standing and make informed decisions."
"The most valuable feature of SAP Business Warehouse is its hybrid functionality, allowing users to leverage both SQL-based data warehouse capabilities from HANA and feature-based data warehousing from BW."
"In terms of stability, comparatively, the solution is quite stable."
"The most valuable feature of SAP Business Warehouse is transformation, where I extract data from different sources, particularly the raw data. Then I do some transformations and store that in a format that allows me to do reporting easily."
"With the technical support, the response has been pretty good from the SAP side."
"The most valuable aspect of the solution is the integration with SAP ERP."
"What I like most about SAP Business Warehouse is that it's a seamless integration platform. A valuable feature in the tool is the monitoring alert that makes you aware of what process chain has failed. There's no manual monitoring required if you have configured an alert system, so the process chain can run in the background, and you can get alerts about it. The functionalities I find good in SAP Business Warehouse are alerting and monitoring. If you have configured the tool and have integrated it with SAP Solution Manager, then it's a good product to use."
"I like that it integrates to open-source."
 

Cons

"The product must become a bit more serverless."
"The solution is unable to work fast."
"In the solution, user-based access is quite hard. In general, certain permissions are difficult to manage."
"Amazon Redshift could improve the user interface support."
"The initial deployment was complex."
"Compatibility with other products, for example, Microsoft and Google, is a bit difficult because each one of them wants to be isolated with their solutions."
"If you require a highly scalable solution, I would not recommend Amazon Redshift."
"Pricing needs improvement as the solution is expensive."
"I'm not sure if our issue is related to BW or the Analysis Office. However, we're having performance issues in terms of time. It takes a long time to generate the report."
"It's a product that is at the end of life so they will not improve it anymore."
"I would like to see a different end solution in order to read the data and attract internal users."
"SAP Business Warehouse could improve by having more out-of-the-box use cases to cover more business types or operations."
"A few things which are missing include the visualization of reports. That's where your costs and licensing become heavy. When it comes to this database compared Microsoft Warehouse, it's an expensive solution."
"There is room for improvement from a technical perspective."
"The solution could offer better connectivity with other databases."
"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

"The cost will depend on how you set up your warehouse and what kind of data you store."
"On a scale of one to ten, where one is a low price and ten is a high price, I rate the pricing a seven."
"This solution implements the pay-as-you-use model, so no license. Pricing could be cheaper."
"One of my customers went with Google Big Query over Redshift because it was significantly cheaper for their project."
"It's around $200 US dollars. There are some data transfer costs but it's minimal, around $20."
"At the moment, pricing is a little bit on the higher side, although it depends on the size of the company."
"It's not very pricey compared to other tools. I would rate the price as 5 out of 10."
"The solution has very competitive pricing."
"Overall, the pricing is not fixed and is expensive."
"It's moderately expensive, but definitely has its branding and price value for it."
"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."
"SAP Business Warehouse licensing is a bit expensive compared to other products in the market."
"The license for SAP Business Warehouse is paid yearly, and there's no extra cost in addition to the standard licensing fees."
"The solution is quite expensive."
"I would not recommend it to small-scale companies. The price is too much."
"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."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
869,785 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Computer Software Company
13%
Manufacturing Company
10%
Transportation Company
6%
Manufacturing Company
13%
Retailer
10%
Energy/Utilities Company
9%
Government
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business27
Midsize Enterprise21
Large Enterprise28
By reviewers
Company SizeCount
Small Business7
Midsize Enterprise4
Large Enterprise15
 

Questions from the Community

How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?
Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different dat...
What do you like most about Amazon Redshift?
The tool's most valuable feature is its parallel processing capability. It can handle massive amounts of data, even when pushing hundreds of terabytes, and its scaling capabilities are good.
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

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449
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 Amazon Redshift vs. SAP Business Warehouse and other solutions. Updated: September 2025.
869,785 professionals have used our research since 2012.