We performed a comparison between Microsoft Azure Synapse Analytics and SAP Business Warehouse based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most advantageous aspect of Microsoft Azure Synapse Analytics is its simplified data transformation process compared to traditional databases. This makes data cleansing and transformation more manageable and straightforward, which we appreciate. It is much easier to build as well."
"The most valuable feature of the solution is the analytics and that it can connect with Power BI."
"We find the serverless tool to be the most valuable feature ."
"We can have the dedicated SQL up and running within 15 minutes."
"The most valuable feature is the level of processing power, and being able to complete tasks in parallel."
"The initial setup is very simple."
"It's scalable; you can scale up and scale down."
"They are very reliable and cost-effective."
"The most valuable aspect of the solution is the integration with SAP ERP."
"I like that it integrates to open-source."
"With the technical support, the response has been pretty good from the SAP side."
"The most useful feature is definitely the speed."
"Out-of-the-box reports are very useful."
"The warehouse is the solution's most valuable feature."
"The product is very stable."
"The most valuable feature of this solution is the advanced structuring of data capabilities. You can get different structures of data to suit your needs."
"It's stable, but its stability could be better. However, we understand that it's in production, and new features are getting added and upgraded, so you do get hiccups sometimes."
"The only issue that we have run into with the solutions performance is with regards to concurrency."
"It would be ideal if the solution could be better used intuitively by the staff without having a great deal of training."
"Non-structured data is unavailable with this product."
"Microsoft Azure Synapse Analytics can improve by increasing the size of the files that we can load on the platform. We have some files that are too large to be loaded and it would be a benefit to us if the limit was increased. Additionally, the way we use the tool for generating reports can be made better. They should add some drag-and-drop rules without the need of programming these rules using some programming language. It would be helpful if we did not need someone that was technically advanced to be able to do it with, such as someone with no IT background. Having a reporting tool without code would be great."
"There is a limit on the number of concurrent queries to around 125 for Azure Synapse."
"We'd like the solution to have more analytics capability."
"Scaling this solution up and down is not quick and easy. This could be improved. The pricing of this solution could also be improved."
"More integration with Microsoft Office products (not just Excel) would be helpful."
"What I'd like improved in SAP Business Warehouse is its setup. It could be more flexible, and it could be a configuration-based setup."
"One of our requirements is the ability to easily get answers regarding trends and exceptions. In BW, it is not that easy to get such information. I expect better trend and exception detection, better pattern detection."
"SAP Business Warehouse could integrate better with other ETL tools."
"A few things which are missing include the visualization of reports. That's where your costs and licensing become heavy. When it comes to this database compared Microsoft Warehouse, it's an expensive solution."
"It takes more work to get the data, including reporting on that data, because some coding is required, and a significant level of transformation is needed when using SAP Business Warehouse."
"They should reduce the product’s installation package size for easier downloading."
"It's a product that is at the end of life so they will not improve it anymore."
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 Business Warehouse is ranked 9th in Cloud Data Warehouse with 25 reviews. Microsoft Azure Synapse Analytics is rated 7.8, while SAP Business Warehouse is rated 7.8. 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 Business Warehouse writes "Offers powerful analytics and integration capabilities but requires improved upgrade processes". Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, SAP BW4HANA, Snowflake, Oracle Autonomous Data Warehouse and Dremio, whereas SAP Business Warehouse is most compared with Snowflake, BigQuery, SAP BW4HANA, SAP NetWeaver Business Warehouse and Amazon Redshift. See our Microsoft Azure Synapse Analytics vs. SAP Business Warehouse report.
See our list of best Cloud Data Warehouse vendors.
We monitor all Cloud 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.