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."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."
"We find the serverless tool to be the most valuable feature ."
"The most valuable features of Microsoft Azure Synapse Analytics are how easy and quick it is to set up the linked services."
"The pricing seems to be quite fair."
"The solution has been working well overall."
"I like how Microsoft Azure Synapse Analytics integrates with other Microsoft solutions."
"The most valuable feature is that you can suspend the computer if it is not being used, which means that you don't incur costs."
"The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range."
"I like that it integrates to open-source."
"Having the integration with the reporting tool which is provided by SAP is great."
"The most useful feature is definitely the speed."
"We are currently in a basic stage of analytics and the first goal we have is to make sure the numbers are correct. BW has some features that help you to build factors and ETL in such a way that it's easy to get to correct responses. That's the number one condition that you have to have in an analytic solution."
"The product is very stable."
"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."
"SAP Business Warehouse is a scalable solution."
"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."
"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."
"Microsoft Azure Synapse Analytics could improve in usability. I have found the same issue with all Microsoft solutions."
"We'd, of course, always like to pay less for the service if we can."
"It would be ideal if the solution could be better used intuitively by the staff without having a great deal of training."
"The support and price could improve."
"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 initial setup process needs improvement. When you're moving to the cloud it takes a bit of time. It would be great if they could implement something that would make it faster."
"The cost of the solution has room for improvement."
"SAP Business Warehouse could integrate better with other ETL tools."
"I get all the information quickly, but it is one day old."
"More integration with Microsoft Office products (not just Excel) would be helpful."
"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."
"They should reduce the product’s installation package size for easier downloading."
"The solution could offer better connectivity with other databases."
"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."
"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 Microsoft Parallel Data Warehouse, 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.