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
2nd
Average Rating
8.0
Reviews Sentiment
7.0
Number of Reviews
91
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 February 2025, in the Cloud Data Warehouse category, the mindshare of Microsoft Azure Synapse Analytics is 6.9%, down from 11.0% compared to the previous year. The mindshare of SAP Business Warehouse is 1.0%, down from 1.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse
 

Featured Reviews

Matthew Spieth - PeerSpot reviewer
Beneficial real-time analytics, simple setup, and useful tutorials
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.
JavedKhan1 - PeerSpot reviewer
Offers powerful analytics and integration capabilities but requires improved upgrade processes
SAP Business Warehouse could have been better. There is room for improvement from a technical perspective. So, from a technical perspective, when we are upgrading a Business Warehouse server or we are migrating from one place to another, the capability required for this upgradation has many manual activities. It took us around a month to streamline our server. Let’s say there are some transaction codes. Transaction code is a set of programs, and when you want to run a program from the backend, you need to hit the transaction code. It is called a T-code. So during the upgrade, many transaction codes get affected, and as a security consultant, it is my responsibility to recheck those transaction codes which are affected. Sometimes more than 100 codes may get affected, sometimes 500, and sometimes more as well. So, it takes a hell lot of time to integrate them again. That is a limitation or defect within the SAP Business Warehouse. SAP Business Warehouse should come up with proper solutions. Upgradation is an automatic activity. It should happen by itself. We just need to initiate it, and the backend SAP server is automatically upgraded. But it should handle the transactional code as well. They should not get absolutely, and any authorization object should not get deleted from the transaction codes. So, that functionality SAP Business Warehouse should come up with.

Quotes from Members

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

Pros

"We also like governance. It looks at what the requirements are for the company to identify the best way to ensure compliance is met when you move to the cloud."
"The most valuable features of Microsoft Azure Synapse Analytics are its serverless flexibility and complete power have allowed me to explore various different use cases. While I am not an expert in the product, my experience in programming in Databricks has shown me that Microsoft's investments in Synapse could potentially lead to it becoming a complete replacement for Databricks in the future."
"I like SQL post, which is for storage and distributed computing. Another good feature is the copy activity."
"-"
"The most valuable aspect of this Microsoft Azure Synapse Analytics is its consolidation of technical support from Microsoft, and its ability to securely host large quantities of data within the cloud environment. The overall ability to manage and maintain Big Data within the cloud provides a heightened level of efficiency, reliability, and support from Microsoft. This results in a superior user experience and an increased level of value for the end user."
"The most valuable feature is performance gains."
"The solution operates like a typical SQL Server environment so there is no alienation in terms of technical knowledge."
"Data can be stored any way you want in the data warehouse."
"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."
"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."
"The most valuable aspect of the solution is the integration with SAP ERP."
"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 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 real-time information is great."
"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."
"Predominantly, our company uses SAP Business Warehouse for reporting purposes across various departments, especially for managers to gain a quick understanding of their current standing and make informed decisions."
 

Cons

"The performance and data consistency need to be improved."
"More integration is needed to improve the product for the future."
"We'd like the solution to have more analytics capability."
"Managing workloads and data transformation using Databricks should be a focus."
"Microsoft Azure Synapse Analytics can improve by increasing the size of the files that we can load on the platform. We have some files that are too large to be loaded and it would be a benefit to us if the limit was increased. Additionally, the way we use the tool for generating reports can be made better. They should add some drag-and-drop rules without the need of programming these rules using some programming language. It would be helpful if we did not need someone that was technically advanced to be able to do it with, such as someone with no IT background. Having a reporting tool without code would be great."
"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 need to improve a little bit in terms of user-friendliness."
"I wish the data governance feature could be incorporated without requiring an additional license."
"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."
"SAP Business Warehouse could improve by having more out-of-the-box use cases to cover more business types or operations."
"There is room for improvement from a technical perspective."
"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."
"Areas for improvement in SAP Business Warehouse include enhancing scheduling and monitoring tools, as well as improving communication about hidden features to make them more accessible to users."
"In the next release, my suggestion would be to have user-friendly interfaces and performance issues be addressed."
"So far, the initial setup process in our company has not been easy enough for us to understand."
 

Pricing and Cost Advice

"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."
"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."
"I'm not sure of the exact cost, however, it is around $100,000 a year."
"We chose the serverless option for the database which has saved us a lot of money. Our costs are approximately £600 per month."
"This is a cost-effective product."
"The solution is expensive at the enterprise level."
"The costs are billed such that we pay for what we use, which is a good thing."
"The price of the package not expensive and depends on how much it is used."
"The solution is quite expensive."
"The license for SAP Business Warehouse is paid yearly, and there's no extra cost in addition to the standard licensing fees."
"It's moderately expensive, but definitely has its branding and price value for it."
"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."
"Overall, the pricing is not fixed and is expensive."
"SAP Business Warehouse licensing is a bit expensive compared to other products in the market."
"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."
"I would not recommend it to small-scale companies. The price is too much."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
837,501 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
51%
Computer Software Company
5%
Financial Services Firm
5%
Manufacturing Company
5%
Manufacturing Company
11%
Government
9%
Financial Services Firm
9%
Computer Software 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 financial aspect, including pricing and cost reduction, is not something I focus on.
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: February 2025.
837,501 professionals have used our research since 2012.