Azure Synapse Analytics vs. SAP BW/4HANA

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Azure Synapse Analytics
Score 7.6 out of 10
N/A
Azure Synapse Analytics is described as the former Azure SQL Data Warehouse, evolved, and as a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives users the freedom to query data using either serverless or provisioned resources, at scale. Azure Synapse brings these two worlds together with a unified experience to ingest, prepare, manage, and serve data for immediate BI and machine learning needs.
$4,700
per month 5000 Synapse Commit Units (SCUs)
SAP BW/4HANA
Score 8.4 out of 10
N/A
SAP BW/4HANA is a next-generation data warehouse solution. It is specifically designed to use the advanced in-memory capabilities of the SAP HANA platform. For example, SAP BW/HANA can integrate many different data sources to provide a single, logical view of all the data. This could include data contained in SAP and non-SAP applications running on-premise or in the cloud, and data lakes, such as those contained in the Apache Hadoop open-source software framework. With SAP BW/4HANA,…N/A
Pricing
Azure Synapse AnalyticsSAP BW/4HANA
Editions & Modules
Tier 1
$4,700
per month 5,000 Synapse Commit Units (SCUs)
Tier 2
$9,200
per month 10,000 Synapse Commit Units (SCUs)
Tier 3
$21,360
per month 24,000 Synapse Commit Units (SCUs)
Tier 4
$50,400
per month 60,000 Synapse Commit Units (SCUs)
Tier 5
$117,000
per month 150,000 Synapse Commit Units (SCUs)
Tier 6
$259,200
per month 360,000 Synapse Commit Units (SCUs)
No answers on this topic
Offerings
Pricing Offerings
Azure Synapse AnalyticsSAP BW/4HANA
Free Trial
NoNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoYes
Entry-level Setup FeeNo setup feeOptional
Additional Details
More Pricing Information
Community Pulse
Azure Synapse AnalyticsSAP BW/4HANA
Top Pros
Top Cons
Features
Azure Synapse AnalyticsSAP BW/4HANA
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
Azure Synapse Analytics
-
Ratings
SAP BW/4HANA
8.8
1 Ratings
0% above category average
Multi-User Support (named login)00 Ratings9.01 Ratings
Multiple Access Permission Levels (Create, Read, Delete)00 Ratings9.01 Ratings
Single Sign-On (SSO)00 Ratings9.01 Ratings
Location-Based Data Governance00 Ratings8.01 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
Azure Synapse Analytics
-
Ratings
SAP BW/4HANA
7.0
1 Ratings
15% below category average
Data model creation00 Ratings7.01 Ratings
Data Exploration
Comparison of Data Exploration features of Product A and Product B
Azure Synapse Analytics
-
Ratings
SAP BW/4HANA
4.0
1 Ratings
33% below category average
Visualization00 Ratings4.01 Ratings
Data Warehouse
Comparison of Data Warehouse features of Product A and Product B
Azure Synapse Analytics
-
Ratings
SAP BW/4HANA
6.0
1 Ratings
19% below category average
High-Volume Data Processing00 Ratings8.01 Ratings
Data Warehouse Management00 Ratings8.01 Ratings
Administrative Automation00 Ratings5.01 Ratings
Self-Optimization00 Ratings3.01 Ratings
Best Alternatives
Azure Synapse AnalyticsSAP BW/4HANA
Small Businesses
Google BigQuery
Google BigQuery
Score 8.7 out of 10
Google BigQuery
Google BigQuery
Score 8.7 out of 10
Medium-sized Companies
Snowflake
Snowflake
Score 9.0 out of 10
Cloudera Enterprise Data Hub
Cloudera Enterprise Data Hub
Score 9.0 out of 10
Enterprises
Snowflake
Snowflake
Score 9.0 out of 10
Oracle Exadata
Oracle Exadata
Score 8.1 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Azure Synapse AnalyticsSAP BW/4HANA
Likelihood to Recommend
8.2
(9 ratings)
8.0
(9 ratings)
Usability
9.6
(2 ratings)
8.0
(2 ratings)
Support Rating
9.6
(2 ratings)
9.7
(7 ratings)
Contract Terms and Pricing Model
10.0
(1 ratings)
-
(0 ratings)
User Testimonials
Azure Synapse AnalyticsSAP BW/4HANA
Likelihood to Recommend
Microsoft
It's well suited for large, fastly growing, and frequently changing data warehouses (e.g., in startups). It's also suited for companies that want a single, relatively easy-to-use, centralized cloud service for all their data needs. Larger, more structured organizations could still benefit from this service by using Synapse Dedicated SQL Pools, knowing that costs will be much higher than other solutions. I think this product is not suited for smaller, simpler workloads (where an Azure SQL Database and a Data Factory could be enough) or very large scenarios, where it may be better to build custom infrastructure.
Read full review
SAP
Some scenarios where SAP BW/4HANA is well suited are retail industry, supply chain, finance, warehouse, stocking processes, BI, [and] some finance analytics reporting. Some scenarios where SAP BW/4HANA is less appropriate [is when] relational queries are needed [and] in some small business with infrastructure limitations. Another scenario that is less appropriate is for ABAP processes requirements.
Read full review
Pros
Microsoft
  • Create data pipelines to connect with multiple data workspace(s) and external data
  • Ability to connect with Azure Data Lake (sequentially) for data warehousing
  • Being able to manage connections and create integration runtimes (for onPrem data capture)
Read full review
SAP
  • High speed data warehouse regardless of data volumes.
  • Excellent integration with SAP systems and Data sets.
  • Simplified data modelling due to columnar data base.
Read full review
Cons
Microsoft
  • It takes some time to setup a proper SQL Datawarehouse architecture. Without proper SSIS/automation scripts, this can be a very daunting task.
  • It takes a lot of foresight when designing a Data Warehouse. If not properly designed, it can be very troublesome to use and/or modify later on.
  • It takes a lot of effort to maintain. Businesses are continually changing. With that, a full time staff member or more will be required to maintain the SQL Data Warehouse.
Read full review
SAP
  • Enterprise license pricing is very expensive and run-time license limits the usefulness of the tool.
  • Integration with SAP Analytics cloud for write-back to BW/4HANA. Live connection is only read from SAC.
  • Make run-time licenses more useful.
Read full review
Usability
Microsoft
The data warehouse portion is very much like old style on-prem SQL server, so most SQL skills one has mastered carry over easily. Azure Data Factory has an easy drag and drop system which allows quick building of pipelines with minimal coding. The Spark portion is the only really complex portion, but if there's an in-house python expert, then the Spark portion is also quiet useable.
Read full review
SAP
SAP BW/4HANA requires specialized skillsets around data warehouse modeling and the access to data, however the modeling capabilities are intuitive and have now become accessible to both SAP and non-SAP data warehouse specialists. This new model allows for Interchangeable skillsets and access to a broader pool of experts throughout the industry, as well as easier access to data.
Read full review
Support Rating
Microsoft
Microsoft does its best to support Synapse. More and more articles are being added to the documentation, providing more useful information on best utilizing its features. The examples provided work well for basic knowledge, but more complex examples should be added to further assist in discovering the vast abilities that the system has.
Read full review
SAP
SAP Max Attention and general support for SAP BW/4HANA is broadly available. Truth to be told, MaxAttention has a premium cost but brings great engineers. So this being an enterprise capability and extremely critical, we did not consider cost as the main factor since support works well. Just keep that in mind when making your selection.
Read full review
Alternatives Considered
Microsoft
When client is already having or using Azure then it’s wise to go with Synapse rather than using Snowflake. We got a lot of help from Microsoft consultants and Microsoft partners while implementing our EDW via Synapse and support is easily available via Microsoft resources and blogs. I don’t see that with Snowflake
Read full review
SAP
SAP Analytics Cloud is complemented by SAP BW/4 HANA through connectors that work in real-time and allow the display of indicator information in interactive and user-friendly visualizations. SAP Data Services integrates with BW/4 HANA allowing to automate the loading of information in the system taking as a data source a wide variety of platforms.
Read full review
Contract Terms and Pricing Model
Microsoft
Basically, the billing is predictable, and this all about it.
Read full review
SAP
No answers on this topic
Return on Investment
Microsoft
  • We have had an improvement in our overall processing time
  • Cost was much lower than most of its competitors
  • Our reporting needs have grown and housing the data here has been great
Read full review
SAP
  • Faster turn-around to enhancements
  • End users can query structures that are not limited to multi-dimensional models.
  • Performance improvements means that business user can do more in the same time compared to traditional BW
Read full review
ScreenShots

SAP BW/4HANA Screenshots

Screenshot of Next generation data warehousing with SAP BW/4HANA.Screenshot of SAP BW/4HANA user cockpit.Screenshot of Geolocation analytics in SAP BW/4HANA.Screenshot of Data modeling in SAP BW/4HANA.Screenshot of Modern user experience in SAP BW/4HANA.Screenshot of Monitor the performance of your business in real-time with SAP BW/4HANA.