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
5th
Average Rating
7.8
Reviews Sentiment
6.9
Number of Reviews
70
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 April 2025, in the Cloud Data Warehouse category, the mindshare of Amazon Redshift is 7.2%, down from 9.2% compared to the previous year. The mindshare of SAP Business Warehouse is 1.2%, up from 1.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse
 

Featured Reviews

Ved Prakash Yadav - PeerSpot reviewer
Works as a data warehouse system and collects data from different sources
In terms of improvement, I believe Amazon Redshift could work on reducing its costs, as they tend to increase significantly. Additionally, there are occasional issues with nodes going down, which can be problematic. We often encounter issues like someone dropping a column or changing the order of columns, which can cause synchronization problems when pushing data through our pipeline. It's a minor issue, but it can be annoying.
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

"Has a very user-friendly SQL editor and it's very easy to use the connectors."
"Amazon Redshift's performance optimization and scalability are quite helpful, providing functionalities such as scaling up and down."
"I am satisfied with the performance of the product."
"The solution's flexibility is its most valuable feature. It's also easy to scale and has relatively painless pricing."
"The most valuable feature of Amazon Redshift is its ability to handle really large sets of data."
"Redshift COPY command, because much of my work involved helping customers migrate large amounts of data into Redshift."
"This service can merge and integrate well with all databases."
"Redshift's Excel features are handy. Redshift spectrum allows you to directly query the data on an Excel sheet. Now, SQL Server also allows this, but Redshift has many more features."
"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."
"The product is very stable."
"The warehouse is the solution's most valuable feature."
"The features that I have found most valuable are its capabilities to connect to Excel and to slice and dice."
"I like that it integrates to open-source."
"Out-of-the-box reports are very useful."
"SAP Business Warehouse is a scalable solution."
"Having the back-end data set with the right information is the best qualification for this solution."
 

Cons

"The solution could improve in handling more data formats and more native support for RDF."
"Should be made available across zones, like other Multi-AZ solutions."
"Improvement in the immediate response and the process of getting into a call could be helpful."
"Planting is the primary key enforcement that should be improved."
"For people who struggle with IAM or role-based management, the setup isn't easy."
"The OLAP slide and dice features need to be improved."
"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 refreshment rate of data reaching Redshift from other sources should be faster."
"So far, the initial setup process in our company has not been easy enough for us to understand."
"One of our requirements is the ability to easily get answers regarding trends and exceptions. In BW, it is not that easy to get such information. I expect better trend and exception detection, better pattern detection."
"The solution could offer better connectivity with other databases."
"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."
"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."
"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."
"Areas for improvement in SAP Business Warehouse include enhancing scheduling and monitoring tools, as well as improving communication about hidden features to make them more accessible to users."
"The advanced structuring can be complicated and the interface is not very intuitive."
 

Pricing and Cost Advice

"If you want a fixed price, an to not worry about every query, but you need to manage your nodes personally, use Redshift."
"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."
"One of my customers went with Google Big Query over Redshift because it was significantly cheaper for their project."
"It is an expensive product."
"It's around $200 US dollars. There are some data transfer costs but it's minimal, around $20."
"The pricing is reasonable."
"The solution is available at a mid-range price compared to other vendors."
"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."
"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."
"Overall, the pricing is not fixed and is expensive."
"The solution is quite expensive."
"SAP Business Warehouse licensing is a bit expensive compared to other products in the market."
"I would not recommend it to small-scale companies. The price is too much."
"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."
"The license for SAP Business Warehouse is paid yearly, and there's no extra cost in addition to the standard licensing fees."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
845,589 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
65%
Financial Services Firm
6%
Computer Software Company
5%
Manufacturing Company
3%
Manufacturing Company
12%
Financial Services Firm
10%
Government
9%
Computer Software 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: April 2025.
845,589 professionals have used our research since 2012.