We just raised a $30M Series A: Read our story

Compare Microsoft Azure Synapse Analytics vs. SAP Business Warehouse

Cancel
You must select at least 2 products to compare!
Featured Review
Find out what your peers are saying about Microsoft Azure Synapse Analytics vs. SAP Business Warehouse and other solutions. Updated: November 2021.
553,954 professionals have used our research since 2012.
Quotes From Members

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

Pros
"The useability, the user interface, is very user-friendly.""The most valuable feature is the incremental load because we do not need to refresh the entire data on a daily basis.""The whole solution is interesting for us.""The most important feature for me is the integration with PolyBase.""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.""I like its performance. It is well-structured and offers a lot of practical options. Because of the visual design of the product, it is very easy to find icons and other visual elements. It took me more than two weeks to understand how it works. I had an intensive training session to understand it, which was enough. It was not hard to understand how it works.""The most valuable feature is performance gains.""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."

More Microsoft Azure Synapse Analytics Pros »

"In terms of stability, comparatively, the solution is quite stable.""I like that it integrates to open-source.""Having the back-end data set with the right information is the best qualification for this solution.""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 features that I have found most valuable are its capabilities to connect to Excel and to slice and dice."

More SAP Business Warehouse Pros »

Cons
"The macro functions, though useful, are not totally user-friendly. Some people have difficulties in learning them.""While the solution is flexible, sometimes this works against the user.""The need to improve a little bit in terms of user-friendliness.""With respect to what needs to be improved, concurrent connectivity has some limitations.""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.""Documentation could be improved.""It's a complicated product.""I would like my team to be able to build pipelines that integrate with the Azure Data Factory."

More Microsoft Azure Synapse Analytics Cons »

"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 integrate better with other ETL tools.""More integration with Microsoft Office products (not just Excel) would be helpful.""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.""I would like to see a different end solution in order to read the data and attract internal users."

More SAP Business Warehouse Cons »

Pricing and Cost Advice
"The price of the package not expensive and depends on how much it is used.""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.""When we are not using this solution we can simply shut it down saving us costs, which is a nice advantage.""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.""The solution is subscription-based. You can also pay to use the product as you go.""The cost of the licensing depends on the size of the warehouse, where the cost of storage is approximately $130 USD per terabyte.""We chose the serverless option for the database which has saved us a lot of money. Our costs are approximately £600 per month.""They are cost aggressive, and it integrates well with other Microsoft tools."

More Microsoft Azure Synapse Analytics Pricing and Cost Advice »

"It's moderately expensive, but definitely has its branding and price value for it."

More SAP Business Warehouse Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
553,954 professionals have used our research since 2012.
Questions from the Community
Top Answer: 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… more »
Top Answer: Traditional ETL would usually use a dedicated database (or even database server) where you'll load & transform your raw data before ingesting it into the final destination. This would allow checking… more »
Top Answer: The integrated workspace in Microsoft Azure Synapse Analytics where everything comes together, such as Power BI and Data Factory, is very good. Additionally, the ability to do dedicated SQL pooling is… more »
Top Answer: I like that it integrates to open-source.
Top Answer: It's moderately expensive, but definitely has its branding and price value for it.
Top Answer: SAP Business Warehouse could integrate better with other ETL tools. There is some complexity to the setup. It would be helpful if the setup could be simplified. I would like to see more MLOps… more »
Ranking
2nd
Views
26,469
Comparisons
19,512
Reviews
34
Average Words per Review
537
Rating
7.9
7th
Views
1,076
Comparisons
855
Reviews
5
Average Words per Review
784
Rating
7.6
Comparisons
Also Known As
Azure Synapse Analytics, Microsoft Azure SQL Data Warehouse, Microsoft Azure SQL DW, Azure SQL Data Warehouse, MS Azure Synapse Analytics
Learn More
Overview

Azure SQL Data Warehouse is a Fast, flexible, and secure analytics platform for the enterprise. Azure SQL Data Warehouse lets you independently scale compute and storage, while pausing and resuming your data warehouse within minutes through a massively parallel processing architecture designed for the cloud. Seamlessly create your hub for analytics along with native connectivity with data integration and visualization services, all while using your existing SQL and BI skills.

Reporting, analysis and interpretation of business data are crucial to preserve and enhance the competitive edge of companies by optimizing processes and enabling them to react quickly and in line with market needs. SAP Business Warehouse (SAP BW) provides tools and functions that enable companies to attain these goals. In SAP BW, you can integrate, transform, and consolidate relevant business information from productive SAP applications and external data sources. SAP BW provides you with a high-performance infrastructure that helps you evaluate and interpret data. Decision makers can make well-founded decisions and identify target-orientated activities on the basis of the analyzed data.

Offer
Learn more about Microsoft Azure Synapse Analytics
Learn more about SAP Business Warehouse
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
Top Industries
REVIEWERS
Comms Service Provider18%
Computer Software Company18%
Manufacturing Company12%
Financial Services Firm12%
VISITORS READING REVIEWS
Computer Software Company28%
Comms Service Provider18%
Financial Services Firm6%
Energy/Utilities Company6%
REVIEWERS
Non Tech Company25%
Maritime Company13%
Pharma/Biotech Company13%
Comms Service Provider13%
VISITORS READING REVIEWS
Computer Software Company32%
Comms Service Provider15%
Energy/Utilities Company8%
Media Company8%
Company Size
REVIEWERS
Small Business32%
Midsize Enterprise23%
Large Enterprise45%
VISITORS READING REVIEWS
Small Business15%
Midsize Enterprise13%
Large Enterprise72%
REVIEWERS
Small Business10%
Midsize Enterprise10%
Large Enterprise80%
Find out what your peers are saying about Microsoft Azure Synapse Analytics vs. SAP Business Warehouse and other solutions. Updated: November 2021.
553,954 professionals have used our research since 2012.

Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 34 reviews while SAP Business Warehouse is ranked 7th in Cloud Data Warehouse with 5 reviews. Microsoft Azure Synapse Analytics is rated 8.0, while SAP Business Warehouse is rated 7.6. The top reviewer of Microsoft Azure Synapse Analytics writes "Scalable, intuitive, facilitates compliance and keeping your data secure". On the other hand, the top reviewer of SAP Business Warehouse writes "Has ready-made connectors where we can extract data from ". Microsoft Azure Synapse Analytics is most compared with Snowflake, Amazon Redshift, SAP BW4HANA and Apache Hadoop, whereas SAP Business Warehouse is most compared with Snowflake, Amazon Redshift and SAP NetWeaver Business Warehouse. See our Microsoft Azure Synapse Analytics vs. SAP Business Warehouse report.

See our list of best Cloud Data Warehouse vendors and best Data Warehouse vendors.

We monitor all Cloud 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.