We performed a comparison between Microsoft Azure Synapse Analytics 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."The setup is pretty simple."
"The most valuable feature of Microsoft Azure Synapse Analytics is its integration with the new legacy systems. Whatever application we want to integrate, we receive the reports based on the objects. The solution is easy to purchase from the cloud."
"They are available on the Cloud, and the platform is very intuitive."
"The stability is pretty good."
"The solution handles single or complex items within a second."
"The product works well with other Azure products."
"The most valuable feature of Microsoft Azure Synapse Analytics is the pipeline that is the ETL tool. It's very well designed and is overall very good. We usually don't use the ETL tool in Databricks, but we use the ETL tool in this solution."
"The most valuable feature is that you can suspend the computer if it is not being used, which means that you don't incur costs."
"I like how it blends no-code and ABAP code for complex transformations during data loading."
"I like that it's quite quick."
"The solution is easier to maintain than traditional SAP products."
"It is a stable solution...It is a scalable solution."
"We can get good visualization and less redundant data."
"One significant advantage of SAP BW/4HANA is the direct integration with the SAP HANA database, providing seamless access to real-time analytics. Additionally, it enables real-time data integration. We don't need to rely on historical data alone; we can provide reporting and features based on real-time information."
"I like the reporting features of the solution."
"The ability to instantly pull data is the most valuable feature."
"I would like my team to be able to build pipelines that integrate with the Azure Data Factory."
"Microsoft should develop an interface to make it easier to shift from on-premise to the cloud."
"I am a researcher. For people to be able to research a solution, there should be at least a free trial. Just advertising a product or saying that this product is better doesn't work. I would strongly recommend providing a lot of free trials and trainings. This will also help Microsoft in having more users or customers. Oracle provides some free trials. You can just go for a free trial and use your database online, which is very good."
"Integration with other products is an area that can be improved."
"In the future, Microsoft Azure Synapse Analytics has the potential to enhance its capabilities by expanding its connectors, specifically with regard to Oracle solutions, such as operating systems. This would involve a comprehensive approach to adding more connectors for both data input and consumption purposes. By doing so, Microsoft Azure Synapse Analytics would be better equipped to meet the diverse needs of its users and achieve greater efficiency in its performance. The provision of more connectors is definitely a crucial area that needs improvement."
"There is a limit on the number of concurrent queries to around 125 for Azure Synapse."
"The solution does not support oriented scaling in the synapse."
"Microsoft Azure Synapse Analytics could improve its compatibility with Visual Studio. One of the challenges for people moving from an on-premise to a cloud solution, such as Microsoft Azure Synapse Analytics, is that you're constantly working in a browser. There are people that have been working for decades on desktop applications. For them to start working in a browser, it's quite a change. Allowing people to work and do their work inside Visual Studio than in the browser, would be a large advantage."
"The solution is not scalable. It does not have a data streaming feature as well."
"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 product needs to improve with more performance and fewer data layers."
"The solution does occasionally get a few bugs, but this is typical for any product."
"There's the complexity in migration from BW to BW/4HANA, especially with data migration."
"I would like more integration."
"The dashboard should be simplified and made easier for exploration and decision making."
"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."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 86 reviews while SAP BW4HANA is ranked 8th in Data Warehouse with 36 reviews. Microsoft Azure Synapse Analytics is rated 7.8, while SAP BW4HANA is rated 7.4. The top reviewer of Microsoft Azure Synapse Analytics writes "No competitors provide the entire solution to one place ". On the other hand, the top reviewer of SAP BW4HANA writes "Performs all necessary data warehouse tasks and offers additional functionalities". Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, Snowflake, Oracle Autonomous Data Warehouse, Teradata and Amazon Redshift, whereas SAP BW4HANA is most compared with Snowflake, SAP HANA, Amazon Redshift, SQL Server and SAP NetWeaver Business Warehouse. See our Microsoft Azure Synapse Analytics 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.