Try our new research platform with insights from 80,000+ expert users

Microsoft Azure Synapse Analytics vs SAP BW4HANA comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Microsoft Azure Synapse Ana...
Average Rating
8.0
Reviews Sentiment
7.1
Number of Reviews
90
Ranking in other categories
Cloud Data Warehouse (2nd)
SAP BW4HANA
Average Rating
7.6
Reviews Sentiment
7.5
Number of Reviews
42
Ranking in other categories
Data Warehouse (9th)
 

Featured Reviews

Sunil Gidwani - PeerSpot reviewer
No competitors provide the entire solution to one place
I rate Azure Synapse Analytics eight out of 10. No competitors provide the entire solution to one place like Synapse. For example, a database just focuses moving and manipulating data, etc. But Synapse is like an all-inclusive workspace. I advise other people to go with Databricks Notebook if you need a computation engine. It has a solid SQL storage procedure. Suppose you are dealing with complex transformation logic and manipulation of run-time data flows. In that case, it's better to use Databricks than any Microsoft ADF. DataBricks looks more promising in terms of computing in memory, so we integrated Databricks in Synapse.
DilipRoshantha - PeerSpot reviewer
Offers good value for money to users
There have been no hiccups for my company when it comes to integrating SAP products with the data analytics and the transactional systems since my company uses SAP PI for it, but lately my organization has been using SAP Process Orchestration for data integration. With SAP, there is a small visualization part inside SAP BW4HANA. I can visualize some of the reports with the help of SAP BW4HANA. The tool can be configured and is compatible with all SAP applications, which makes it a good product. I believe that the product has the capabilities to cater to various business requirements. The product does offer value for money. There are big customers along with medium or small customers. Small and medium-sized customers cannot afford the cost of the tool's licensing. From a value point of view, in business terms, it is good. I rate the tool a nine out of ten.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"I like SQL post, which is for storage and distributed computing. Another good feature is the copy activity."
"The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range."
"The product works well with other Azure products."
"The solution's scalability is very, very good. It's one of the most important aspects for us."
"Scaling this solution is easy and the uptime is okay."
"The solution has been working well overall."
"The ability to scale out services on-demand and scale them down when they are not required is most valuable. You are in control of your expenditures, and you are also in control of the horsepower that you need. That's a major advantage."
"They are very reliable and cost-effective."
"SAP BW4HANA aids in managing data from ER to front-end analysis, contributes to ROI, and fosters business growth understanding. I like that the solution breaks down components to a very granular level, allowing for customization and implementation based on specific requirements. The solution is stable. The solution is scalable."
"I like that it's quite quick."
"The solution saves time and cost."
"The most valuable features are the speed of reporting and the HANA database."
"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."
"The solution seamlessly integrates with SAP products."
"The processes are the most valuable aspect of this solution."
"We benefited from BW/4HANA's ability to utilize predefined content inside. We didn't need to start from scratch."
 

Cons

"Integration with other products is an area that can be improved."
"There may be some challenges in terms of connecting with Virtual Networks (VNETs) to Microsoft Azure Synapse Analytics."
"Microsoft Azure Synapse Analytics's pricing could be reduced."
"It could be beneficial to focus on integration with various data sources and similar enhancements."
"It would be ideal if the solution could be better used intuitively by the staff without having a great deal of training."
"I'm not entirely happy with the billing model. I'm not entirely happy with how the enterprise services are pretty expensive, but that's about it."
"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."
"Microsoft Azure Synapse Analytics's overall integration within the Azure ecosystem could improve. The native Microsoft solution versus another solution, such as Databricks, there are areas where there could be some improvements."
"Real-time processing isn't BW/4HANA's strongest point."
"I would like more integration."
"The solution does occasionally get a few bugs, but this is typical for any product."
"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."
"SAP BW/4HANA can generally be less flexible than other tools, depending on how it is set up."
"It takes too long to escalate problems from the first level of support."
"The solution is not easy to implement. It requires a lot of learning at the beginning."
"Support could be more reliable."
 

Pricing and Cost Advice

"Very costly solution and other products are available for less."
"This is an expensive solution."
"The product is expensive."
"The solution could improve by having better costing information."
"The cost of the solution depends on the type of license we choose, such as pay-as-you-go, one-year reserve, or three-year reserve."
"The price of the package not expensive and depends on how much it is used."
"Microsoft Azure Synapse Analytics is an expensive solution and there is a license needed to use it. My company has an enterprise license."
"My company pays for the license and I am not sure about the price."
"Price wise, this solution is on the higher side."
"This is an expensive solution and there are costs in addition to the standard licensing fees."
"The SAP HANA application still hasn't been leveraged to the fullest extent, but it's a five-year enterprise license."
"The cost and licensing depends on how the customer is going to use the solution."
"We have a broad licensing arrangement, which is expensive but worth it for sizeable businesses."
"It's a little expensive compared to Microsoft Azure."
"The cost of ownership is higher. It's resource-intensive, and naturally, that increases costs."
"We started as early birds from the SAP side. We got this entire suite for free. I cannot really talk about the price because we didn't have to pay anything."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
44%
Computer Software Company
7%
Financial Services Firm
7%
Manufacturing Company
5%
Manufacturing Company
18%
Computer Software Company
11%
Financial Services Firm
8%
Energy/Utilities Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?
Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different dat...
What do you like most about Microsoft Azure Synapse Analytics?
The product is easy to use, and anybody can easily migrate to advanced DB.
What is your experience regarding pricing and costs for Microsoft Azure Synapse Analytics?
The cost is reasonable for our company. There is no license cost; we pay only for Azure Compute's costs. It is important to manage the cost efficiently on a daily basis.
What do you like most about SAP BW4HANA?
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 integrati...
What is your experience regarding pricing and costs for SAP BW4HANA?
We have a broad licensing arrangement, which is expensive but worth it for sizeable businesses.
What needs improvement with SAP BW4HANA?
The interface could be more user-friendly, as we often need to do low-level coding to get things done.
 

Also Known As

Azure Synapse Analytics, Microsoft Azure SQL Data Warehouse, Microsoft Azure SQL DW, Azure SQL Data Warehouse, MS Azure Synapse Analytics
SAP BW/4HANA
 

Learn More

 

Overview

 

Sample Customers

Toshiba, Carnival, LG Electronics, Jet.com, Adobe, 
Information Not Available
Find out what your peers are saying about Microsoft Azure Synapse Analytics vs. SAP BW4HANA and other solutions. Updated: October 2024.
816,406 professionals have used our research since 2012.