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."We have found that it is easy to develop and to do the analytics in the modules of data."
"The pricing seems to be quite fair."
"Our primary use case is for gathering data and analytics. We provide insights into vehicle data. We gather millions of records per second and we have various millions of vehicles running across."
"It is a fantastic product; we are satisfied with its features and performance."
"The most valuable feature is the scalability."
"Its scalability and ease of use are valuable. It is fairly simple for a tool that's that powerful. If you have a background in Microsoft SQL Server, it is a very easy-to-transition path."
"The platform has multiple valuable use cases. They include performance, compatibility, flexibility, and cost."
"The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range."
"It's quite scalable."
"The most valuable feature is that it's robust."
"It is a stable solution."
"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."
"We can get good visualization and less redundant data."
"We like that it is an SAP product, so we can easily connect with the SAP ERP system."
"We benefited from BW/4HANA's ability to utilize predefined content inside. We didn't need to start from scratch."
"You can do hierarchical alert slicing and dicing out-of-box, which is not available in other solutions. I haven't come across that in Oracle or any other software provider."
"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."
"The security performance and cost are the two things that needs improvement."
"Synapse Analytics is generally stable, but its performance can be slow when performing very large datasets."
"Microsoft should develop an interface to make it easier to shift from on-premise to the cloud."
"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."
"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."
"The macro functions, though useful, are not totally user-friendly. Some people have difficulties in learning them."
"From a technical perspective, it could be even more related to legacy systems. The connectivity requirement is quite high and requires systems that are up-to-date."
"The dashboard should be simplified and made easier for exploration and decision making."
"Challenges arise with real-time client requirements when clients are accustomed to Microsoft Excel's extensive features for data analysis. They expect similar flexibility and customization in the solution, particularly regarding headers displaying keys and descriptions or just keys. Achieving this level of customization can be challenging, and it's an area that may need improvement."
"The cost of the product might be an area that might introduce some restrictions or limitations to customers, making it one of the aspects where improvements are required."
"Support could be more reliable."
"It's complicated to use. You need to spend a lot of time learning about it. The interface could be improved. It's not intuitive to build a data model and use their ETL tools."
"The tool is not easy to use for an end user."
"The tool is not cloud-compatible."
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 7th in Data Warehouse with 36 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 "An easy-to-operate and administer tool that needs to consider revising its existing licensing cost". 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 NetWeaver 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.