We performed a comparison between IBM Db2 Warehouse on Cloud and Microsoft Azure Synapse Analytics based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon and others in Cloud Data Warehouse."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 performance is okay as long as the volume of queries is not too high."
"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 pricing seems to be quite fair."
"I like the keynotes and their simplicity. Like other Microsoft products, Microsoft Azure Synapse Analytics is simple to understand and use."
"The most valuable features of Microsoft Azure Synapse Analytics are how easy and quick it is to set up the linked services."
"The architecture, including compute and storage, is good."
"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."
"The most valuable features are the flexibility and that it's easy to use as an end-user compared to AWS."
"Overall deployment and integration is pretty fast."
"Containers get corrupted very easily. Restoring them using GPFS can result in a lot of issues."
"Ultimately, the product itself has challenges and we are not currently satisfied with the support, either."
"Tech support for dashDB is awful. We usually have tickets open for three to four weeks."
"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."
"They should automate some of the features. There are some things, such as the creation of external tables, that you have to do manually. They should be automated."
"In the future, Microsoft Azure Synapse Analytics could improve the performance, there are other solutions that are better, such as Databricks."
"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."
"We'd like the solution to have more analytics capability."
"The need to improve a little bit in terms of user-friendliness."
"The initial setup is complex."
"One area for improvement could be better integration with Power BI, as well as data integration with BW."
"This is a young product in transition to the cloud and it needs more work before it is both settled as a product and competitive in the market."
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 85 reviews. IBM Db2 Warehouse on Cloud is rated 7.6, while Microsoft Azure Synapse Analytics is rated 8.0. 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, Snowflake and Oracle Exadata, whereas Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, Snowflake, SAP BW4HANA, Amazon Redshift and Teradata.
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.