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."Redshift's versioning and data security are the two most critical features. When migrating into the cloud, it's vital to secure the data. The encryption and security are there."
"The stability of Amazon Redshift is good."
"The solution's flexibility is its most valuable feature. It's also easy to scale and has relatively painless pricing."
"I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing."
"If the analyst knows SQL, which is comfortable and easy to use to go between all of these tool stacks, I think it's reliable. It's a secure and reliable data warehouse."
"The ability to reload data multiple times at different times."
"The most valuable feature is the scalability, as it grows according to our needs."
"Easy to build out our snowflake design and load data."
"What I like most about SAP Business Warehouse is its ability to feed data into new, multiple systems in various formats. It can open its data to any system over gateway services or a portal or application that needs to consume and analyze data."
"The product is very stable."
"Having the integration with the reporting tool which is provided by SAP is great."
"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."
"The most useful feature is definitely the speed."
"With the technical support, the response has been pretty good from the SAP side."
"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 warehouse is the solution's most valuable feature."
"Amazon Redshift could improve the user interface support."
"One area where Amazon Redshift could improve is in adopting the compute-separate, data-separate architecture, which Delta, Snowflake are adopting, and a few others in the cloud data warehouse spectrum."
"Migrating data from other data sources can be challenging when you are working with multibyte character sets."
"The product must become a bit more serverless."
"It would be good to see Redshift as a serverless offering."
"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."
"The explain panel in the Redshift database could be better."
"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."
"It's a product that is at the end of life so they will not improve it anymore."
"The solution should be more open to the cloud."
"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."
"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."
"I'm not sure if our issue is related to BW or the Analysis Office. However, we're having performance issues in terms of time. It takes a long time to generate the report."
"So far, the initial setup process in our company has not been easy enough for us to understand."
"I would like to see a different end solution in order to read the data and attract internal users."
"There is room for improvement from a technical perspective."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 59 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 Snowflake, Teradata, 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.