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

Microsoft Azure Synapse Analytics vs SAP Business Warehouse comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 18, 2024

Review summaries and opinions

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

Categories and Ranking

Microsoft Azure Synapse Ana...
Ranking in Cloud Data Warehouse
5th
Average Rating
7.8
Reviews Sentiment
7.0
Number of Reviews
93
Ranking in other categories
No ranking in other categories
SAP Business Warehouse
Ranking in Cloud Data Warehouse
14th
Average Rating
7.8
Reviews Sentiment
6.3
Number of Reviews
25
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of July 2025, in the Cloud Data Warehouse category, the mindshare of Microsoft Azure Synapse Analytics is 6.2%, down from 8.8% compared to the previous year. The mindshare of SAP Business Warehouse is 1.6%, up from 1.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse
 

Featured Reviews

Renee Hoon - PeerSpot reviewer
Scalable performance tuning and optimization for finance and supply chain jobs
We run our finance and supply chain jobs using SQL BW, and we visualize our data loads on Power BI. We are using SQL Data Warehouse for data warehousing In terms of cost savings, we don't need specialization in skills as advanced as Teradata. We used to pay extensive licensing fees for Teradata,…
Srini-Dhanaraj - PeerSpot reviewer
The solution enables seamless connection, but it is expensive, and the information is one day old
Out-of-the-box reports are very useful. The product provides a seamless connection between the SAP operation system and the data warehouse. It also moves the data from the operating system to the data warehouse in a 3D format. The report generation is easy. It’s a drag-and-drop process. People who want to do a project need not reinvent the wheel. Everything is designed, built, and delivered out of the box. All we have to do is interact with the customers to understand the kind of reports they need and check whether they are already available in the out-of-the-box report. If they are available, we just have to enable them and give the URLs to the customers. The Integration between the SAP operating system and data warehouse is excellent. The UI is good.

Quotes from Members

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

Pros

"Microsoft provides both the platform and the data center, so you don't have to look for a cloud vendor. It saves you from having to deal with two vendors for the same task."
"The initial setup process is straightforward."
"We've had a good experience with technical support in general."
"It is a fantastic product; we are satisfied with its features and performance."
"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."
"The most valuable feature is performance gains."
"Data can be stored any way you want in the data warehouse."
"The product is very user friendly."
"The real-time information is great."
"The solution has functionality that makes it easy for end-users to readily extract data directly from Business Warehouse into Excel and carry on their analysis on their own."
"The warehouse is the solution's most valuable feature."
"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 most valuable feature of SAP Business Warehouse is transformation, where I extract data from different sources, particularly the raw data. Then I do some transformations and store that in a format that allows me to do reporting easily."
"The most useful feature is definitely the speed."
"The most valuable feature of SAP Business Warehouse is its hybrid functionality, allowing users to leverage both SQL-based data warehouse capabilities from HANA and feature-based data warehousing from BW."
"We are currently in a basic stage of analytics and the first goal we have is to make sure the numbers are correct. BW has some features that help you to build factors and ETL in such a way that it's easy to get to correct responses. That's the number one condition that you have to have in an analytic solution."
 

Cons

"The product could be more feature-rich."
"Microsoft should develop an interface to make it easier to shift from on-premise to the cloud."
"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."
"Unfortunately, we have had some issues with the dashboard reporting. Sometimes, the data for specific periods would just appear blank on the dashboard. To investigate this, we worked with a Microsoft incident agent and it turned out to be a result of bugs in the platform when dealing with specific types of queries in Azure Data Factory."
"The linked services can be improved. We can create dynamic linked services to access a lot of databases but only those of the same type. For example, I can use the same linked services to access 11 SQL databases. However, if I have 11 SQL databases and five Oracle databases, I need two dynamic linked services. I cannot do it with only one linked service. The UI also needs to be improved. When I have used Azure Synapse for programming with PySpark, Scala, or .NET, for example, the UI has been unstable. If I open two notebooks for programming, one notebook will queue the session of the other."
"The performance needs to improve in future releases."
"Microsoft Azure Synapse Analytics could improve the section in the solution where you can implement the Python Spark pipelines, it's not the same as in Databricks which would be better."
"I am pretty sure that there are areas that need improvement but I just can think of them off the top of my head."
"The solution could offer better connectivity with other databases."
"So far, the initial setup process in our company has not been easy enough for us to understand."
"A few things which are missing include the visualization of reports. That's where your costs and licensing become heavy. When it comes to this database compared Microsoft Warehouse, it's an expensive solution."
"The advanced structuring can be complicated and the interface is not very intuitive."
"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."
"There is room for improvement from a technical perspective."
"In the next release, my suggestion would be to have user-friendly interfaces and performance issues be addressed."
"We are very unhappy with technical support. First of all, they send their sales agents or pre-sales agents and most of them who don't know the solution as a properly trained tech would. We have an on-site SAP representative who is supposed to help us with our high priority and production issues, and they're not satisfactory to say the least."
 

Pricing and Cost Advice

"When we are not using this solution we can simply shut it down saving us costs, which is a nice advantage."
"There's no license required for Microsoft Azure Synapse Analytics. the model is more of a use-based system. You got to pay for computing power and disk storage. Everything has different units and is kept backed up. Microsoft Azure Synapse Analytics uses storage units(SU). This is how everything's computed for cost."
"The costs are billed such that we pay for what we use, which is a good thing."
"It requires a less expensive version because currently, not every customer is able to buy it. If it could have a smaller setup that doesn't require so many resources, it would be helpful, and we would be able to use it in more cases. We are a small country, and most of our customers are quite small businesses."
"We normally pay between $300 and $500 per month, which is quite expensive for how much we actually use it, performance- and usage-wise. They have a cheap version and an expensive version, and our usage usually falls in the middle ground, which makes it not as cost-effective as it could be."
"Its price could be better. It was a school project, and I got it for free. If I try to pay through my company, it is a little bit more expensive as compared to Oracle."
"Microsoft Azure Synapse Analytics can be costly, however, a cost-effective approach would be to purchase it in advance through reservation for either one or three years. This will significantly reduce the overall expenses incurred."
"I'm not sure of the exact cost, however, it is around $100,000 a year."
"The solution is quite expensive."
"I would not recommend it to small-scale companies. The price is too much."
"It's quite pricey. SAP changed its pricing policy, so they give you one engine and then you have to buy everything next to it, like MSS, the BPC licenses, and everything else."
"The licensing cost for SAP Business Warehouse depends on your revenue. Its licensing structure is a little bit complicated. The more your revenue is, the higher the price, but SAP does have different pricing structures for various companies. For small businesses, licensing isn't based on revenue, but for big companies, it's revenue-based. There's some agreement regarding pricing for huge companies, so it's different, and SAP Business Warehouse pricing isn't fixed. On a scale of one to ten, I'm rating the licensing cost for SAP Business Warehouse as five because it's very high. As your revenue grows, your licensing cost also increases, so you have to factor that in when calculating your cost."
"It's moderately expensive, but definitely has its branding and price value for it."
"The license for SAP Business Warehouse is paid yearly, and there's no extra cost in addition to the standard licensing fees."
"Overall, the pricing is not fixed and is expensive."
"SAP Business Warehouse licensing is a bit expensive compared to other products in the market."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
861,390 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
17%
Manufacturing Company
9%
Financial Services Firm
8%
Government
7%
Manufacturing Company
13%
Financial Services Firm
10%
Computer Software Company
8%
Retailer
7%
 

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?
I think the price of Microsoft Azure Synapse Analytics is very expensive, but that's not only for Microsoft Azure Synapse Analytics—it's for the cloud in general. The cloud is not cost-effective. I...
What is your experience regarding pricing and costs for SAP Business Warehouse?
The solution is quite expensive. We paid a yearly subscription fee.
What needs improvement with SAP Business Warehouse?
Over a period, we realized that the license and maintenance costs were quite expensive. Every day, we had to run the background job ODS. Eventually, we moved away from SAP Business Warehouse and bo...
 

Also Known As

Azure Synapse Analytics, Microsoft Azure SQL Data Warehouse, Microsoft Azure SQL DW, Azure SQL Data Warehouse, MS Azure Synapse Analytics
No data available
 

Overview

 

Sample Customers

Toshiba, Carnival, LG Electronics, Jet.com, Adobe, 
Medtronic, Cirque du Soleil, Antarc, B&G Manufacturing, EarlySense, eBay, Ferrero, James Austin Company, Lenovo, Sagem, RAK Ceramics, Vodafone
Find out what your peers are saying about Microsoft Azure Synapse Analytics vs. SAP Business Warehouse and other solutions. Updated: July 2025.
861,390 professionals have used our research since 2012.