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 (8th)
 

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

"It is quite simple to use and there are no issues with creating the tables."
"With the APIs that are available, it can be easily integrated with other tools."
"Though Amazon Redshift is good, it depends on what kind of business you're trying to do, what type of analytics you need, and how much data you have."
"The solution's speed, stability, and user concurrency have been very good."
"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."
"Redshift Spectrum is the most valuable feature."
"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."
"Redshift COPY command, because much of my work involved helping customers migrate large amounts of data into Redshift."
"The solution's most valuable feature is that it is a very powerful tool. The solution also has the best stability, robustness, and customizability features."
"It is a stable solution."
"SAP BW4HANA aids in managing data from ER to front-end analysis, contributes to ROI, and fosters business growth understanding. I like that the solution breaks down components to a very granular level, allowing for customization and implementation based on specific requirements. The solution is stable. The solution is scalable."
"The most valuable feature is that it's robust."
"It provides the functions in a way that even a less technical person can do the modeling."
"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 integration. We don't need to rely on historical data alone; we can provide reporting and features based on real-time information."
"Technology-wise, it is a very robust tool."
"The solution is easier to maintain than traditional SAP products."
 

Cons

"Amazon Redshift could improve the user interface support."
"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 high price of the product is an area of concern where improvements are required."
"For people who struggle with IAM or role-based management, the setup isn't easy."
"The solution has four maintenance windows so, when it comes to stability, I think it would be better to decrease their number."
"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."
"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."
"We are using third-party tools to integrate Amazon Redshift, they should create their own interface on their own for it to be easily connected on the AWS itself."
"The product needs to improve with more performance and fewer data layers."
"The monitoring for the remodeling feature is very difficult to understand."
"SAP BW/4HANA can generally be less flexible than other tools, depending on how it is set up."
"Not a ten because it's expensive and its ecosystem is not very open."
"The dashboard should be simplified and made easier for exploration and decision making."
"Challenges arise with real-time client requirements when clients are accustomed to Microsoft Excel's extensive features for data analysis. They expect similar flexibility and customization in the solution, particularly regarding headers displaying keys and descriptions or just keys. Achieving this level of customization can be challenging, and it's an area that may need improvement."
"Support could be more reliable."
"In the next release, I would like to see their BI component introduced with a mobile version, as it is not currently present."
 

Pricing and Cost Advice

"At the moment, pricing is a little bit on the higher side, although it depends on the size of the company."
"It's pay per use. You can have multiple models."
"In comparison to the price of similar solutions, Redshift's cost is the lowest."
"The cost will depend on how you set up your warehouse and what kind of data you store."
"The product is cheap considering what it provides; I rate it five out of five for affordability."
"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."
"Amazon Redshift is an expensive solution. Larger organizations can afford this solution, but smaller businesses would struggle to afford it."
"It's around $200 US dollars. There are some data transfer costs but it's minimal, around $20."
"It is an expensive product."
"The product is free if we have the ECC license."
"The cost of ownership is higher. It's resource-intensive, and naturally, that increases costs."
"The solution is expensive."
"We started as early birds from the SAP side. We got this entire suite for free. I cannot really talk about the price because we didn't have to pay anything."
"Price wise, this solution is on the higher side."
"SAP BW/4HANA is expensive."
"The cost and licensing depends on how the customer is going to use the solution."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
845,406 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
17%
Financial Services Firm
9%
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.
845,406 professionals have used our research since 2012.