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

Amazon Redshift vs SAP Business Warehouse comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Amazon Redshift
Ranking in Cloud Data Warehouse
4th
Average Rating
7.8
Reviews Sentiment
7.4
Number of Reviews
66
Ranking in other categories
No ranking in other categories
SAP Business Warehouse
Ranking in Cloud Data Warehouse
13th
Average Rating
7.8
Reviews Sentiment
6.9
Number of Reviews
25
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Cloud Data Warehouse category, the mindshare of Amazon Redshift is 7.7%, down from 11.9% compared to the previous year. The mindshare of SAP Business Warehouse is 1.4%, down from 1.6% 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

"We have found Machine Learning use cases are very nice."
"The most valuable feature is the scalability, as it grows according to our needs."
"The most valuable features of Amazon Redshift are that its fast and efficient. We have lots of TBs of data and it's very fast."
"I find the most valuable features to be the MPP style of processing, which mostly all of the data warehouses provide. The ability to integrate all other AWS services, such as NSS and S3, with little effort is very helpful. The service is well maintained, there are update patches frequently."
"Redshift allows you to transform different data formats and consolidate them into one Redshift cluster. This means you can transform various siloed data sources like Excel files and CSV files into Redshift."
"Amazon Redshift is a really powerful database system for reporting and data warehousing."
"It allows you write complex queries and perform row by row processes."
"Redshift has an advantage when it comes to administration, making it easier to manage and collaborate."
"The real-time information is great."
"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 this solution is the advanced structuring of data capabilities. You can get different structures of data to suit your needs."
"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."
"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."
"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."
"Having the back-end data set with the right information is the best qualification for this solution."
"The key element in this solution is its rapid response. If you have a question about prices, buyers, customers, providers, or services, you need the answer in a minute or two. That's the key benefit for us that a solution like BW gives us."
 

Cons

"Amazon should provide more cloud-native tools that can integrate with Redshift like Microsoft's development tools for Azure."
"The initial setup is a complex process, especially for someone who is not familiar with nodes and configuring terms like RPUs."
"Running parallel queries results in poor performance and this needs to be improved."
"The solution could improve in handling more data formats and more native support for RDF."
"They should provide a better way to work with interim data in a structured way than to store it in parquet files locally."
"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."
"Redshift's GUI could be more user-friendly. It's easier to perform queries and all that stuff in Azure Synapse Analytics."
"Sometimes, it's difficult to get the metadata from Redshift."
"The solution could offer better connectivity with other databases."
"More integration with Microsoft Office products (not just Excel) would be helpful."
"They should reduce the product’s installation package size for easier downloading."
"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."
"There is room for improvement from a technical perspective."
"I would like to see a different end solution in order to read the data and attract internal users."
"So far, the initial setup process in our company has not been easy enough for us to understand."
"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."
 

Pricing and Cost Advice

"The cost must be improved."
"The product is quite expensive."
"One of my customers went with Google Big Query over Redshift because it was significantly cheaper for their project."
"The solution is available at a mid-range price compared to other vendors."
"The part that I like best is that you only pay for what you are using."
"It's around $200 US dollars. There are some data transfer costs but it's minimal, around $20."
"In comparison to the price of similar solutions, Redshift's cost is the lowest."
"It is an expensive product."
"The solution is quite expensive."
"Overall, the pricing is not fixed and is expensive."
"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."
"It's moderately expensive, but definitely has its branding and price value for it."
"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 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."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
60%
Financial Services Firm
7%
Computer Software Company
6%
Manufacturing Company
4%
Computer Software Company
11%
Manufacturing Company
11%
Financial Services Firm
9%
Government
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 Amazon Redshift?
You can start small with a basic cluster to learn and practice with it. Selecting the most basic and economical cluster type can save you enough money to move forward with the solution or go with a...
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: November 2024.
816,406 professionals have used our research since 2012.