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 most valuable feature of Amazon Redshift is its ability to handle really large sets of data."
"Has a very user-friendly SQL editor and it's very easy to use the connectors."
"Redshift's Excel features are handy. Redshift spectrum allows you to directly query the data on an Excel sheet. Now, SQL Server also allows this, but Redshift has many more features."
"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."
"In terms of valuable features, I like the columnar storage that Redshift provides. The storage is one of the key features that we're looking for. Also, the data updates and the latency between the data-refreshes."
"Redshift has an advantage when it comes to administration, making it easier to manage and collaborate."
"I found the Amazon Redshift computing services easy. I found the computing instances the most incredible in the solution."
"You can copy JSON to the column and have it analyzed using simple functions."
"The most valuable aspect of the solution is the integration with SAP ERP."
"The real-time information is great."
"In terms of stability, comparatively, the solution is quite stable."
"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."
"What I like most about SAP Business Warehouse is that it's a seamless integration platform. A valuable feature in the tool is the monitoring alert that makes you aware of what process chain has failed. There's no manual monitoring required if you have configured an alert system, so the process chain can run in the background, and you can get alerts about it. The functionalities I find good in SAP Business Warehouse are alerting and monitoring. If you have configured the tool and have integrated it with SAP Solution Manager, then it's a good product to use."
"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 useful feature has been he ability to feed data into multiple systems in various formats."
"Having the back-end data set with the right information is the best qualification for this solution."
"Running parallel queries results in poor performance and this needs to be improved."
"The product could be improved by making it more flexible."
"The technical support should be better in terms of their knowledge, and they should be more customer-friendly."
"The refreshment rate of data reaching Redshift from other sources should be faster."
"It takes a lot of time to ingest and update the data."
"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."
"They should provide a better way to work with interim data in a structured way than to store it in parquet files locally."
"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."
"The solution should be more open to the cloud."
"It takes more work to get the data, including reporting on that data, because some coding is required, and a significant level of transformation is needed when using SAP Business Warehouse."
"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."
"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."
"There is room for improvement from a technical perspective."
"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."
"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."
"They should reduce the product’s installation package size for easier downloading."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 24 reviews while SAP Business Warehouse is ranked 8th in Cloud Data Warehouse with 13 reviews. Amazon Redshift is rated 7.8, while SAP Business Warehouse is rated 7.8. The top reviewer of Amazon Redshift writes "A cost-effective warehouse solution that needs to improve the access limitations". 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, Microsoft Azure Synapse Analytics, Vertica and Teradata, 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.