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
6th
Average Rating
7.8
Reviews Sentiment
6.9
Number of Reviews
71
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 July 2025, in the Cloud Data Warehouse category, the mindshare of Amazon Redshift is 7.5%, down from 8.0% compared to the previous year. The mindshare of SAP Business Warehouse is 1.6%, up from 1.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse
 

Featured Reviews

Sriram-Natesan - PeerSpot reviewer
The ability to create a lot of views or materialized views is beneficial
Improvement in the immediate response and the process of getting into a call could be helpful. We have had to wait for at least twenty-four hours to get a call and then wait for a couple more hours for a solution. Improved connectivity to different BI tools and already published connectors for major tools in AWS could enhance the service.
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

"I found the Amazon Redshift computing services easy. I found the computing instances the most incredible in the solution."
"It allows you write complex queries and perform row by row processes."
"The solution is easy to set up and use."
"Amazon Redshift is very fast. It has really good response times. It's very user-friendly."
"Redshift's versioning and data security are the two most critical features. When migrating into the cloud, it's vital to secure the data. The encryption and security are there."
"It allows for the storage of huge amounts of data."
"Easy to build out our snowflake design and load data."
"You can copy JSON to the column and have it analyzed using simple functions."
"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."
"What I like most about SAP Business Warehouse is its ability to feed data into new, multiple systems in various formats. It can open its data to any system over gateway services or a portal or application that needs to consume and analyze data."
"The most useful feature has been he ability to feed data into multiple systems in various formats."
"Out-of-the-box reports are very useful."
"SAP Business Warehouse is a scalable solution."
"I like that it integrates to open-source."
"In terms of stability, comparatively, the solution is quite stable."
"The features that I have found most valuable are its capabilities to connect to Excel and to slice and dice."
 

Cons

"For people who struggle with IAM or role-based management, the setup isn't easy."
"Amazon Redshift does not work alone and requires integration with other AWS tools like S3 and Glue for a complete ecosystem."
"Running parallel queries results in poor performance and this needs to be improved."
"Improvement could be made in the area of streaming data."
"What would make Amazon Redshift better is improvising on the pricing structure. For example, Acronis provides backups in cybersecurity, yet the pricing is a bit lesser than Amazon Redshift."
"The product could be improved by making it more flexible."
"We recently moved from the DC2 cluster to the RA3 cluster, which is a different node type and we are finding some issues with the RA3 cluster regarding connection and processing. There is room for improvement in this area. We are in talks with AWS regarding the connection issues."
"Sometimes, it's difficult to get the metadata from Redshift."
"It's a product that is at the end of life so they will not improve it anymore."
"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."
"SAP Business Warehouse could improve by having more out-of-the-box use cases to cover more business types or operations."
"SAP Business Warehouse could integrate better with other ETL tools."
"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."
"We are very unhappy with technical support. First of all, they send their sales agents or pre-sales agents and most of them who don't know the solution as a properly trained tech would. We have an on-site SAP representative who is supposed to help us with our high priority and production issues, and they're not satisfactory to say the least."
"What I'd like improved in SAP Business Warehouse is its setup. It could be more flexible, and it could be a configuration-based setup."
"In the next release, my suggestion would be to have user-friendly interfaces and performance issues be addressed."
 

Pricing and Cost Advice

"The product is cheap considering what it provides; I rate it five out of five for affordability."
"My customers have implementations that cost about $500 a month for a very small one. I also have a customer with a monthly invoice of about $25,000 USD."
"It's not very pricey compared to other tools. I would rate the price as 5 out of 10."
"BI is sold to our customer base as a part of the initial sales bundle. A customer may elect to opt for a white labeled site for an up-charge."
"The price of Amazon Redshift is reasonable because it depends on the usage that you use and for DWH for the long term."
"It's pay per use. You can have multiple models."
"Redshift is very cost effective for a cloud based solution if you need to scale it a lot. For smaller data sizes, I would think about using other products."
"Pricing for Amazon Redshift is reasonable, though it could be somewhat higher than other solutions, such as Azure. Still, when you base your comparison on the services offered and the pricing, it's the most reasonable versus its competitors, such as RDS."
"Overall, the pricing is not fixed and is expensive."
"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."
"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."
"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."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
859,957 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
35%
Financial Services Firm
12%
Computer Software Company
10%
Manufacturing Company
6%
Manufacturing Company
13%
Financial Services Firm
10%
Computer Software Company
8%
Energy/Utilities Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

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: May 2025.
859,957 professionals have used our research since 2012.