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."
"Easy to build out our snowflake design and load data."
"The most valuable feature is that the solution is fully embedded in the AWS stack."
"The initial setup is easy."
"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."
"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."
"Amazon Redshift offers a relatively flexible structure...I rate the technical support a nine out of ten."
"This service can merge and integrate well with all databases."
"The solution's performance is really good. Also, it's easy to operate, easy to administer, and relatively simple to install."
"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."
"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 can calculate data in detail. Before we could not calculate financial documents and accountant documents in detail, we could not do it at a document level but now we can. This is the most important feature. It also has predictive analysis memory."
"The product is stable."
"Its direct approach is the most valuable. You get more real time and capabilities than BW."
"Out of the box, this solution has a lot of standard features."
"The refreshment rate of data reaching Redshift from other sources should be faster."
"Amazon Redshift is a little more expensive than other products."
"Migrating data from other data sources can be challenging when you are working with multibyte character sets."
"I would like to improve the pricing and the simplicity of using this solution."
"When working with third-party services requires additional integrations and configurations, which can sometimes add more cost."
"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."
"Running parallel queries results in poor performance and this needs to be improved."
"The customer support could be more responsive."
"The tool is not easy to use for an end user."
"There's the complexity in migration from BW to BW/4HANA, especially with data migration."
"Pricing would be a good improvement. A lot of customers think that it's very expensive and especially support is very expensive."
"Price wise, this solution is on the higher side."
"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."
"It takes too long to escalate problems from the first level of support."
"I would like more integration."
"I would like to be able to design new reports in a future release."
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.