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

Amazon Redshift vs SAP BW4HANA comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Amazon Redshift
Average Rating
7.8
Reviews Sentiment
6.9
Number of Reviews
67
Ranking in other categories
Cloud Data Warehouse (4th)
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.
DilipRoshantha - PeerSpot reviewer
Offers good value for money to users
There have been no hiccups for my company when it comes to integrating SAP products with the data analytics and the transactional systems since my company uses SAP PI for it, but lately my organization has been using SAP Process Orchestration for data integration. With SAP, there is a small visualization part inside SAP BW4HANA. I can visualize some of the reports with the help of SAP BW4HANA. The tool can be configured and is compatible with all SAP applications, which makes it a good product. I believe that the product has the capabilities to cater to various business requirements. The product does offer value for money. There are big customers along with medium or small customers. Small and medium-sized customers cannot afford the cost of the tool's licensing. From a value point of view, in business terms, it is good. I rate the tool a nine out of ten.

Quotes from Members

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

Pros

"The valuable features are performance, data compression, and scalability."
"The solution is easy to set up and use."
"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."
"The ability to reload data multiple times at different times."
"I found the Amazon Redshift computing services easy. I found the computing instances the most incredible in the solution."
"Redshift is a major service of Amazon and is very scalable. It enables faster recalculations and data management, helping to retrieve data quickly."
"The stability of Amazon Redshift is good."
"Setup is easy. It's a fast solution with machine learning features, good integration, and a good API."
"The most valuable aspect of this solution is that the infrastructure is easy to understand."
"It's quite scalable."
"The most valuable feature is that we can transform a huge amount of data and apply business logic as per the requirements."
"It is a stable solution."
"The most valuable feature is the dashboard."
"The ability to instantly pull data is the most valuable feature."
"Provides a great analytics engine with all the capabilities."
"It is a very stable solution."
 

Cons

"The OLAP slide and dice features need to be improved."
"The refreshment rate of data reaching Redshift from other sources should be faster."
"Improvement in the immediate response and the process of getting into a call could be helpful."
"I would like to improve the pricing and the simplicity of using this solution."
"We recently moved from the DC2 cluster to the RA3 cluster, which is a different node type and we are finding some issues with the RA3 cluster regarding connection and processing. There is room for improvement in this area. We are in talks with AWS regarding the connection issues."
"The initial setup is a complex process, especially for someone who is not familiar with nodes and configuring terms like RPUs."
"It lacks a few features which can be very useful, such as stored procedures"
"It takes a lot of time to ingest and update the data."
"There should be a direct pipeline from Azure to SAP."
"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."
"There's one area where the other vendors have an upper edge, which is the data lake. I think SAP is trying to figure out whether to stick with IQ, their own data lake solution, or push customers toward customer-preferred vendors, like Azure Data Lake, AWS, or any other provider."
"There's the complexity in migration from BW to BW/4HANA, especially with data migration."
"The monitoring for the remodeling feature is very difficult to understand."
"We cannot integrate with third-party tools like Python or advanced integration options. You can't fine-tune tables within BW or generate specific views or reports."
"The solution is not easy to implement. It requires a lot of learning at the beginning."
"Support could be more reliable."
 

Pricing and Cost Advice

"If you want a fixed price, an to not worry about every query, but you need to manage your nodes personally, use Redshift."
"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."
"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."
"The product is quite expensive."
"The solution has very competitive pricing."
"For Amazon Redshift, we pay around INR 60,000 annually. The cost factor also depends on the number of existing customers."
"In comparison to the price of similar solutions, Redshift's cost is the lowest."
"The cost is comparable to Snowflake."
"This is an expensive solution and there are costs in addition to the standard licensing fees."
"For the on-premises version of the product, the solution offers a perpetual-based licensing model to its users. In general, SAP offers a monthly subscription-based licensing model to its users."
"The tool is affordable."
"It's a little expensive compared to Microsoft Azure."
"In general, it's quite expensive."
"The cost and licensing depends on how the customer is going to use the solution."
"The SAP HANA application still hasn't been leveraged to the fullest extent, but it's a five-year enterprise license."
"The cost of ownership is higher. It's resource-intensive, and naturally, that increases costs."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
824,067 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
62%
Financial Services Firm
7%
Computer Software Company
6%
Manufacturing Company
4%
Manufacturing Company
18%
Computer Software Company
10%
Financial Services Firm
8%
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: December 2024.
824,067 professionals have used our research since 2012.