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."Synapse Analytics' best feature is its ability to process large files."
"The product works well with other Azure products."
"The most valuable features of Microsoft Azure Synapse Analytics are the user experience because it is easy to make analyses, load different databases, and different resources. Our end users can do the analysis by themselves without IT supervising. This is a great aspect of the solution, it's better for our environment."
"The solution has been working well overall."
"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 speed is great and the architecture is excellent."
"The product is easy to use, and anybody can easily migrate to advanced DB."
"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 feature of SAP Business Warehouse is transformation, where I extract data from different sources, particularly the raw data. Then I do some transformations and store that in a format that allows me to do reporting easily."
"With the technical support, the response has been pretty good from the SAP side."
"Out-of-the-box reports are very useful."
"The most valuable aspect of the solution is the integration with SAP ERP."
"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 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."
"SAP Business Warehouse is a scalable solution."
"Having the back-end data set with the right information is the best qualification for this solution."
"I'd like to see part of the service de-coupled."
"Microsoft Azure Synapse Analytics's pricing could be reduced."
"The security performance and cost are the two things that needs improvement."
"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."
"Its stability is an issue. They have been releasing a version every six months to one year, which means that there are many versions available, and clients are not up to speed on the latest one that they're offering. From a stability point of view, they could do better. They're still upgrading their Synapse Analytics workspace, and it is not that stable. Its scalability can also be better."
"The product needs a tool that allows for work from a laptop instead of a browser."
"Integration with other products is an area that can be improved."
"I am very sure that there are areas in need of improvement, but I can't recall what they are off the top of my head."
"So far, the initial setup process in our company has not been easy enough for us to understand."
"SAP Business Warehouse could integrate better with other ETL tools."
"A few things which are missing include the visualization of reports. That's where your costs and licensing become heavy. When it comes to this database compared Microsoft Warehouse, it's an expensive solution."
"The solution could offer better connectivity with other databases."
"In the next release, my suggestion would be to have user-friendly interfaces and performance issues be addressed."
"You can start quickly but, when you have to get a little more detailed, when you have to change something, when you have to solve problems, it's not that easy. It's easy to start but evolving is not that easy."
"The advanced structuring can be complicated and the interface is not very intuitive."
"It's a product that is at the end of life so they will not improve it anymore."
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.