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 Web Services (AWS) and others in Cloud Data Warehouse."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."
"I have been working with Microsoft, and they have been very helpful."
"I like the keynotes and their simplicity. Like other Microsoft products, Microsoft Azure Synapse Analytics is simple to understand and use."
"It's feature-rich. It has a wide range of features."
"Very interactive and provides flexibility."
"The most valuable feature is the incremental load because we do not need to refresh the entire data on a daily basis."
"The stability is pretty good."
"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."
"Its seamless integration with Azure services is most valuable. If somebody wants to use all Azure services, it is the best solution."
"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."
"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."
"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."
"In the future, Microsoft Azure Synapse Analytics could improve the performance, there are other solutions that are better, such as Databricks."
"We'd like the solution to have more analytics capability."
"It could be beneficial to focus on integration with various data sources and similar enhancements."
"The security performance and cost are the two things that needs improvement."
"It could be more stable."
"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."
"When I was trying to link services to an SFTP site it was not able to do all the possible encryption that I needed. They can improve by adding more encryption options."
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 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 Amazon Redshift, IBM Netezza Performance Server, IBM Db2 Warehouse 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 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.