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

Likelihood to Recommend

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

Read full review

Verified User

Contributor in Information Technology

Information Technology and Services Company, 10,001+ employees

View all 4 answers on this topic

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.

Read full review

Verified User

Director in Information Technology

Telecommunications Company, 10,001+ employees

View all 7 answers on this topic

Pros

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

Read full review

Samir Patel, PMP

SQL Development Team Lead

Allianz Asset ManagementInvestment Management, 1001-5000 employees

View all 4 answers on this topic

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

Read full review

Robert Harper

Product Owner - Management Reporting SAP S4 / HANA

HP IncInformation Technology and Services, 10,001+ employees

View all 7 answers on this topic

Cons

Limited T-SQL query library
It is not suitable for OLTP environment
Doesn't support cross-database queries

Read full review

Prabhu Sundararaj

Associate - Project

CognizantInformation Technology & Services, 10,001+ employees

View all 4 answers on this topic

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

Read full review

Verified User

Executive in Information Technology

Consumer Goods Company, 10,001+ employees

View all 7 answers on this topic

Usability

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.

Read full review

Prabhu Sundararaj

Associate - Project

CognizantInformation Technology & Services, 10,001+ employees

View all 1 answers on this topic

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.

Read full review

Verified User

Director in Information Technology

Telecommunications Company, 10,001+ employees

View all 1 answers on this topic

Support Rating

Azure Synapse Analytics (Azure SQL Data Warehouse) 8.1

Based on 3 answers

I like their Support team

Read full review

Verified User

Consultant in Information Technology

Information Technology and Services Company, 10,001+ employees

View all 3 answers on this topic

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.

Read full review

Martin Lopez

Gerente de Consultoría

SEIDOR AnalyticsInformation Technology and Services, 201-500 employees

View all 7 answers on this topic

Alternatives Considered

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

Read full review

Verified User

Contributor in Information Technology

Information Technology and Services Company, 10,001+ employees

View all 4 answers on this topic

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.

Read full review

Verified User

Employee in Marketing

Electrical & Electronic Manufacturing Company, 5001-10,000 employees

View all 7 answers on this topic

Return on Investment

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

Samir Patel, PMP

SQL Development Team Lead

Allianz Asset ManagementInvestment Management, 1001-5000 employees

View all 4 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

Mark Villazon

Senior Technical Specialist

Rio TintoMining & Metals, 10,001+ employees

View all 7 answers on this topic

Pricing Details

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

Yes

Entry-level set up fee?

Optional

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