We performed a comparison between Amazon Redshift and SAP Business Warehouse based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The main benefit is that our portal for end users is running in AWS, so we can easily connect it to other AWS services."
"The most valuable feature of Redshift is its cluster."
"The initial setup of this solution is straightforward."
"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 feature that we find most useful is the ability to do analytics on the fly."
"The most valuable feature is that the solution is fully embedded in the AWS stack."
"It is very easy to dump data into the tool."
"The stability of Amazon Redshift is good."
"Out-of-the-box reports are very useful."
"The most valuable feature of this solution is the advanced structuring of data capabilities. You can get different structures of data to suit your needs."
"SAP Business Warehouse is a scalable solution."
"The warehouse is the solution's most valuable feature."
"With the technical support, the response has been pretty good from the SAP side."
"The most valuable feature of SAP Business Warehouse is its hybrid functionality, allowing users to leverage both SQL-based data warehouse capabilities from HANA and feature-based data warehousing from BW."
"Now, because of the HANA integration, the hard disk and RAM are together, and because of that, the output is very quick and very fast actually."
"The product is very stable."
"In the solution, user-based access is quite hard. In general, certain permissions are difficult to manage."
"Pricing is one of the things that it could improve. It should be more competitive."
"The product must provide new indexes that support special data structures or data types like TEXT."
"Amazon Redshift could improve the user interface support."
"The solution is unable to work fast."
"Sometimes, it's difficult to get the metadata from Redshift."
"The solution has four maintenance windows so, when it comes to stability, I think it would be better to decrease their number."
"We recently moved from the DC2 cluster to the RA3 cluster, which is a different node type and we are finding some issues with the RA3 cluster regarding connection and processing. There is room for improvement in this area. We are in talks with AWS regarding the connection issues."
"What I'd like to improve in SAP Business Warehouse is its data structure, that's a little bit rigid. It could be a bit more flexible, so you can design your data structure and improve performance when creating a solution. Currently, the way data is stored in SAP Business Warehouse is rigid."
"SAP Business Warehouse could improve by having more out-of-the-box use cases to cover more business types or operations."
"The advanced structuring can be complicated and the interface is not very intuitive."
"We are very unhappy with technical support. First of all, they send their sales agents or pre-sales agents and most of them who don't know the solution as a properly trained tech would. We have an on-site SAP representative who is supposed to help us with our high priority and production issues, and they're not satisfactory to say the least."
"I would like to see a different end solution in order to read the data and attract internal users."
"In the next release, my suggestion would be to have user-friendly interfaces and performance issues be addressed."
"A few things which are missing include the visualization of reports. That's where your costs and licensing become heavy. When it comes to this database compared Microsoft Warehouse, it's an expensive solution."
"What I'd like improved in SAP Business Warehouse is its setup. It could be more flexible, and it could be a configuration-based setup."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 61 reviews while SAP Business Warehouse is ranked 9th in Cloud Data Warehouse with 25 reviews. Amazon Redshift is rated 7.8, while SAP Business Warehouse is rated 7.8. 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 Business Warehouse writes "Offers powerful analytics and integration capabilities but requires improved upgrade processes". Amazon Redshift is most compared with Teradata, Snowflake, AWS Lake Formation, Vertica and Microsoft Azure Synapse Analytics, whereas SAP Business Warehouse is most compared with Microsoft Azure Synapse Analytics, Snowflake, BigQuery and SAP BW4HANA. See our Amazon Redshift vs. SAP Business Warehouse report.
See our list of best Cloud Data Warehouse vendors.
We monitor all Cloud 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.