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."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."
"The initial setup of this solution is straightforward."
"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."
"We have found Machine Learning use cases are very nice."
"The solution's flexibility is its most valuable feature. It's also easy to scale and has relatively painless pricing."
"Easy to build out our snowflake design and load data."
"Redshift has an advantage when it comes to administration, making it easier to manage and collaborate."
"Though Amazon Redshift is good, it depends on what kind of business you're trying to do, what type of analytics you need, and how much data you have."
"Some of the main features of this solution are that it uses HANA and it has good performance."
"The product is stable."
"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 most valuable aspect of this solution is that the infrastructure is easy to understand."
"It is a stable solution...The initial setup was easy."
"Its direct approach is the most valuable. You get more real time and capabilities than BW."
"The solution's performance is really good. Also, it's easy to operate, easy to administer, and relatively simple to install."
"The solution seamlessly integrates with SAP products."
"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."
"Amazon Redshift does not have the capability to dynamically increase the VM file."
"The customer support could be more responsive."
"Improvement could be made in the area of streaming data."
"Migrating data from other data sources can be challenging when you are working with multibyte character sets."
"This solution lacks integration with non-AWS sources."
"In our experiments, the handling of unstructured data was not very smooth."
"The solution is unable to work fast."
"There's one area where the other vendors have an upper edge, which is the data lake. I think SAP is trying to figure out whether to stick with IQ, their own data lake solution, or push customers toward customer-preferred vendors, like Azure Data Lake, AWS, or any other provider."
"Pricing would be a good improvement. A lot of customers think that it's very expensive and especially support is very expensive."
"It's complicated to use. You need to spend a lot of time learning about it. The interface could be improved. It's not intuitive to build a data model and use their ETL tools."
"Support could be more reliable."
"From a technical perspective, it could be even more related to legacy systems. The connectivity requirement is quite high and requires systems that are up-to-date."
"The dashboard should be simplified and made easier for exploration and decision making."
"I don't see SAP actively supporting the solution now...a better support from SAP would be appreciated."
"The UI is not user-friendly."
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.