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."Amazon Redshift is very fast. It has really good response times. It's very user-friendly."
"The main benefit is that our portal for end users is running in AWS, so we can easily connect it to other AWS services."
"I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing."
"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."
"The most valuable feature is its scalability."
"The most valuable features are that it's easy to set up and easy to connect the many tools that connect to it."
"Has a very user-friendly SQL editor and it's very easy to use the connectors."
"Easy to build out our snowflake design and load data."
"The processes are the most valuable aspect of this solution."
"The most valuable aspect of this solution is that the infrastructure is easy to understand."
"It is a stable solution...The initial setup was easy."
"The most valuable feature is that we can transform a huge amount of data and apply business logic as per the requirements."
"Provides a great analytics engine with all the capabilities."
"We like that it is an SAP product, so we can easily connect with the SAP ERP system."
"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 is a stable solution."
"One area where Amazon Redshift could improve is in adopting the compute-separate, data-separate architecture, which Delta, Snowflake are adopting, and a few others in the cloud data warehouse spectrum."
"For people who struggle with IAM or role-based management, the setup isn't easy."
"The initial deployment was complex."
"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."
"Pricing is one of the things that it could improve. It should be more competitive."
"Planting is the primary key enforcement that should be improved."
"It would be useful to have an option where all of the data can be queried at once and then have the result shown."
"It lacks a few features which can be very useful, such as stored procedures"
"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."
"Other competitors provide better solutions that are more up to date with current technology."
"There's the complexity in migration from BW to BW/4HANA, especially with data migration."
"One thing that could be enhanced in SAP BW4HANA is the user interface for process chains."
"The monitoring for the remodeling feature is very difficult to understand."
"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."
"The cost of the product might be an area that might introduce some restrictions or limitations to customers, making it one of the aspects where improvements are required."
"If I want to have good reporting, then I have to buy a separate license."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 59 reviews while SAP BW4HANA is ranked 7th in Data Warehouse with 36 reviews. Amazon Redshift is rated 7.8, while SAP BW4HANA is rated 7.4. The top reviewer of Amazon Redshift writes "Provides one place where we can store data, and allows us to easily connect to other services with AWS". On the other hand, the top reviewer of SAP BW4HANA writes "An easy-to-operate and administer tool that needs to consider revising its existing licensing cost". Amazon Redshift is most compared with Snowflake, Teradata, AWS Lake Formation, Vertica and Teradata Cloud Data Warehouse, whereas SAP BW4HANA is most compared with Microsoft Azure Synapse Analytics, Snowflake, SAP HANA, SQL Server and SAP NetWeaver Business Warehouse. 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.