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."I find the most valuable features to be the MPP style of processing, which mostly all of the data warehouses provide. The ability to integrate all other AWS services, such as NSS and S3, with little effort is very helpful. The service is well maintained, there are update patches frequently."
"The most valuable feature is the scalability, as it grows according to our needs."
"The most valuable feature is its scalability."
"I like it because the usage is very similar to Microsoft SQL server. The structure of the query and the temporary tables are very similar."
"I have primarily used the Redshift Spectrum feature and found it most valuable."
"Redshift Spectrum is the most valuable feature."
"Redshift COPY command, because much of my work involved helping customers migrate large amounts of data into Redshift."
"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."
"We benefited from BW/4HANA's ability to utilize predefined content inside. We didn't need to start from scratch."
"The most valuable aspect of this solution is that the infrastructure is easy to understand."
"We can get good visualization and less redundant data."
"It is a stable solution."
"Out of the box, this solution has a lot of standard features."
"I like that it's quite quick."
"We like that it is an SAP product, so we can easily connect with the SAP ERP system."
"The solution seamlessly integrates with SAP products."
"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."
"There is some missing functionality and sometimes it's so difficult to work in. We need to convert these functionalities using VACUUM inside Amazon Redshift and then it causes some complexity."
"There are physically too many pipelines for a company of this size to maintain. For a data scientist, it's very difficult to learn the data in all of these different environments."
"I would like to improve the pricing and the simplicity of using this solution."
"The solution could improve in handling more data formats and more native support for RDF."
"Query compilation time needs a lot of improvement for cases where you are generating queries dynamically."
"There are too many limitations with respect to concurrency."
"In the solution, user-based access is quite hard. In general, certain permissions are difficult to manage."
"Price wise, this solution is on the higher side."
"The product needs to improve with more performance and fewer data layers."
"I would like more integration."
"Not a ten because it's expensive and its ecosystem is not very open."
"Support could be more reliable."
"The tool is not cloud-compatible."
"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 solution is not easy to implement. It requires a lot of learning at the beginning."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 58 reviews while SAP BW4HANA is ranked 7th in Data Warehouse with 34 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 AWS Lake Formation, Snowflake, Teradata, 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.