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."
"It will be MPP, so performance should improve."
"The performance is okay as long as the volume of queries is not too high."
"Synapse Analytics' best feature is its ability to process large files."
"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 stability is pretty good."
"They are very reliable and cost-effective."
"Its seamless integration with Azure services is most valuable. If somebody wants to use all Azure services, it is the best solution."
"Data can be stored any way you want in the data warehouse."
"The solution has been working well overall."
"The features we've found most valuable for data warehouses is extracting data, SSIS packages, and the DBs."
"Ultimately, the product itself has challenges and we are not currently satisfied with the support, either."
"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."
"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."
"The only issue that we have run into with the solutions performance is with regards to concurrency."
"The product could be more feature-rich."
"The linked services can be improved. We can create dynamic linked services to access a lot of databases but only those of the same type. For example, I can use the same linked services to access 11 SQL databases. However, if I have 11 SQL databases and five Oracle databases, I need two dynamic linked services. I cannot do it with only one linked service. The UI also needs to be improved. When I have used Azure Synapse for programming with PySpark, Scala, or .NET, for example, the UI has been unstable. If I open two notebooks for programming, one notebook will queue the session of the other."
"The need to improve a little bit in terms of user-friendliness."
"Real-time integration is hard to do in Microsoft Azure Synapse Analytics."
"I would like my team to be able to build pipelines that integrate with the Azure Data Factory."
"One area for improvement could be better integration with Power BI, as well as data integration with BW."
"From an infrastructure standpoint, I believe it can be more secure in terms of availability."
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.