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 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."
"We can have the dedicated SQL up and running within 15 minutes."
"The most valuable features of Microsoft Azure Synapse Analytics are its serverless flexibility and complete power have allowed me to explore various different use cases. While I am not an expert in the product, my experience in programming in Databricks has shown me that Microsoft's investments in Synapse could potentially lead to it becoming a complete replacement for Databricks in the future."
"The architecture, including compute and storage, is good."
"Synapse makes it easy to integrate and onboard data from other Microsoft and Azure sources. The interface is familiar because we were using Azure Data Factory before Synapse. It made the transition even easier because the Synapse interface is exactly the same."
"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 best thing about it is that it has integration at multiple places. It can talk to more than 90 types of data sources, which is one good thing about it."
"The most valuable feature is performance gains."
"I like that it integrates to open-source."
"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."
"The most useful feature is definitely the speed."
"Having the back-end data set with the right information is the best qualification for this solution."
"Having the integration with the reporting tool which is provided by SAP is great."
"The warehouse is the solution's most valuable feature."
"With the technical support, the response has been pretty good from the SAP side."
"The product is very stable."
"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."
"We'd, of course, always like to pay less for the service if we can."
"Synapse makes it easy to integrate and onboard data from other Microsoft and Azure sources. The interface is familiar because we were using Azure Data Factory before Synapse. It made the transition even easier because the Synapse interface is exactly the same."
"From an infrastructure standpoint, I believe it can be more secure in terms of availability."
"I would like my team to be able to build pipelines that integrate with the Azure Data Factory."
"The configuration for things like high-availability could be more user-friendly for non-technical users."
"The initial setup is complex."
"It's a complicated product."
"In the next release, my suggestion would be to have user-friendly interfaces and performance issues be addressed."
"I get all the information quickly, but it is one day old."
"The way the data is stored is kind of rigid in SAP BW as a product. It could be more flexible so that when we are designing a solution, we can design our own data structures and try to improve performance."
"I'm not sure if our issue is related to BW or the Analysis Office. However, we're having performance issues in terms of time. It takes a long time to generate the report."
"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."
"The advanced structuring can be complicated and the interface is not very intuitive."
"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."
"What I'd like improved in SAP Business Warehouse is its setup. It could be more flexible, and it could be a configuration-based setup."
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.