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."The solution's best feature is its predictive analytics."
"What I found most valuable in Microsoft Azure Synapse Analytics is that it's native only for Azure, so you get better performance and there's no issue. To explain further, many different types of data come, in particular, structured and unstructured data. For audit purposes, there's also unstructured data, so the most important aspect is that with Microsoft Azure Synapse Analytics, you have the capability of using both technologies, meaning that you can use or mix structured and unstructured data which is important. This can also be done in Hadoop, and on other platforms, so you have everything in one place. You don't have to worry about how to manage both structured and unstructured data and where to store information. With Microsoft Azure Synapse Analytics, you can take care of everything, particularly in Azure. The solution also provides you with many features apart from analytics, for example, storage which makes it better."
"Fills the gap between big data and classic data warehouses."
"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 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 speed is great and the architecture is excellent."
"The most valuable features of Microsoft Azure Synapse Analytics are how easy and quick it is to set up the linked services."
"The features we've found most valuable for data warehouses is extracting data, SSIS packages, and the DBs."
"We benefited from BW/4HANA's ability to utilize predefined content inside. We didn't need to start from scratch."
"The product is stable."
"Out of the box, this solution has a lot of standard features."
"The solution is easier to maintain than traditional SAP products."
"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."
"The solution's performance is really good. Also, it's easy to operate, easy to administer, and relatively simple to install."
"It is a stable solution...The initial setup was easy."
"We like that it is an SAP product, so we can easily connect with the SAP ERP system."
"The performance and data consistency need to be improved."
"I'd like to see part of the service de-coupled."
"This solution needs to have query caching so that if the same query is run and the results are available, it will return the data from the cache without having to re-run the query."
"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."
"An area for improvement in Microsoft Azure Synapse Analytics is its user interface. You can use it for analytical purposes, but its platform should be a little bit more user-friendly. Another small point for improvement in Microsoft Azure Synapse Analytics is its stability. It's good currently, but it could still be improved. Microsoft is combining different tools and technologies into one solution, so in the future, I'm expecting to see even more improvement in Microsoft Azure Synapse Analytics. An additional feature I'd like to see in the next version of Microsoft Azure Synapse Analytics is the drag-and-drop feature. If you're doing some integrations where you can write Scala or you have SPARK programming or SQL, or you're combining different programming, the process should be seamless, and you should be able to drag and drop in Microsoft Azure Synapse Analytics. When doing reporting in the solution, you should also be able to drag and drop. There should be connectors available and a drag-and-drop feature available in the user interface of Microsoft Azure Synapse Analytics, so you won't have to worry about how all processes would work together. You need to be able to drag and drop even from the backend, and having this feature will make the solution more user-friendly."
"It's a complicated product."
"Microsoft Azure Synapse Analytics can improve by adding more flexibility to the reports. Having more visible structures based on the area, region and country would be beneficial."
"The platform is not flexible, and the graphical user interface needs to be improved because the interface makes it hard for the end user to use it."
"It takes too long to escalate problems from the first level of support."
"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."
"Other competitors provide better solutions that are more up to date with current technology."
"Not a ten because it's expensive and its ecosystem is not very open."
"Support could be more reliable."
"If I want to have good reporting, then I have to buy a separate license."
"The solution is not easy to implement. It requires a lot of learning at the beginning."
"I cannot integrate it with my other tools. It's not possible to do something in the predictive analysis. Mobile reporting is also not available."
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.