We performed a comparison between Microsoft Azure Synapse Analytics and SAP Business Warehouse based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Its seamless integration with Azure services is most valuable. If somebody wants to use all Azure services, it is the best solution."
"Synapse Analytics' best feature is its ability to process large files."
"The most valuable feature of Microsoft Azure Synapse Analytics is the pipeline that is the ETL tool. It's very well designed and is overall very good. We usually don't use the ETL tool in Databricks, but we use the ETL tool in this solution."
"We also like governance. It looks at what the requirements are for the company to identify the best way to ensure compliance is met when you move to the cloud."
"The most valuable aspect of this Microsoft Azure Synapse Analytics is its consolidation of technical support from Microsoft, and its ability to securely host large quantities of data within the cloud environment. The overall ability to manage and maintain Big Data within the cloud provides a heightened level of efficiency, reliability, and support from Microsoft. This results in a superior user experience and an increased level of value for the end user."
"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 most valuable features of Microsoft Azure Synapse Analytics are the interface and the agility of the on-cloud platform."
"It's scalable; you can scale up and scale down."
"SAP Business Warehouse is a scalable solution."
"Predominantly, our company uses SAP Business Warehouse for reporting purposes across various departments, especially for managers to gain a quick understanding of their current standing and make informed decisions."
"What I like most about SAP Business Warehouse is its ability to feed data into new, multiple systems in various formats. It can open its data to any system over gateway services or a portal or application that needs to consume and analyze data."
"Now, because of the HANA integration, the hard disk and RAM are together, and because of that, the output is very quick and very fast actually."
"In terms of stability, comparatively, the solution is quite stable."
"The solution has functionality that makes it easy for end-users to readily extract data directly from Business Warehouse into Excel and carry on their analysis on their own."
"What I like most about SAP Business Warehouse is that it's a seamless integration platform. A valuable feature in the tool is the monitoring alert that makes you aware of what process chain has failed. There's no manual monitoring required if you have configured an alert system, so the process chain can run in the background, and you can get alerts about it. The functionalities I find good in SAP Business Warehouse are alerting and monitoring. If you have configured the tool and have integrated it with SAP Solution Manager, then it's a good product to use."
"The most valuable feature of SAP Business Warehouse is its hybrid functionality, allowing users to leverage both SQL-based data warehouse capabilities from HANA and feature-based data warehousing from BW."
"With respect to what needs to be improved, concurrent connectivity has some limitations."
"It would be of interest to improve things like the web service integration and availability in terms of being easy to create internal web services in the database."
"In the future, Microsoft Azure Synapse Analytics could improve the performance, there are other solutions that are better, such as Databricks."
"This solution needs to have query caching so that if the same query is run and the results are available, it will return the data from the cache without having to re-run the query."
"It needs strong support for social media, internet data, and native support for NoSQL."
"I would like to see better integration with Active Directory, because we have had problems, and we still do."
"I would like to see them provide the ingestion of images."
"More integration is needed to improve the product for the future."
"The solution could offer better connectivity with other databases."
"More integration with Microsoft Office products (not just Excel) would be helpful."
"They should reduce the product’s installation package size for easier downloading."
"The problem with BW, and the factor that differentiated it from the original BW, is that you only get limited functionality with your runtime license. So, you have to pay extra for extracting data."
"SAP Business Warehouse could improve by having more out-of-the-box use cases to cover more business types or operations."
"What I'd like to improve in SAP Business Warehouse is its data structure, that's a little bit rigid. It could be a bit more flexible, so you can design your data structure and improve performance when creating a solution. Currently, the way data is stored in SAP Business Warehouse is rigid."
"So far, the initial setup process in our company has not been easy enough for us to understand."
"It takes more work to get the data, including reporting on that data, because some coding is required, and a significant level of transformation is needed when using SAP Business Warehouse."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 86 reviews while SAP Business Warehouse is ranked 9th in Cloud Data Warehouse with 25 reviews. Microsoft Azure Synapse Analytics is rated 7.8, while SAP Business Warehouse is rated 7.8. The top reviewer of Microsoft Azure Synapse Analytics writes "No competitors provide the entire solution to one place ". On the other hand, the top reviewer of SAP Business Warehouse writes "Offers powerful analytics and integration capabilities but requires improved upgrade processes". Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, SAP BW4HANA, Snowflake, Oracle Autonomous Data Warehouse and Dremio, whereas SAP Business Warehouse is most compared with Snowflake, BigQuery, SAP BW4HANA, SAP NetWeaver Business Warehouse and Amazon Redshift. See our Microsoft Azure Synapse Analytics vs. SAP Business Warehouse report.
See our list of best Cloud Data Warehouse vendors.
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.
