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 found the Amazon Redshift computing services easy. I found the computing instances the most incredible in the solution."
"The ability to reload data multiple times at different times."
"The product is relatively easy to use because there is no indexing and no partitions."
"You can copy JSON to the column and have it analyzed using simple functions."
"Redshift allows you to transform different data formats and consolidate them into one Redshift cluster. This means you can transform various siloed data sources like Excel files and CSV files into Redshift."
"It is quite simple to use and there are no issues with creating the tables."
"Has a very user-friendly SQL editor and it's very easy to use the connectors."
"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."
"We can get good visualization and less redundant data."
"It is a stable solution...The initial setup was easy."
"The product is stable."
"The most valuable aspect of this solution is that the infrastructure is easy to understand."
"It is a stable solution...It is a scalable solution."
"The processes are the most valuable aspect of this solution."
"I like the reporting features of the solution."
"The solution seamlessly integrates with SAP products."
"It lacks a few features which can be very useful, such as stored procedures"
"Amazon Redshift does not have the capability to dynamically increase the VM file."
"It takes a lot of time to ingest and update the data."
"What would make Amazon Redshift better is improvising on the pricing structure. For example, Acronis provides backups in cybersecurity, yet the pricing is a bit lesser than Amazon Redshift."
"This solution lacks integration with non-AWS sources."
"The solution has four maintenance windows so, when it comes to stability, I think it would be better to decrease their number."
"The refreshment rate of data reaching Redshift from other sources should be faster."
"Amazon Redshift could improve the user interface support."
"The solution does occasionally get a few bugs, but this is typical for any product."
"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 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."
"The monitoring for the remodeling feature is very difficult to understand."
"Support could be more reliable."
"The speed of operations could be a little faster."
"Pricing would be a good improvement. A lot of customers think that it's very expensive and especially support is very expensive."
"The tool is not easy to use for an end user."
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, Vertica, Teradata 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.