15 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.4 out of 100
26 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.8 out of 100

Likelihood to Recommend

Azure Synapse Analytics (Azure SQL Data Warehouse)

It is very well suited for big data analytics. Predictive modeling, optimization, and other large scale analysis benefit from using a properly defined SQL Data Warehouse. It is also suited for simple business intelligence such as building historical and active dashboards
Anonymous | TrustRadius Reviewer

SAP BW/4HANA

Solid data warehouse based on best-in-class in-memory HANA database with excellent integration into SAP solutions, as well as predelivered business content facilitating initial implementation. Leverages the best of SAP's architecture and flexible data warehousing capabilities, without compromising performance and simplification. Will be key enabler to our Finance and HCM analytics roadmap.
Anonymous | TrustRadius Reviewer

Pros

Azure Synapse Analytics (Azure SQL Data Warehouse)

  • It is very cost-effective
  • Development time needed was much less in comparison to other systems
  • Played very nicely with our ETL and OLAP reporting tools
Samir Patel, PMP | TrustRadius Reviewer

SAP BW/4HANA

  • Near real-time data replication from HANA databases.
  • Strong BW functionality.
  • A host of cloud reporting tools can seamlessly connect to it.
Robert Harper | TrustRadius Reviewer

Cons

Azure Synapse Analytics (Azure SQL Data Warehouse)

  • Limited T-SQL query library
  • It is not suitable for OLTP environment
  • Doesn't support cross-database queries
Prabhu Sundararaj | TrustRadius Reviewer

SAP BW/4HANA

  • ETL implementation can be complicated
  • Integration with non-SAP systems can take a long time
  • Cost to implement and maintain can be high, even in Cloud
Anonymous | TrustRadius Reviewer

Usability

Azure Synapse Analytics (Azure SQL Data Warehouse)

Azure Synapse Analytics (Azure SQL Data Warehouse) 8.0
Based on 1 answer
It helps us to provide data just in time to our clients. With help of massively parallel processing, it consumes less time for both loading and querying the data and it also helps us to plan a more precise budget to our business and send just-in-time alerts in case of any outrage.
Prabhu Sundararaj | TrustRadius Reviewer

SAP BW/4HANA

SAP BW/4HANA 9.0
Based on 1 answer
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.
Anonymous | TrustRadius Reviewer

Support Rating

Azure Synapse Analytics (Azure SQL Data Warehouse)

Azure Synapse Analytics (Azure SQL Data Warehouse) 8.1
Based on 3 answers
I like their Support team
Anonymous | TrustRadius Reviewer

SAP BW/4HANA

SAP BW/4HANA 8.7
Based on 7 answers
SAP offers specialized support since it is a relatively new product and it is necessary to be able to push the platform.
Martin Lopez | TrustRadius Reviewer

Alternatives Considered

Azure Synapse Analytics (Azure SQL Data Warehouse)

SQL Data Warehousing is much easier to manage if you already have SQL Server experience and analysts who are familiar with its interface. We are currently piloting using NoSQL and Hadoop type databases but it is difficult to get set up properly. Additionally, we have to re-train our users to learn how to create python scripts and use spark to query the data
Anonymous | TrustRadius Reviewer

SAP BW/4HANA

Unfortunately I never had the chance to work with other tools similar to SAP BW/4HANA. In the different companies I've worked for during the past 4 years, they all used SAP, and in particular I worked in SAP BW during the last year.
Anonymous | TrustRadius Reviewer

Return on Investment

Azure Synapse Analytics (Azure SQL Data Warehouse)

  • 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
Samir Patel, PMP | TrustRadius Reviewer

SAP BW/4HANA

  • 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
Mark Villazon | TrustRadius Reviewer

Screenshots

Azure Synapse Analytics (Azure SQL Data Warehouse)

Pricing Details

Azure Synapse Analytics (Azure SQL Data Warehouse)

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

SAP BW/4HANA

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
Optional

Add comparison