We performed a comparison between IBM Db2 Warehouse on Cloud and Microsoft Azure Synapse Analytics 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 performance is okay as long as the volume of queries is not too high."
"It will be MPP, so performance should improve."
"The way that it scales will help a lot of customers that are stuck with Netezza boxes that can't grow any larger."
"The most important feature for me is the integration with PolyBase."
"The most valuable features of Microsoft Azure Synapse Analytics are the user experience because it is easy to make analyses, load different databases, and different resources. Our end users can do the analysis by themselves without IT supervising. This is a great aspect of the solution, it's better for our environment."
"The solution's best feature is its predictive analytics."
"The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range."
"Its seamless integration with Azure services is most valuable. If somebody wants to use all Azure services, it is the best solution."
"The most valuable features of Microsoft Azure Synapse Analytics are how easy and quick it is to set up the linked services."
"The most valuable feature of Microsoft Azure Synapse Analytics is its integration with the new legacy systems. Whatever application we want to integrate, we receive the reports based on the objects. The solution is easy to purchase from the cloud."
"Synapse Analytics' best feature is its ability to process large files."
"Right now, we are implementing on ESX VMware 6.0. Support for this platform is poor. Also, one of the backup/recovery options is broken and IBM is not addressing the issue."
"Tech support for dashDB is awful. We usually have tickets open for three to four weeks."
"Ultimately, the product itself has challenges and we are not currently satisfied with the support, either."
"Containers get corrupted very easily. Restoring them using GPFS can result in a lot of issues."
"It would be beneficial to take the top vendors and identify some kind of straightforward action to work with them. Instead of having to employ a separate vendor tool to be able to move this, it would be nice to be able to go through Microsoft."
"It could be beneficial to focus on integration with various data sources and similar enhancements."
"I would like to see version control implemented into the data warehouse."
"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."
"The configuration for things like high-availability could be more user-friendly for non-technical users."
"There is a limit on the number of concurrent queries to around 125 for Azure Synapse."
"Microsoft Azure Synapse Analytics's pricing could be reduced."
"The support and price could improve."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
IBM Db2 Warehouse on Cloud is ranked 15th in Cloud Data Warehouse while Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 86 reviews. IBM Db2 Warehouse on Cloud is rated 7.6, while Microsoft Azure Synapse Analytics is rated 7.8. The top reviewer of IBM Db2 Warehouse on Cloud writes "The "prefetch" feature anticipates needed data and keeps it available. BLU acceleration determines what data is unqualified for analysis and skips it". On the other hand, the top reviewer of Microsoft Azure Synapse Analytics writes "No competitors provide the entire solution to one place ". IBM Db2 Warehouse on Cloud is most compared with IBM Db2 Warehouse, Amazon Redshift, IBM Netezza Performance Server and Snowflake, whereas Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, SAP BW4HANA, Snowflake, Oracle Autonomous Data Warehouse and Teradata. See our IBM Db2 Warehouse on Cloud vs. Microsoft Azure Synapse Analytics 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.