We performed a comparison between Microsoft Azure Synapse Analytics and SAP BW4HANA based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."This is a stable solution with many functionalities."
"It's user-friendly and has a good dashboard."
"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 pricing seems to be quite fair."
"The solution can scale."
"The most important feature for me is the integration with PolyBase."
"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 architecture, including compute and storage, is good."
"Out of the box, this solution has a lot of standard features."
"Some of the main features of this solution are that it uses HANA and it has good performance."
"It's quite scalable."
"We like that it is an SAP product, so we can easily connect with the SAP ERP system."
"One significant advantage of SAP BW/4HANA is the direct integration with the SAP HANA database, providing seamless access to real-time analytics. Additionally, it enables real-time data integration. We don't need to rely on historical data alone; we can provide reporting and features based on real-time information."
"The most valuable aspect of this solution is that the infrastructure is easy to understand."
"SAP BW4HANA aids in managing data from ER to front-end analysis, contributes to ROI, and fosters business growth understanding. I like that the solution breaks down components to a very granular level, allowing for customization and implementation based on specific requirements. The solution is stable. The solution is scalable."
"It is a very stable solution."
"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."
"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."
"In the future, Microsoft Azure Synapse Analytics has the potential to enhance its capabilities by expanding its connectors, specifically with regard to Oracle solutions, such as operating systems. This would involve a comprehensive approach to adding more connectors for both data input and consumption purposes. By doing so, Microsoft Azure Synapse Analytics would be better equipped to meet the diverse needs of its users and achieve greater efficiency in its performance. The provision of more connectors is definitely a crucial area that needs improvement."
"We'd, of course, always like to pay less for the service if we can."
"We encountered data processing and transformation issues while working with Apache Spark languages for the product."
"Microsoft Azure Synapse Analytics could improve in usability. I have found the same issue with all Microsoft solutions."
"The solution does not support oriented scaling in the synapse."
"Synapse Analytics' performance slows down if you don't get your distribution right because it gets queued and goes into a single node."
"The solution is not easy to implement. It requires a lot of learning at the beginning."
"The product needs to improve with more performance and fewer data layers."
"Pricing would be a good improvement. A lot of customers think that it's very expensive and especially support is very expensive."
"Price wise, this solution is on the higher side."
"It takes too long to escalate problems from the first level of support."
"There's one area where the other vendors have an upper edge, which is the data lake. I think SAP is trying to figure out whether to stick with IQ, their own data lake solution, or push customers toward customer-preferred vendors, like Azure Data Lake, AWS, or any other provider."
"Support could be more reliable."
"I would like to be able to design new reports in a future release."
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 BW4HANA is ranked 8th in Data Warehouse with 37 reviews. Microsoft Azure Synapse Analytics is rated 7.8, while SAP BW4HANA is rated 7.4. 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 BW4HANA writes "Performs all necessary data warehouse tasks and offers additional functionalities". Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, Snowflake, Oracle Autonomous Data Warehouse, Teradata and Amazon Redshift, whereas SAP BW4HANA is most compared with Snowflake, SAP HANA, Amazon Redshift, SQL Server and SAP Business Warehouse. See our Microsoft Azure Synapse Analytics vs. SAP BW4HANA report.
See our list of best Data Warehouse vendors.
We monitor all 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.