We performed a comparison between Amazon Redshift and IBM Db2 Warehouse on Cloud 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 most valuable feature of Redshift is its cluster."
"I have primarily used the Redshift Spectrum feature and found it most valuable."
"Redshift COPY command, because much of my work involved helping customers migrate large amounts of data into Redshift."
"Setup is easy. It's a fast solution with machine learning features, good integration, and a good API."
"It is quite simple to use and there are no issues with creating the tables."
"I found the Amazon Redshift computing services easy. I found the computing instances the most incredible in the solution."
"The main benefit is that our portal for end users is running in AWS, so we can easily connect it to other AWS services."
"Amazon Redshift is very fast. It has really good response times. It's very user-friendly."
"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."
"Amazon Redshift could improve the user interface support."
"The solution is unable to work fast."
"It takes a lot of time to ingest and update the data."
"Query compilation time needs a lot of improvement for cases where you are generating queries dynamically."
"The speed of the solution and its portability needs improvement."
"The solution has four maintenance windows so, when it comes to stability, I think it would be better to decrease their number."
"The solution could improve in handling more data formats and more native support for RDF."
"In our experiments, the handling of unstructured data was not very smooth."
"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."
"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."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 58 reviews while IBM Db2 Warehouse on Cloud is ranked 15th in Cloud Data Warehouse. Amazon Redshift is rated 7.8, while IBM Db2 Warehouse on Cloud is rated 7.6. The top reviewer of Amazon Redshift writes "Provides one place where we can store data, and allows us to easily connect to other services with AWS". On the other hand, 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". Amazon Redshift is most compared with AWS Lake Formation, Snowflake, Teradata, Vertica and Microsoft Azure Synapse Analytics, whereas IBM Db2 Warehouse on Cloud is most compared with IBM Netezza Performance Server, IBM Db2 Warehouse, Microsoft Azure Synapse Analytics and Snowflake.
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.