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 stability is pretty good."
"We use Azure Synapse Analytics in many different areas and industries, so I like that you can administrate and create pipelines for difference sources of data and later integrate and deploy it to other internal areas, such as separate dashboards for financials, and so on."
"Microsoft provides both the platform and the data center, so you don't have to look for a cloud vendor. It saves you from having to deal with two vendors for the same task."
"The platform has multiple valuable use cases. They include performance, compatibility, flexibility, and cost."
"I like how Microsoft Azure Synapse Analytics integrates with other Microsoft solutions."
"The setup is pretty simple."
"The features we've found most valuable for data warehouses is extracting data, SSIS packages, and the DBs."
"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."
"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 the technical support, the response has been pretty good from the SAP side."
"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."
"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."
"The most useful feature is definitely the speed."
"Having the integration with the reporting tool which is provided by SAP is great."
"The product is very stable."
"SAP Business Warehouse is a scalable solution."
"The only issue that we have run into with the solutions performance is with regards to concurrency."
"The macro functions, though useful, are not totally user-friendly. Some people have difficulties in learning them."
"The need to improve a little bit in terms of user-friendliness."
"Synapse Analytics is generally stable, but its performance can be slow when performing very large datasets."
"It's stable, but its stability could be better. However, we understand that it's in production, and new features are getting added and upgraded, so you do get hiccups sometimes."
"We encountered data processing and transformation issues while working with Apache Spark languages for the product."
"In the future, Microsoft Azure Synapse Analytics could improve the performance, there are other solutions that are better, such as Databricks."
"Documentation could be improved."
"In the next release, my suggestion would be to have user-friendly interfaces and performance issues be addressed."
"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."
"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."
"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."
"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."
"More integration with Microsoft Office products (not just Excel) would be helpful."
"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."
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.