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 initial setup of this solution is straightforward."
"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 tool's most valuable feature is its parallel processing capability. It can handle massive amounts of data, even when pushing hundreds of terabytes, and its scaling capabilities are good."
"You can copy JSON to the column and have it analyzed using simple functions."
"The most valuable features of Amazon Redshift are that its fast and efficient. We have lots of TBs of data and it's very fast."
"The most valuable feature is that the solution is fully embedded in the AWS stack."
"The solution's flexibility is its most valuable feature. It's also easy to scale and has relatively painless pricing."
"Easy to build out our snowflake design and load data."
"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."
"They should provide a better way to work with interim data in a structured way than to store it in parquet files locally."
"Amazon should provide more cloud-native tools that can integrate with Redshift like Microsoft's development tools for Azure."
"It takes a lot of time to ingest and update the data."
"This solution lacks integration with non-AWS sources."
"It would be nice if we could turn off an instance. However, it would retain the instance in history, thus allowing us to restart without beginning from scratch."
"Should be made available across zones, like other Multi-AZ solutions."
"Improvement could be made in the area of streaming data."
"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."
"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."
"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 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, Vertica, Teradata 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 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.