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."
"One of the most valuable features of this solution is its ability to integrate well with other services offered by Azure."
"The useability, the user interface, is very user-friendly."
"The features most valuable are the simplicity, how easy it is to create a dashboard from different information systems."
"The most valuable feature of Microsoft Azure Synapse Analytics is the pipeline that is the ETL tool. It's very well designed and is overall very good. We usually don't use the ETL tool in Databricks, but we use the ETL tool in this solution."
"The most valuable feature of Microsoft Azure Synapse Analytics is the capabilities, and the integration with other Azure resources, such as Data Factory, Databricks, and Spark for data processing. The overall ability to compose the solution with other Azure resources is valuable."
"The setup is pretty simple."
"We've had a good experience with technical support in general."
"The most valuable feature is the dashboard."
"From an ERP point of view and a functionality point of view, it works very well. The benefits are in that of financial costing and material management."
"We like that it is an SAP product, so we can easily connect with the SAP ERP system."
"The solution is easier to maintain than traditional SAP products."
"I like the reporting features of the solution."
"Provides a great analytics engine with all the capabilities."
"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."
"The solution seamlessly integrates with SAP products."
"It's pay as you go, so you never know what your bill is going to be beforehand, and that's scary for customers. If you have someone who makes a mistake and the program's a loop that is running all night, you could receive a very expensive bill."
"I am a researcher. For people to be able to research a solution, there should be at least a free trial. Just advertising a product or saying that this product is better doesn't work. I would strongly recommend providing a lot of free trials and trainings. This will also help Microsoft in having more users or customers. Oracle provides some free trials. You can just go for a free trial and use your database online, which is very good."
"We encountered data processing and transformation issues while working with Apache Spark languages for the product."
"Documentation could be improved."
"With respect to what needs to be improved, concurrent connectivity has some limitations."
"Microsoft Azure Synapse Analytics could improve its compatibility with Visual Studio. One of the challenges for people moving from an on-premise to a cloud solution, such as Microsoft Azure Synapse Analytics, is that you're constantly working in a browser. There are people that have been working for decades on desktop applications. For them to start working in a browser, it's quite a change. Allowing people to work and do their work inside Visual Studio than in the browser, would be a large advantage."
"Synapse Analytics is generally stable, but its performance can be slow when performing very large datasets."
"We'd, of course, always like to pay less for the service if we can."
"I would like more integration."
"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."
"If I want to have good reporting, then I have to buy a separate license."
"Support could be more reliable."
"Not a ten because it's expensive and its ecosystem is not very open."
"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."
"In the next release, I would like to see their BI component introduced with a mobile version, as it is not currently present."
"The solution is not easy to implement. It requires a lot of learning at the beginning."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 85 reviews while SAP BW4HANA is ranked 7th in Data Warehouse with 34 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, Amazon Redshift, SAP HANA, 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.