Amazon Redshift vs SAP BW4HANA comparison

Amazon Web Services (AWS) and SAP are both solutions in the Data Warehouse category. Additionally, 85% of Amazon Web Services (AWS) users are willing to recommend the solution, compared to 86% of SAP users who would recommend it.

Amazon Redshift

Read 66 Amazon Redshift reviews

6,278 Views
4,381 Comparison Views

85% willing to recommend

SAP BW4HANA

Read 42 SAP BW4HANA reviews

1,740 Views
1,177 Comparison Views

86% willing to recommend

Amazon Redshift

SAP BW4HANA

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Amazon Redshift and SAP BW4HANA based on real PeerSpot user reviews.

Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed Amazon Redshift vs. SAP BW4HANA Report (Updated: October 2024).

Buyer's Guide

Amazon Redshift vs. SAP BW4HANA

October 2024

Download the complete report

Helped 816,406 peers since 2012

Categories and Ranking

Amazon Redshift

Average Rating

7.8

Reviews Sentiment

7.4

Number of Reviews

Ranking in other categories

Cloud Data Warehouse (4th)

SAP BW4HANA

Average Rating

7.6

Reviews Sentiment

7.5

Number of Reviews

Ranking in other categories

Data Warehouse (9th)

Featured Reviews

Ved Prakash Yadav

Senior Data Platform Manager at a manufacturing company with 10,001+ employees

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.

Read full review

DilipRoshantha

Head Of Information Technology at Noratel

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.

Read full review

Quotes from Members

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

Pros

"Redshift's versioning and data security are the two most critical features. When migrating into the cloud, it's vital to secure the data. The encryption and security are there."

"The most valuable feature is that the solution is fully embedded in the AWS stack."

"The solution's flexibility is its most valuable feature. It's also easy to scale and has relatively painless pricing."

"Redshift Spectrum is the most valuable feature."

"The main benefit is that our portal for end users is running in AWS, so we can easily connect it to other AWS services."

"Amazon Redshift offers a relatively flexible structure...I rate the technical support a nine out of ten."

"Setup is easy. It's a fast solution with machine learning features, good integration, and a good API."

"The feature that we find most useful is the ability to do analytics on the fly."

More Amazon Redshift pros

"I like the tool's robustness and security."

"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."

"It is a stable solution...The initial setup was easy."

"The most valuable aspect of this solution is that the infrastructure is easy to understand."

"We like that it is an SAP product, so we can easily connect with the SAP ERP system."

"Provides a great analytics engine with all the capabilities."

"I like that it's quite quick."

"The solution is based on SAP ERP, so there's some business content already included. For customers who use SAP ERP, SAP BW4HANA is a good choice for their DW implementation."

More SAP BW4HANA pros

Cons

"The explain panel in the Redshift database could be better."

"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."

"It is difficult to work with unstructured data and JSON documents."

"I would like to improve the pricing and the simplicity of using this solution."

"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."

"Redshift's GUI could be more user-friendly. It's easier to perform queries and all that stuff in Azure Synapse Analytics."

"Improvement could be made in the area of streaming data."

"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."

More Amazon Redshift cons

"They have taken out a few BW functionalities when they redesigned this. The way of multi-dimensional thinking and star schema got a little bit lost. It may be because of the cost, but certain functionalities that were previously implemented from the BW side should come back again in the whole product. It is a young product. It is version 2.0. In time, I'm pretty sure they will come back again because otherwise, it limits the potential of the product, and I have to do a lot of modeling towards that direction. For me, the analytics focus is too much. It is not cube-oriented in that way, so its functionality is limited. It is not really technically limited in the back end; it is more limited in the front end. It has a data-mining mindset for SQL developers. The navigational attributes should be easy. It needs to be built in models. I see the data mark cube or understanding that the composite provider needs to be models in a cube coming back. The multi-dimensional star schema approach and the reporting need to be done as well as possible to leverage the star scheme below. This is definitely not understood by many consultants and even composite providers for star schema. They always think in terms of flat tables, which is limiting. You need to build the right dimensions, objects, and so on. If you can build this in BW4HANA, then you have this understanding that BW4HANA is not forcing you in this direction, but it should force you a bit better in this direction. Maybe a few elements which were in use in BW should come back again. It would help the community to determine the direction to build on the cube. You can have maybe 50 elements, and then you can expand it to what you need by leveraging navigation. So far, this functionality is a little bit limited in the tool, and it is not thought through, but I think it will come. They should also be adding more capabilities for the transformation between different objects. In BW, this is currently limited, especially towards composite providers. It is a bit complex basically in the building. You have to have a lot of knowledge as well as know how to do it better because it is a bit different from BW. There is not too much expertise currently in the consulting markets. Many are trying to build something, but it may be based on their knowledge of what they have from the BW and HANA side. You have to find the right mix from both of them at this time. We also have HANA Native. These are our two different sync sources basically, and we have approaches to connect nicely, but it is hard to manage your team because a lot of coaching is required."

"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."

"Connecting multiple sources is a challenge because you have to go through a lot of different setups."

"There should be a direct pipeline from Azure to SAP."

"The monitoring for the remodeling feature is very difficult to understand."

"The problem is the expensive pricing of technical support, making it an area where improvements are required."

"From a technical perspective, it could be even more related to legacy systems. The connectivity requirement is quite high and requires systems that are up-to-date."

"The speed of operations could be a little faster."

More SAP BW4HANA cons

Pricing and Cost Advice

"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 cost is comparable to Snowflake."

"The pricing is reasonable."

"At the moment, pricing is a little bit on the higher side, although it depends on the size of the company."

"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."

"It's pay per use. You can have multiple models."

"Amazon Redshift is an expensive solution. Larger organizations can afford this solution, but smaller businesses would struggle to afford it."

More Amazon Redshift pricing and cost advice

"It is an expensive product."

"The SAP HANA application still hasn't been leveraged to the fullest extent, but it's a five-year enterprise license."

"We have a broad licensing arrangement, which is expensive but worth it for sizeable businesses."

"The cost and licensing depends on how the customer is going to use the solution."

"This is an expensive solution and there are costs in addition to the standard licensing fees."

"SAP BW/4HANA 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."

"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."

More SAP BW4HANA pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.

See recommendations

816,406 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Educational Organization

60%

Financial Services Firm

Computer Software Company

Manufacturing Company

18%

Computer Software Company

11%

Financial Services Firm

Energy/Utilities Company

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

See all answers

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.

See all answers

What is your experience regarding pricing and costs for Amazon Redshift?

You can start small with a basic cluster to learn and practice with it. Selecting the most basic and economical cluster type can save you enough money to move forward with the solution or go with a...

See all answers

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

See all answers

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.

See all answers

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.

See all answers

Comparisons

Teradata vs Amazon Redshift

Compared 15% of the time

Oracle Exadata vs Amazon Redshift

Compared 11% of the time

Snowflake vs Amazon Redshift

Compared 11% of the time

Vertica vs Amazon Redshift

Compared 10% of the time

Amazon EMR vs Amazon Redshift

Compared 4% of the time

More Amazon Redshift Competitors

Microsoft Azure Synapse Analytics vs SAP BW4HANA

Compared 33% of the time

Snowflake vs SAP BW4HANA

Compared 27% of the time

SAP HANA vs SAP BW4HANA

Compared 10% of the time

SQL Server vs SAP BW4HANA

Compared 7% of the time

SAP IQ vs SAP BW4HANA

Compared 3% of the time

More SAP BW4HANA Competitors

Product Reports

Buyer's Guide

Amazon Redshift

November 2024

Download Amazon Redshift product report

Buyer's Guide

SAP BW4HANA

October 2024

Download SAP BW4HANA product report

Also Known As

No data available

SAP BW/4HANA

Learn More

Amazon Web Services (AWS)

SAP

Overview

What is Amazon Redshift?

Amazon Redshift is a fully administered, petabyte-scale cloud-based data warehouse service. Users are able to begin with a minimal amount of gigabytes of data and can easily scale up to a petabyte or more as needed. This will enable them to utilize their own data to develop new intuitions on how to improve business processes and client relations.

Initially, users start to develop a data warehouse by initiating what is called an Amazon Redshift cluster or a set of nodes. Once the cluster has been provisioned, users can seamlessly upload data sets, and then begin to perform data analysis queries. Amazon Redshift delivers super-fast query performance, regardless of size, utilizing the exact SQL-based tools and BI applications that most users are already working with today.

The Amazon Redshift service performs all of the work of setting up, operating, and scaling a data warehouse. These tasks include provisioning capacity, monitoring and backing up the cluster, and applying patches and upgrades to the Amazon Redshift engine.

Amazon Redshift Functionalities

Amazon Redshift has many valuable key functionalities. Some of its most useful functionalities include:

Cluster administration: The Amazon Redshift cluster is a group of nodes that contains a leader node and one (or more) compute node(s). The compute nodes needed are dependent on the data size, amount of queries needed, and the query execution functionality desired.
Cluster snapshots: Snapshots are backups of a cluster from an exact point in time. Amazon Redshift offers two types of snapshots: manual and automated. Amazon will store these snapshots internally in the Amazon Simple Storage Service (Amazon S3) utilizing an SSL connection. Whenever a Snapshot restore is needed, Amazon Redshift will create a new cluster and will import data from the snapshot as directed.
Cluster access: Amazon Redshift provides several intuitive features to help define connectivity rules, encrypt data and connections, and control the overall access of your cluster.
IAM credentials and AWS accounts: The Amazon Redshift cluster is only accessible by the AWS account that created the cluster. This automatically secures the cluster and keeps it safe. Inside the AWS account, users access the AWS Identity and IAM protocol to create additional user accounts and manage permissions, granting specified users the desired access needed to control cluster performance.
Encryption: Users have the option to choose to encrypt the clusters for additional added security once the cluster is provisioned. When encryption is enabled, Amazon Redshift will store all the data in user-created tables in a secure encrypted format. To manage Amazon Redshift encryption keys, users will access AWS Key Management Service (AWS KMS).

Reviews from Real Users

“Redshift's versioning and data security are the two most critical features. When migrating into the cloud, it's vital to secure the data. The encryption and security are there.” - Kundan A., Senior Consultant at Dynamic Elements AS

“With the cloud version whenever you want to deploy, you can scale up, and down, and it has a data warehousing capability. Redshift has many features. They have enriched and elaborate documentation that is helpful.”- Aishwarya K., Solution Architect at Capgemini

SAP BW4HANA is a data warehouse solution developed by SAP for businesses looking to analyze big data in real time. It is designed to run on the SAP HANA database, offering improved performance and optimized processing of large data sets. SAP BW/4HANA provides an array of advanced analytics capabilities, including predictive analytics, text analytics, and spatial data processing. It also offers a modern, intuitive user interface and streamlined data modeling and administration tools, making it easier for businesses to access, manage, and utilize their data.

SAP BW4HANA Features

SAP BW4HANA has many valuable key features. Some of the most useful ones include:

In-memory data processing: The solution runs on the SAP HANA database, providing fast and efficient data processing.

Advanced analytics: SAP BW4HANA includes capabilities for predictive analytics, text analytics, and spatial data processing.

Data modeling and administration: The solution provides streamlined data modeling and administration tools for efficient data management.

Modern user interface: SAP BW4HAN is designed with a modern, intuitive user interface for easier data access and analysis.

Data warehousing optimization: The solution is optimized for big data warehousing, offering improved performance and scalability.

Integration with SAP ecosystem: SAP BW4HAN integrates with the SAP ecosystem, including SAP S/4HANA and SAP Cloud Platform, for seamless data exchange.

Real-time data processing: It supports real-time data processing and analysis, enabling businesses to make data-driven decisions.

Data governance and security: With its robust data governance and security features, SAP BW4HAN can be used for secure data management and compliance.

Automated data loading: SAP BW4HAN supports automated data loading from various sources, including SAP and non-SAP systems.

Advanced data visualization: With its advanced data visualization capabilities, users can generate better data insights and make more informed business decisions.

SAP BW4HANA Benefits

There are many benefits to implementing SAP BW4HANA. Some of the biggest advantages the solution offers include:

Improved data processing speed: Running on the SAP HANA database, SAP BW/4HANA provides fast and efficient data processing, resulting in improved performance and reduced downtime.

Streamlined data management: The solution's streamlined data modeling and administration tools make it easier for organizations to manage their data, improving overall efficiency and reducing the risk of errors.

Improved data governance: SAP BW/4HANA includes robust data governance and security features, helping organizations meet regulatory requirements and protect sensitive data.

Cost savings: By optimizing data warehousing processes, SAP BW/4HANA helps organizations reduce costs and improve their bottom line.

Reviews from Real Users

SAP BW4HANA is a solution that stands out when compared to many of its competitors. Some of its major advantages are its hierarchical alert slicing, real-time insights, and its ability to transform large amounts of data.

PeerSpot reviewer, Srivatsav A., SAP BW/4HANA Specialist at a government, is very happy with the solution. He explains, "You can do hierarchical alert slicing and dicing out-of-box, which is not available in other solutions. I haven't come across that in Oracle or any other software provider."

“It has got wonderful features in terms of analyzing your production data, and it gives you real-time insight into productive maintenance. You can plan your budget, and you can map them against actuals. It gives you good insights on overall performance and processes,” says Amrit J., ERP Application Manager at an energy/utilities company.

In addition, a Technology Analyst at a tech services company mentions, "The most valuable feature is that we can transform a huge amount of data and apply business logic as per the requirements."

Sample Customers

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449

Information Not Available

Buyer's Guide

Amazon Redshift vs. SAP BW4HANA

October 2024

Free Report: Amazon Redshift vs. SAP BW4HANA

Find out what your peers are saying about Amazon Redshift vs. SAP BW4HANA and other solutions. Updated: October 2024.

DOWNLOAD NOW

816,406 professionals have used our research since 2012.

See our Amazon Redshift vs. SAP BW4HANA report.

See our list of best Data Warehouse vendors.

We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.