Azure Synapse Analytics (Azure SQL Data Warehouse) vs SAP BW/4HANA | TrustRadius

What users are saying about

Score 8.3 out of 10

Based on 32 reviews and ratings

Score 8.6 out of 10

Based on 42 reviews and ratings

Attribute Ratings

Azure Synapse Analytics (Azure SQL Data Warehouse) is rated higher in 1 area: Usability
SAP BW/4HANA is rated higher in 2 areas: Likelihood to Recommend, Support Rating

Likelihood to Recommend

8.8

Azure Synapse Analytics (Azure SQL Data Warehouse)

88%

8 Ratings

9.2

SAP BW/4HANA

92%

8 Ratings

Usability

9.5

Azure Synapse Analytics (Azure SQL Data Warehouse)

95%

2 Ratings

8.3

SAP BW/4HANA

83%

2 Ratings

Support Rating

9.5

Azure Synapse Analytics (Azure SQL Data Warehouse)

95%

2 Ratings

9.6

SAP BW/4HANA

96%

13 Ratings

Contract Terms and Pricing Model

10.0

Azure Synapse Analytics (Azure SQL Data Warehouse)

100%

1 Rating

SAP BW/4HANA

N/A

0 Ratings

Pros

Quick to return data. Queries in a SQL data warehouse architecture tend to return data much more quickly than a OLTP setup. Especially with columnar indexes.
Ability to manage extremely large SQL tables. Our databases contain billions of records. This would be unwieldy without a proper SQL datawarehouse
Backup and replication. Because we're already using SQL, moving the data to a datawarehouse makes it easier to manage as our users are already familiar with SQL.

Read full review

Verified User

Contributor in Information Technology

Information Technology and Services Company, 10,001+ employees

View all 8 answers on this topic

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

Verified User

Director in Information Technology

Telecommunications Company, 10,001+ employees

View all 8 answers on this topic

Cons

Integrating external 3rd party data sources is very easy in Snowflake and it’s missing in Azure Synapse
Master data services and data quality services are missing in Azure Synapse. They are useful features present in on Orem Sql server
Resource usage reports (top 10 expensive queries, most frequently run queries, etc) are a feature that can be added in Azure Synapse. It’s present in an on-prem SQL server. DMVs are there but viewing it visually as a report is more helpful.

Read full review

Verified User

Consultant in Information Technology

Information Technology & Services Company, 51-200 employees

View all 8 answers on this topic

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

Product Owner - Management Reporting SAP S4 / HANA

HP IncInformation Technology and Services, 10,001+ employees

View all 8 answers on this topic

Pricing Details

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Starting Price

—

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

Yes

Entry-level set up fee?

Optional

Starting Price

—

Usability

Azure Synapse Analytics (Azure SQL Data Warehouse) 9.5

Based on 2 answers

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

Verified User

Consultant in Professional Services

Computer Software Company, 201-500 employees

View all 2 answers on this topic

SAP BW/4HANA 8.3

Based on 2 answers

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

Verified User

Director in Information Technology

Telecommunications Company, 10,001+ employees

View all 2 answers on this topic

Support Rating

Azure Synapse Analytics (Azure SQL Data Warehouse) 9.5

Based on 2 answers

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

Verified User

Consultant in Professional Services

Computer Software Company, 201-500 employees

View all 2 answers on this topic

SAP BW/4HANA 9.6

Based on 13 answers

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

Verified User

Executive in Information Technology

Consumer Goods Company, 10,001+ employees

View all 13 answers on this topic

Alternatives Considered

We also looked at Oracle Data Warehouse as part of our short list of products to implement as a solution. Oracle's product turned out to have less support by way of easily accessible internet blogs. Oracle was also considerably more expensive and we would have needed to hire the skillset needed to implement.

Read full review

Samir Patel, PMP

SQL Development Team Lead

Allianz Asset ManagementInvestment Management, 1001-5000 employees

View all 8 answers on this topic

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

Gerente de Consultoría

SEIDOR AnalyticsInformation Technology and Services, 201-500 employees

View all 8 answers on this topic

Contract Terms and Pricing Model

Azure Synapse Analytics (Azure SQL Data Warehouse) 10.0

Based on 1 answer

Basically, the billing is predictable, and this all about it.

Read full review

Vladimír Mužný

Owner, Developer

DROPMAN s.r.o.Computer Software, 1-10 employees

View all 1 answers on this topic

No score

No answers yet

No answers on this topic

Return on Investment

Azure Synapse has predominately reduced the time being used for processing data being extracted from multiple sources
Ability to integrate multiple data sources and create a single dataset that could be used for further analytics to find KPIs

Read full review

Verified User

Professional in Information Technology

Government Administration Company, 501-1000 employees

View all 8 answers on this topic

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

Senior Technical Specialist

Rio TintoMining & Metals, 10,001+ employees

View all 8 answers on this topic

Screenshots

—

See All (6) SAP BW/4HANA Screenshots

Add comparison