Azure Synapse Analytics (Azure SQL Data Warehouse) vs SAP BW

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

SAP BW is best for:1. Large enterprises2. Enterprises with 3+ legacy systems with entrenched users (politically difficult to merge)3. Enterprises with employees who can understand both the technical capabilities of SAP BW and the needs of the business users - ability to speak both languages, otherwise the program could be unwieldy and potentially underutilized (it's not particularly inexpensive)SAP BW is less appropriate for:1. Small enterprises2. Enterprises who have well established, same location, CRM and UFS - the integration of data analysis will be easier and less expensive with other solutions3. HANA

Read full review

Jeff Looby, CPA

Associate

Credit SuisseBanking, 10,001+ employees

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

it has the best availability tool for generating different reports like Bex analyzer
different data models like sementic data model for different data management systems
can easily integrate and generate the reports from different sources like XML file uploading, 3rd party data sources etc...

Read full review

Pradeep Bele

Sr. SAP Basis Consultant

Gauri Ltd. | Transforming Customer Engagement For The Digital AgeInformation Technology and Services, 51-200 employees

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

I wish it could hold a part where even though it is not in use yet, but you know you will need it, it won't allow it to be checked it rather than put on backorder.
Some of the menu paths can be a little difficult to remember or follow.
It is not easy for a novice user to go in and create a report quickly.

Read full review

Brandi Brown-Lang

Sales and Purchasing Administrator

SitelAirlines/Aviation, 1001-5000 employees

View all 15 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 9.0

Based on 1 answer

It basically stores all data I need in designed reports, which helps a lot with the analysis and calculation.It's quite interactive when you understand reports and know how to drill-down/swap. Fresh users might need some training. There are quite a lot of options to display data differently, or to add more filters in data as well as to extract the data in xlsx/csv/html format.

Read full review

Verified User

Employee in Finance and Accounting

Chemicals Company, 10,001+ employees

View all 1 answers on this topic

Support Rating

Azure Synapse Analytics (Azure SQL Data Warehouse) 7.9

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 8.0

Based on 4 answers

SAP BW is a consolidated tool. There are thousands of SAP notes in order to solve your problems and in case do not exist, SAP support will help you on the issue you face.

Read full review

Verified User

Consultant in Information Technology

Education Management Company, 51-200 employees

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

SAP Business Warehouse scores higher in data warehouse functionalities for integration to SAP ERP and other SAP solutions such as SAP CRM, SAP APO, and SAP SRM. Standard SAP data source extractors which are available in SAP ERP can be used immediately for full or delta replication into SAP Business Warehouse. System governance in SAP Business Warehouse is top-notch with change management support for migration between system landscape from the development system to production system.

Read full review

Julius Shen

Senior System Analyst

Roads and Maritime ServicesCivil Engineering, 10,001+ employees

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

The positive Return on Investment we receive with the software was the ability to import decades of data. We were then able to review the materials see trends we were previously unable to see without intense work.
The only negative impact was applying the training and changing procedures to deal with the software. This worked out, obviously, because this is not a software to be using without proper training.

Read full review

Alfred Brock

Communications Specialist

Yazaki North AmericaAutomotive, 10,001+ employees

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

—

Entry-level set up fee?

No