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 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."
"It will be MPP, so performance should improve."
"Azure Synapse combines the strengths of SQL technologies for effective enterprise data management."
"The solution offers strong scalability opportunities."
"One of the most valuable features of this solution is its ability to integrate well with other services offered by Azure."
"The most valuable features are the flexibility and that it's easy to use as an end-user compared to AWS."
"The most valuable feature of Microsoft Azure Synapse Analytics is the pipeline that is the ETL tool. It's very well designed and is overall very good. We usually don't use the ETL tool in Databricks, but we use the ETL tool in this solution."
"The solution handles single or complex items within a second."
"It's quite quick for querying, even with large datasets, and it's scalable. It's also flexible to use, so it's easy to update and get data quickly without wasting time."
"Synapse Analytics gives you information and reports in real-time."
"Containers get corrupted very easily. Restoring them using GPFS can result in a lot of issues."
"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."
"Ultimately, the product itself has challenges and we are not currently satisfied with the support, either."
"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."
"If I'm looking for something good in the cloud, I would want it to have better standard connectors."
"The initial setup has a bit of a learning curve."
"One area that could be improved is the schema management."
"Microsoft should develop an interface to make it easier to shift from on-premise to the cloud."
"We encountered data processing and transformation issues while working with Apache Spark languages for the product."
"Real-time integration is hard to do in Microsoft Azure Synapse Analytics."
"More integration is needed to improve the product for the future."
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.