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."It's very easy to migrate from other databases to Redshift. There are migration tools dedicated for this purpose, enabling migration from other databases like MS SQL directly to Redshift. The majority of the scripts will be automatically transposed."
"The most valuable features are that it's easy to set up and easy to connect the many tools that connect to it."
"Redshift has an advantage when it comes to administration, making it easier to manage and collaborate."
"Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."
"I found the Amazon Redshift computing services easy. I found the computing instances the most incredible in the solution."
"The most valuable feature is the scalability, as it grows according to our needs."
"For the on-premises version of Amazon Redshift, we need to start from scratch. However, 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."
"The solution has very competitive pricing."
"It is a very stable solution."
"It's quite scalable."
"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."
"Some of the main features of this solution are that it uses HANA and it has good performance."
"The product has efficient performance."
"From an ERP point of view and a functionality point of view, it works very well. The benefits are in that of financial costing and material management."
"The most valuable feature is the dashboard."
"The product is stable."
"Planting is the primary key enforcement that should be improved."
"We are using third-party tools to integrate Amazon Redshift, they should create their own interface on their own for it to be easily connected on the AWS itself."
"Infinite storage is available in Snowflake and is not available in Redshift."
"Amazon should provide more cloud-native tools that can integrate with Redshift like Microsoft's development tools for Azure."
"The initial deployment was complex."
"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."
"The refreshment rate of data reaching Redshift from other sources should be faster."
"Should be made available across zones, like other Multi-AZ solutions."
"The speed of operations could be a little faster."
"Price wise, this solution is on the higher side."
"I don't see SAP actively supporting the solution now...a better support from SAP would be appreciated."
"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."
"I cannot integrate it with my other tools. It's not possible to do something in the predictive analysis. Mobile reporting is also not available."
"The tool is not easy to use for an end user."
"I would like more integration."
"BW/4HANA could improve query optimization. For example, there could be an error message that pops up when you hover over it if any query fails. That would make it easier to find out what went gone wrong. Guided SAP help tools would make it easier for us to go forward."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 61 reviews while SAP BW4HANA is ranked 8th in Data Warehouse with 37 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 "Performs all necessary data warehouse tasks and offers additional functionalities". Amazon Redshift is most compared with Teradata, Vertica, Snowflake, Microsoft Azure Synapse Analytics and Teradata Cloud Data Warehouse, whereas SAP BW4HANA is most compared with Microsoft Azure Synapse Analytics, Snowflake, SAP HANA, SQL Server and SAP 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.