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

Amazon Redshift vs SAP BW4HANA comparison

 

Comparison Buyer's Guide

Executive Summary

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
Average Rating
7.8
Reviews Sentiment
6.9
Number of Reviews
70
Ranking in other categories
Cloud Data Warehouse (5th)
SAP BW4HANA
Average Rating
7.6
Reviews Sentiment
6.6
Number of Reviews
42
Ranking in other categories
Data Warehouse (9th)
 

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.
Csaba Grünblatt - PeerSpot reviewer
Performs all necessary data warehouse tasks and offers additional functionalities
SAP BW4HANA improved data reporting processes significantly. Performance on HANA database is good. Well-built data models ensure consistent and fast reporting. Reusable models enhance efficiency, even for SaaS services. In-memory computing, especially since HANA, has greatly improved performance in data analysis tasks. It eliminates the need for complex optimizations like creating indexes or aggregates. Queries that once took minutes now run in seconds, enabling real-time reporting, especially for SAP ECC on HANA. SAP BW4HANA's integration capabilities are streamlined with a simplified architecture and more virtual layers. You can directly load data into optimized layers, reducing the need for extra storage. The introduction of Open ODS Views allows for additional logic and master data inclusion, making integration faster and simpler. The learning curve for SAP BW4HANA is much faster now compared to ten years ago, thanks to abundant free resources like documentation, videos, blogs, and learning journeys provided by SAP. It is simpler to learn with these resources available compared to the past when you had to attend courses and rely on books. I would recommend SAP BW4HANA to users looking to implement it, especially if they want to keep their systems on-premise and already have SAP systems. Those with BW on HANA have two choices: BW4HANA or DataSphere, depending on their cloud strategy. If they are advanced in their cloud strategy and want to migrate off-premise, DataSphere is a good choice. However, for a robust solution on-premise or in a private cloud, BW4HANA is an excellent option. Overall, I would rate BW4HANA as a nine out of ten. It performs all necessary data warehouse tasks and offers additional functionalities. We use it traditionally, with complex transformations and models but with less emphasis on real-time processing and third-party sources.

Quotes from Members

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

Pros

"I would rate Amazon Redshift a ten on a scale of one to ten."
"The product is relatively easy to use because there is no indexing and no partitions."
"The solution's flexibility is its most valuable feature. It's also easy to scale and has relatively painless pricing."
"The initial setup is easy."
"Amazon Redshift offers a relatively flexible structure...I rate the technical support a nine out of ten."
"Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."
"The initial setup of this solution is straightforward."
"It allows you write complex queries and perform row by row processes."
"I like that it's quite quick."
"The most valuable feature is that it's robust."
"The most valuable aspect of this solution is that the infrastructure is easy to understand."
"I like the reporting features of the solution."
"It is a stable solution...It is a scalable solution."
"We like that it is an SAP product, so we can easily connect with the SAP ERP system."
"The product has efficient performance."
"Provides a great analytics engine with all the capabilities."
 

Cons

"Running parallel queries results in poor performance and this needs to be improved."
"It takes a lot of time to ingest and update the data."
"Infinite storage is available in Snowflake and is not available in Redshift."
"In the next release, a pivot function would be a big help. It could save a lot of time creating a query or process to handle operations."
"Pricing is one of the things that it could improve. It should be more competitive."
"In our experiments, the handling of unstructured data was not very smooth."
"The only minor issue I faced was that it took a bit longer than expected to change the cluster to have more space or storage."
"The initial deployment was complex."
"I cannot integrate it with my other tools. It's not possible to do something in the predictive analysis. Mobile reporting is also not available."
"The speed of operations could be a little faster."
"Price wise, this solution is on the higher side."
"The interface could be more user-friendly, as we often need to do low-level coding to get things done."
"The solution does occasionally get a few bugs, but this is typical for any product."
"The product needs to improve with more performance and fewer data layers."
"I don't see SAP actively supporting the solution now...a better support from SAP would be appreciated."
"There should be a direct pipeline from Azure to SAP."
 

Pricing and Cost Advice

"It's not very pricey compared to other tools. I would rate the price as 5 out of 10."
"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."
"The product is quite expensive."
"Amazon Redshift is an expensive solution. Larger organizations can afford this solution, but smaller businesses would struggle to afford it."
"One of my customers went with Google Big Query over Redshift because it was significantly cheaper for their project."
"The cost is comparable to Snowflake."
"In comparison to the price of similar solutions, Redshift's cost is the lowest."
"It's pay per use. You can have multiple models."
"The solution is expensive."
"This is an expensive solution and there are costs in addition to the standard licensing fees."
"The tool is affordable."
"The cost of ownership is higher. It's resource-intensive, and naturally, that increases costs."
"SAP BW/4HANA is expensive."
"The price is high and currently only affordable for large organizations."
"It's a little expensive compared to Microsoft Azure."
"It is an expensive product."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
842,161 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
18%
Financial Services Firm
10%
Computer Software Company
9%
Retailer
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 do you like most about SAP BW4HANA?
One significant advantage of SAP BW/4HANA is the direct integration with the SAP HANA database, providing seamless access to real-time analytics. Additionally, it enables real-time data integrati...
What is your experience regarding pricing and costs for SAP BW4HANA?
We have a broad licensing arrangement, which is expensive but worth it for sizeable businesses.
What needs improvement with SAP BW4HANA?
The interface could be more user-friendly, as we often need to do low-level coding to get things done.
 

Comparisons

 

Also Known As

No data available
SAP BW/4HANA
 

Overview

 

Sample Customers

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449
Information Not Available
Find out what your peers are saying about Amazon Redshift vs. SAP BW4HANA and other solutions. Updated: March 2025.
842,161 professionals have used our research since 2012.