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 has been working well overall."
"The solution can scale."
"The most valuable features of Microsoft Azure Synapse Analytics are how easy and quick it is to set up the linked services."
"Its seamless integration with Azure services is most valuable. If somebody wants to use all Azure services, it is the best solution."
"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."
"We find the serverless tool to be the most valuable feature ."
"It's user-friendly and has a good dashboard."
"The MPP (Massively Parallel Processing) architecture helps to make things a lot faster."
"It is a very stable solution."
"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 ability to instantly pull data is the most valuable feature."
"I like that it's quite quick."
"The solution is easier to maintain than traditional SAP products."
"The most valuable aspect of this solution is that the infrastructure is easy to understand."
"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."
"Provides a great analytics engine with all the capabilities."
"Synapse Analytics needs to develop an automation framework because now you have to build a cache yourself. You have to build a pipeline in WhereScape, which does end-to-end pipeline automation well. Microsoft should come up with a framework to save people time. If they developed a tool like WhereScape, it would dramatically reduce development time."
"It could be more stable."
"From an infrastructure standpoint, I believe it can be more secure in terms of availability."
"Microsoft should develop an interface to make it easier to shift from on-premise to the cloud."
"They should provide a less expensive version with a smaller setup for small businesses. Currently, its price is quite high for entry-level or small businesses. In terms of integration, new connectors are always welcomed."
"The product could be more feature-rich."
"I am pretty sure that there are areas that need improvement but I just can think of them 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 dashboard should be simplified and made easier for exploration and decision making."
"The speed of operations could be a little faster."
"The licensing cost could be made better."
"Connecting multiple sources is a challenge because you have to go through a lot of different setups."
"BW/4HANA could improve query optimization. For example, there could be an error message that pops up when you hover over it if any query fails. That would make it easier to find out what went gone wrong. Guided SAP help tools would make it easier for us to go forward."
"The solution is not scalable. It does not have a data streaming feature as well."
"Support could be more reliable."
"Not a ten because it's expensive and its ecosystem is not very open."
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.
