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
67
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

"Has a very user-friendly SQL editor and it's very easy to use the connectors."
"The most valuable feature is the scalability, as it grows according to our needs."
"The valuable features are performance, data compression, and scalability."
"The seamless connection and good scalability on the cloud are valuable features of Amazon Redshift."
"Amazon Redshift is a really powerful database system for reporting and data warehousing."
"Setup is easy. It's a fast solution with machine learning features, good integration, and a good API."
"The product offers good support for the data lake."
"Redshift is a major service of Amazon and is very scalable. It enables faster recalculations and data management, helping to retrieve data quickly."
"The solution's performance is really good. Also, it's easy to operate, easy to administer, and relatively simple to install."
"I like that it's quite quick."
"It is a stable solution...It is a scalable solution."
"We can get good visualization and less redundant data."
"The most valuable aspect of this solution is that the infrastructure is easy to understand."
"Some of the main features of this solution are that it uses HANA and it has good performance."
"It is a very stable solution."
"It's quite scalable."
 

Cons

"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."
"The product could be improved by making it more flexible."
"The product must provide new indexes that support special data structures or data types like TEXT."
"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."
"Amazon Redshift is a little more expensive than other products."
"The explain panel in the Redshift database could be better."
"Amazon Redshift could improve the user interface support."
"SAP BW/4HANA can generally be less flexible than other tools, depending on how it is set up."
"The monitoring for the remodeling feature is very difficult to understand."
"The solution does occasionally get a few bugs, but this is typical for any product."
"The problem is the expensive pricing of technical support, making it an area where improvements are required."
"The solution is not scalable. It does not have a data streaming feature as well."
"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."
"Not a ten because it's expensive and its ecosystem is not very open."
"The licensing cost could be made better."
 

Pricing and Cost Advice

"The product is quite expensive."
"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."
"The best part about this solution is the cost."
"The cost will depend on how you set up your warehouse and what kind of data you store."
"The pricing is reasonable."
"One of my customers went with Google Big Query over Redshift because it was significantly cheaper for their project."
"It's not very pricey compared to other tools. I would rate the price as 5 out of 10."
"It is an expensive product."
"As an investment, the solution is very expensive."
"It's a little expensive compared to Microsoft Azure."
"For some, the rates offered by SAP can be costly while for others it may seem cheap. The price ultimately depends on how you have negotiated your contract with SAP."
"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."
"In general, it's quite expensive."
"The product is free if we have the ECC license."
"The tool is affordable."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
837,501 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
64%
Financial Services Firm
7%
Computer Software Company
5%
Manufacturing Company
3%
Manufacturing Company
18%
Financial Services Firm
9%
Computer Software Company
9%
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 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: January 2025.
837,501 professionals have used our research since 2012.