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."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 main benefit is that our portal for end users is running in AWS, so we can easily connect it to other AWS services."
"The valuable features are performance, data compression, and scalability."
"I found the Amazon Redshift computing services easy. I found the computing instances the most incredible in the solution."
"The product offers good support for the data lake."
"The processing of data is very fast."
"The most valuable feature of Redshift is its cluster."
"Redshift has an advantage when it comes to administration, making it easier to manage and collaborate."
"With the technical support, the response has been pretty good from the SAP side."
"The real-time information is great."
"SAP Business Warehouse is a scalable solution."
"The features that I have found most valuable are its capabilities to connect to Excel and to slice and dice."
"The key element in this solution is its rapid response. If you have a question about prices, buyers, customers, providers, or services, you need the answer in a minute or two. That's the key benefit for us that a solution like BW gives us."
"The most valuable feature of SAP Business Warehouse is transformation, where I extract data from different sources, particularly the raw data. Then I do some transformations and store that in a format that allows me to do reporting easily."
"The product is very stable."
"Predominantly, our company uses SAP Business Warehouse for reporting purposes across various departments, especially for managers to gain a quick understanding of their current standing and make informed decisions."
"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."
"The product must become a bit more serverless."
"Planting is the primary key enforcement that should be improved."
"Compatibility with other products, for example, Microsoft and Google, is a bit difficult because each one of them wants to be isolated with their solutions."
"If you require a highly scalable solution, I would not recommend Amazon Redshift."
"Query compilation time needs a lot of improvement for cases where you are generating queries dynamically."
"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."
"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."
"You can start quickly but, when you have to get a little more detailed, when you have to change something, when you have to solve problems, it's not that easy. It's easy to start but evolving is not that easy."
"The way the data is stored is kind of rigid in SAP BW as a product. It could be more flexible so that when we are designing a solution, we can design our own data structures and try to improve performance."
"SAP Business Warehouse could integrate better with other ETL tools."
"It's a product that is at the end of life so they will not improve it anymore."
"The problem with BW, and the factor that differentiated it from the original BW, is that you only get limited functionality with your runtime license. So, you have to pay extra for extracting data."
"The solution should be more open to the cloud."
"Areas for improvement in SAP Business Warehouse include enhancing scheduling and monitoring tools, as well as improving communication about hidden features to make them more accessible to users."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 58 reviews while SAP Business Warehouse is ranked 8th 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 AWS Lake Formation, Snowflake, Teradata, Vertica and Microsoft Azure Synapse Analytics, whereas SAP Business Warehouse is most compared with Microsoft Azure Synapse Analytics, Snowflake, BigQuery, SAP BW4HANA and SAP NetWeaver Business Warehouse. 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.