We performed a comparison between Amazon Redshift and IBM Db2 Warehouse on Cloud 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 stability of Amazon Redshift is good."
"Redshift's versioning and data security are the two most critical features. When migrating into the cloud, it's vital to secure the data. The encryption and security are there."
"The main benefit is that our portal for end users is running in AWS, so we can easily connect it to other AWS services."
"It is very easy to dump data into the tool."
"The feature that we find most useful is the ability to do analytics on the fly."
"I find the most valuable features to be the MPP style of processing, which mostly all of the data warehouses provide. The ability to integrate all other AWS services, such as NSS and S3, with little effort is very helpful. The service is well maintained, there are update patches frequently."
"I like it because the usage is very similar to Microsoft SQL server. The structure of the query and the temporary tables are very similar."
"Redshift COPY command, because much of my work involved helping customers migrate large amounts of data into Redshift."
"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."
"It takes a lot of time to ingest and update the data."
"In our experiments, the handling of unstructured data was not very smooth."
"It would be good to see Redshift as a serverless offering."
"Infinite storage is available in Snowflake and is not available in Redshift."
"Redshift's GUI could be more user-friendly. It's easier to perform queries and all that stuff in Azure Synapse Analytics."
"Amazon Redshift is a little more expensive than other products."
"The solution could improve in handling more data formats and more native support for RDF."
"In terms of improvement, I believe Amazon Redshift could work on reducing its costs, as they tend to increase significantly. Additionally, there are occasional issues with nodes going down, which can be problematic."
"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."
"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."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 61 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 Teradata, Snowflake, AWS Lake Formation, Vertica and Microsoft Azure Synapse Analytics, whereas IBM Db2 Warehouse on Cloud is most compared with IBM Db2 Warehouse, IBM Netezza Performance Server, Microsoft Azure Synapse Analytics and Snowflake. See our Amazon Redshift vs. IBM Db2 Warehouse on Cloud 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.