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

"Its simplicity in configuration, cost-effectiveness due to being in the cloud and close to our data sources, and the fact that it's a managed service that is scalable and reliable are highly valuable."
"Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."
"The solution is easy to set up and use."
"With the tools we have, Amazon Redshift has the features to query efficiently."
"The most valuable features are that it's easy to set up and easy to connect the many tools that connect to it."
"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."
"It's very easy to migrate from other databases to Redshift. There are migration tools dedicated for this purpose, enabling migration from other databases like MS SQL directly to Redshift. The majority of the scripts will be automatically transposed."
"In terms of valuable features, I like the columnar storage that Redshift provides. The storage is one of the key features that we're looking for. Also, the data updates and the latency between the data-refreshes."
"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."
"Some of the main features of this solution are that it uses HANA and it has good performance."
"I like that it's quite quick."
"The solution's performance is really good. Also, it's easy to operate, easy to administer, and relatively simple to install."
"The solution saves time and cost."
"The most valuable features are the speed of reporting and the HANA database."
"We can get good visualization and less redundant data."
"From an ERP point of view and a functionality point of view, it works very well. The benefits are in that of financial costing and material management."
 

Cons

"There are too many limitations with respect to concurrency."
"There might be some limitations from a business intelligence perspective, but nothing we can't find a workaround for."
"The OLAP slide and dice features need to be improved."
"Amazon Redshift does not work alone and requires integration with other AWS tools like S3 and Glue for a complete ecosystem."
"When working with third-party services requires additional integrations and configurations, which can sometimes add more cost."
"Pricing needs improvement as the solution is expensive."
"I rate their support seven out of ten. It's costly when you enable support. The price is high for technical support."
"Should be made available across zones, like other Multi-AZ solutions."
"The solution is not easy to implement. It requires a lot of learning at the beginning."
"Not a ten because it's expensive and its ecosystem is not very open."
"Pricing would be a good improvement. A lot of customers think that it's very expensive and especially support is very expensive."
"It's complicated to use. You need to spend a lot of time learning about it. The interface could be improved. It's not intuitive to build a data model and use their ETL tools."
"The UI is not user-friendly."
"There should be a direct pipeline from Azure to SAP."
"In the next release, I would like to see their BI component introduced with a mobile version, as it is not currently present."
"The tool is not easy to use for an end user."
 

Pricing and Cost Advice

"The best part about this solution is the cost."
"The solution is available at a mid-range price compared to other vendors."
"BI is sold to our customer base as a part of the initial sales bundle. A customer may elect to opt for a white labeled site for an up-charge."
"For Amazon Redshift, we pay around INR 60,000 annually. The cost factor also depends on the number of existing customers."
"The cost will depend on how you set up your warehouse and what kind of data you store."
"On a scale of one to ten, where one is a low price and ten is a high price, I rate the pricing a seven."
"It's around $200 US dollars. There are some data transfer costs but it's minimal, around $20."
"If you want a fixed price, an to not worry about every query, but you need to manage your nodes personally, use Redshift."
"The tool is affordable."
"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."
"In general, it's quite expensive."
"As an investment, the solution is very expensive."
"The SAP HANA application still hasn't been leveraged to the fullest extent, but it's a five-year enterprise license."
"Price wise, this solution is on the higher side."
"The cost of ownership is higher. It's resource-intensive, and naturally, that increases costs."
"The solution is expensive."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
847,772 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
64%
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: April 2025.
847,772 professionals have used our research since 2012.