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."The most important feature for me is the integration with PolyBase."
"We find the serverless tool to be the most valuable feature ."
"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 a benefit."
"It is a fantastic product; we are satisfied with its features and performance."
"The solution operates like a typical SQL Server environment so there is no alienation in terms of technical knowledge."
"Synapse Analytics' best feature is its ability to process large files."
"Technical support is okay in terms of the help they provide."
"It's quite quick for querying, even with large datasets, and it's scalable. It's also flexible to use, so it's easy to update and get data quickly without wasting time."
"The most valuable feature of this solution is the advanced structuring of data capabilities. You can get different structures of data to suit your needs."
"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."
"In terms of stability, comparatively, the solution is quite stable."
"The real-time information is great."
"The most valuable aspect of the solution is the integration with SAP ERP."
"The key element in this solution is its rapid response. If you have a question about prices, buyers, customers, providers, or services, you need the answer in a minute or two. That's the key benefit for us that a solution like BW gives us."
"The features that I have found most valuable are its capabilities to connect to Excel and to slice and dice."
"I like that it integrates to open-source."
"Microsoft Azure Synapse Analytics could improve the section in the solution where you can implement the Python Spark pipelines, it's not the same as in Databricks which would be better."
"We'd like the solution to have more analytics capability."
"I would like to see them provide the ingestion of images."
"The filing can be improved."
"This is a young product in transition to the cloud and it needs more work before it is both settled as a product and competitive in the market."
"It would be beneficial to take the top vendors and identify some kind of straightforward action to work with them. Instead of having to employ a separate vendor tool to be able to move this, it would be nice to be able to go through Microsoft."
"Real-time integration is hard to do in Microsoft Azure Synapse Analytics."
"Integration with other vendors has limitations and could be improved."
"One of our requirements is the ability to easily get answers regarding trends and exceptions. In BW, it is not that easy to get such information. I expect better trend and exception detection, better pattern detection."
"They should reduce the product’s installation package size for easier downloading."
"We are very unhappy with technical support. First of all, they send their sales agents or pre-sales agents and most of them who don't know the solution as a properly trained tech would. We have an on-site SAP representative who is supposed to help us with our high priority and production issues, and they're not satisfactory to say the least."
"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."
"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."
"SAP Business Warehouse could improve by having more out-of-the-box use cases to cover more business types or operations."
"Areas for improvement in SAP Business Warehouse include enhancing scheduling and monitoring tools, as well as improving communication about hidden features to make them more accessible to users."
"In the next release, my suggestion would be to have user-friendly interfaces and performance issues be addressed."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 85 reviews while SAP Business Warehouse is ranked 8th 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 Microsoft Parallel Data Warehouse, whereas SAP Business Warehouse is most compared with Snowflake, BigQuery, SAP BW4HANA, Amazon Redshift and SAP NetWeaver Business Warehouse. 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.
