We just raised a $30M Series A: Read our story

Compare Microsoft Azure Synapse Analytics vs. SAP BW4HANA

You must select at least 2 products to compare!
Featured Review
Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon and others in Cloud Data Warehouse. Updated: November 2021.
552,136 professionals have used our research since 2012.
Quotes From Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

"Overall deployment and integration is pretty fast.""The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range.""The stability is pretty good.""I like its performance. It is well-structured and offers a lot of practical options. Because of the visual design of the product, it is very easy to find icons and other visual elements. It took me more than two weeks to understand how it works. I had an intensive training session to understand it, which was enough. It was not hard to understand how it works.""The solution's scalability is very, very good. It's one of the most important aspects for us.""I think the most valuable component is that pipelines are built into it and then the feature that you can mirror a cosmos BB for analytics.""The ability to scale out services on-demand and scale them down when they are not required is most valuable. You are in control of your expenditures, and you are also in control of the horsepower that you need. That's a major advantage.""The speed is great and the architecture is excellent."

More Microsoft Azure Synapse Analytics Pros »

"The most valuable features are the speed of reporting and the HANA database.""Out of the box, this solution has a lot of standard features.""From an ERP point of view and a functionality point of view, it works very well. The benefits are in that of financial costing and material management.""Some of the main features of this solution are that it uses HANA and it has good performance.""It can calculate data in detail. Before we could not calculate financial documents and accountant documents in detail, we could not do it at a document level but now we can. This is the most important feature. It also has predictive analysis memory.""The most valuable aspect of this solution is that the infrastructure is easy to understand.""The solution is easier to maintain than traditional SAP products.""Its direct approach is the most valuable. You get more real time and capabilities than BW."

More SAP BW4HANA Pros »

"When I was trying to link services to an SFTP site it was not able to do all the possible encryption that I needed. They can improve by adding more encryption options.""Unfortunately, we have had some issues with the dashboard reporting. Sometimes, the data for specific periods would just appear blank on the dashboard. To investigate this, we worked with a Microsoft incident agent and it turned out to be a result of bugs in the platform when dealing with specific types of queries in Azure Data Factory.""I would like to see version control implemented into the data warehouse.""The initial setup has a bit of a learning curve.""I am pretty sure that there are areas that need improvement but I just can think of them off the top of my head.""Indicating what areas need improvement in this solution is a difficult question because the organizations that I am working for are really new in this area. However, an even better more simple interface, or perhaps an extension of a connector app store solution, would be helpful.""The performance needs to improve in future releases.""More integration is needed to improve the product for the future."

More Microsoft Azure Synapse Analytics Cons »

"Not a ten because it's expensive and its ecosystem is not very open.""It takes too long to escalate problems from the first level of support.""I would like more integration.""In the next release, I would like to see their BI component introduced with a mobile version, as it is not currently present.""Connecting multiple sources is a challenge because you have to go through a lot of different setups.""Pricing would be a good improvement. A lot of customers think that it's very expensive and especially support is very expensive.""Other competitors provide better solutions that are more up to date with current technology.""The solution does occasionally get a few bugs, but this is typical for any product."

More SAP BW4HANA Cons »

Pricing and Cost Advice
"Its price could be better. It was a school project, and I got it for free. If I try to pay through my company, it is a little bit more expensive as compared to Oracle.""Our license is very expensive""We chose the serverless option for the database which has saved us a lot of money. Our costs are approximately £600 per month.""We are on a monthly payment plan for the use of Microsoft Azure Synapse Analytics.""There is a cost calculator available online that allows you to input your entire scenario, and it will get back to you with information on what the costs are going to be.""They are cost aggressive, and it integrates well with other Microsoft tools.""It goes by the usage, and there are some limits. Synapse goes by particular pricing, and it is expensive. Both Azure Synapse Analytics and Snowflake are pretty expensive. They don't have standard pricing. They deal with each customer differently.""The licensing fees for this solution are on a pay-per-use basis, and not very expensive."

More Microsoft Azure Synapse Analytics Pricing and Cost Advice »

"As an investment, the solution is very expensive.""We started as early birds from the SAP side. We got this entire suite for free. I cannot really talk about the price because we didn't have to pay anything.""This is an expensive solution and there are costs in addition to the standard licensing fees.""In general, it's quite expensive."

More SAP BW4HANA Pricing and Cost Advice »

Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
552,136 professionals have used our research since 2012.
Questions from the Community
Top Answer: Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different… more »
Top Answer: Traditional ETL would usually use a dedicated database (or even database server) where you'll load & transform your raw data before ingesting it into the final destination. This would allow checking… more »
Top Answer: The integrated workspace in Microsoft Azure Synapse Analytics where everything comes together, such as Power BI and Data Factory, is very good. Additionally, the ability to do dedicated SQL pooling is… more »
Top Answer: Some of the main features of this solution are that it uses HANA and it has good performance.
Top Answer: As an investment, the solution is very expensive. We pay 72% every year to SAP. Additionally, we pay for support for the solution and a vendor to do maintenance.
Top Answer: Other competitors provide better solutions that are more up to date with current technology. For example, machine learning and artificial intelligence.
Average Words per Review
out of 30 in Data Warehouse
Average Words per Review
Also Known As
Azure Synapse Analytics, Microsoft Azure SQL Data Warehouse, Microsoft Azure SQL DW, Azure SQL Data Warehouse, MS Azure Synapse Analytics
Learn More

Azure SQL Data Warehouse is a Fast, flexible, and secure analytics platform for the enterprise. Azure SQL Data Warehouse lets you independently scale compute and storage, while pausing and resuming your data warehouse within minutes through a massively parallel processing architecture designed for the cloud. Seamlessly create your hub for analytics along with native connectivity with data integration and visualization services, all while using your existing SQL and BI skills.

Streamline processes and support innovations with a single, trusted source for real-time insights. Based on SAP HANA, our next-generation data warehouse solution can help you capitalize on the full value of all your data from SAP applications or third-party solutions, as well as unstructured, geospatial, or Hadoop-based.

Learn more about Microsoft Azure Synapse Analytics
Learn more about SAP BW4HANA
Sample Customers
Toshiba, Carnival, LG Electronics, Jet.com, Adobe, 
Information Not Available
Top Industries
Comms Service Provider18%
Computer Software Company18%
Manufacturing Company12%
Insurance Company12%
Computer Software Company28%
Comms Service Provider18%
Financial Services Firm6%
Energy/Utilities Company6%
Computer Software Company36%
Comms Service Provider19%
Energy/Utilities Company7%
Manufacturing Company6%
Company Size
Small Business32%
Midsize Enterprise23%
Large Enterprise45%
Small Business15%
Midsize Enterprise11%
Large Enterprise74%
Small Business36%
Large Enterprise64%
Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon and others in Cloud Data Warehouse. Updated: November 2021.
552,136 professionals have used our research since 2012.

Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 34 reviews while SAP BW4HANA is ranked 8th in Data Warehouse with 10 reviews. Microsoft Azure Synapse Analytics is rated 8.0, while SAP BW4HANA is rated 7.8. The top reviewer of Microsoft Azure Synapse Analytics writes "Scalable, intuitive, facilitates compliance and keeping your data secure". On the other hand, the top reviewer of SAP BW4HANA writes "Good capabilities, direct approach, and the right reporting tool for SAP companies". Microsoft Azure Synapse Analytics is most compared with Snowflake, Amazon Redshift, Apache Hadoop, Oracle Autonomous Data Warehouse and Microsoft Parallel Data Warehouse, whereas SAP BW4HANA is most compared with Snowflake, Amazon Redshift, Microsoft Parallel Data Warehouse, Apache Hadoop and Oracle Database Appliance.

We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.