Microsoft Azure Synapse Analytics vs SAP BW4HANA comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Microsoft Azure Synapse Ana...
Average Rating
7.8
Number of Reviews
86
Ranking in other categories
Cloud Data Warehouse (2nd)
SAP BW4HANA
Average Rating
7.6
Number of Reviews
40
Ranking in other categories
Data Warehouse (8th)
 

Mindshare comparison

As of July 2024, in the Data Warehouse category, the mindshare of Microsoft Azure Synapse Analytics is 12.9%, down from 14.8% compared to the previous year. The mindshare of SAP BW4HANA is 5.2%, down from 5.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse
Unique Categories:
Cloud Data Warehouse
8.7%
No other categories found
 

Featured Reviews

Peter Aderoju - PeerSpot reviewer
Jan 2, 2024
SQL pool valuable for working with databases, quick with queries even in large datasets
One area that could be improved is the schema management. For instance, with Azure Data Lake, I sometimes try to create mappings. In MySQL or MongoDB, I can easily see the datasets and create connections without knowing the exact schema beforehand. I'm not as familiar with that process in Azure Synapse Analytics. It might be possible through tutorials, but it would be helpful to have more integrated tools for data scanning and schema exploration within the studio itself. This could help streamline the workflow and reduce the need to switch between different applications. So, I'd like to have additional tools for data scanning and schema exploration within the Azure Synapse Analytics studio.
SH
Oct 4, 2023
Has good scalability, but its monitoring features need improvement
We use SAP BW/4HANA for business banking and consolidations The product has efficient performance. SAP BW/4HANA has good availability and valuable features for historical data. The product could be more efficient and easier to use similar to its previous version. The monitoring for the…

Quotes from Members

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

Pros

"I like how Microsoft Azure Synapse Analytics integrates with other Microsoft solutions."
"Data can be stored any way you want in the data warehouse."
"It is a fantastic product; we are satisfied with its features and performance."
"The features we've found most valuable for data warehouses is extracting data, SSIS packages, and the DBs."
"What I found most valuable in Microsoft Azure Synapse Analytics is that it's native only for Azure, so you get better performance and there's no issue. To explain further, many different types of data come, in particular, structured and unstructured data. For audit purposes, there's also unstructured data, so the most important aspect is that with Microsoft Azure Synapse Analytics, you have the capability of using both technologies, meaning that you can use or mix structured and unstructured data which is important. This can also be done in Hadoop, and on other platforms, so you have everything in one place. You don't have to worry about how to manage both structured and unstructured data and where to store information. With Microsoft Azure Synapse Analytics, you can take care of everything, particularly in Azure. The solution also provides you with many features apart from analytics, for example, storage which makes it better."
"We've had a good experience with technical support in general."
"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 a benefit."
"-"
"The solution is based on SAP ERP, so there's some business content already included. For customers who use SAP ERP, SAP BW4HANA is a good choice for their DW implementation."
"The most valuable aspect of this solution is that the infrastructure is easy to understand."
"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."
"It is a stable solution...It is a scalable solution."
"Out of the box, this solution has a lot of standard features."
"I like that it's quite quick."
"The most valuable feature is that it's robust."
"From an ERP point of view and a functionality point of view, it works very well. The benefits are in that of financial costing and material management."
 

Cons

"This solution needs to have query caching so that if the same query is run and the results are available, it will return the data from the cache without having to re-run the query."
"Synapse Analytics is generally stable, but its performance can be slow when performing very large datasets."
"Real-time integration is hard to do in Microsoft Azure Synapse Analytics."
"Microsoft Azure Synapse Analytics can improve by adding more flexibility to the reports. Having more visible structures based on the area, region and country would be beneficial."
"Indicating what areas need improvement in this solution is a difficult question because the organizations that I am working for are really new in this area. However, an even better more simple interface, or perhaps an extension of a connector app store solution, would be helpful."
"Comes with a pretty steep learning curve."
"The product needs a tool that allows for work from a laptop instead of a browser."
"It's stable, but its stability could be better. However, we understand that it's in production, and new features are getting added and upgraded, so you do get hiccups sometimes."
"Pricing would be a good improvement. A lot of customers think that it's very expensive and especially support is very expensive."
"I don't see SAP actively supporting the solution now...a better support from SAP would be appreciated."
"Price wise, this solution is on the higher side."
"The product needs to improve with more performance and fewer data layers."
"It's complicated to use. You need to spend a lot of time learning about it. The interface could be improved. It's not intuitive to build a data model and use their ETL tools."
"The tool is not cloud-compatible."
"The UI is not user-friendly."
"Connecting multiple sources is a challenge because you have to go through a lot of different setups."
 

Pricing and Cost Advice

"This solution starts at €1000.00 a month for just the basics and can go up to €300,000.00 per month for the fastest version."
"Microsoft's pricing is relatively high, and it varies according to the extent of our usage. The pricing is directly tied to our consumption. This decision is ultimately a business choice."
"We chose the serverless option for the database which has saved us a lot of money. Our costs are approximately £600 per month."
"Very costly solution and other products are available for less."
"I'm not sure of the exact cost, however, it is around $100,000 a year."
"We only have to pay for what we use in the solution. It's easy for the customers. It's not more than some companies, not more than 300 to 400 users. They do not need to buy other license products, such as SAP B1, or analytics tools in the market, such as Tableau."
"Microsoft Azure Synapse Analytics is an expensive solution and there is a license needed to use it. My company has an enterprise license."
"It's very difficult to price unless you know exactly how the customer is using it."
"In general, it's quite expensive."
"It is an expensive product."
"The product is free if we have the ECC license."
"Price wise, this solution is on the higher side."
"For some, the rates offered by SAP can be costly while for others it may seem cheap. The price ultimately depends on how you have negotiated your contract with SAP."
"This is an expensive solution and there are costs in addition to the standard licensing fees."
"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."
"The cost of ownership is higher. It's resource-intensive, and naturally, that increases costs."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
793,295 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
36%
Computer Software Company
9%
Financial Services Firm
8%
Manufacturing Company
5%
Manufacturing Company
17%
Computer Software Company
11%
Energy/Utilities Company
8%
Financial Services Firm
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?
Microsoft Azure Synapse Analytics is a moderately priced solution. We pay a yearly licensing fee for the solution. If you get help from partners, it will be expensive for you.
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?
Pricing is always a consideration with SAP. You need to navigate the contracts and agreements carefully. But, with the right terms in place, it can be a cost-effective solution.
What needs improvement with SAP BW4HANA?
There should be a direct pipeline from Azure to SAP. Users must be able to deploy the pipeline and pull the tables directly.
 

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: July 2024.
793,295 professionals have used our research since 2012.