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."It allows you write complex queries and perform row by row processes."
"The most valuable feature is the scalability, as it grows according to our needs."
"The product is relatively easy to use because there is no indexing and no partitions."
"Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."
"Amazon Redshift is very fast. It has really good response times. It's very user-friendly."
"It is quite simple to use and there are no issues with creating the tables."
"The stability of Amazon Redshift is good."
"The most valuable feature of Amazon Redshift is its ability to handle really large sets of data."
"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."
"The performance is okay as long as the volume of queries is not too high."
"We are using third-party tools to integrate Amazon Redshift, they should create their own interface on their own for it to be easily connected on the AWS itself."
"Migrating data from other data sources can be challenging when you are working with multibyte character sets."
"There is some missing functionality and sometimes it's so difficult to work in. We need to convert these functionalities using VACUUM inside Amazon Redshift and then it causes some complexity."
"Query compilation time needs a lot of improvement for cases where you are generating queries dynamically."
"The solution is unable to work fast."
"This solution lacks integration with non-AWS sources."
"In the solution, user-based access is quite hard. In general, certain permissions are difficult to manage."
"In the next release, a pivot function would be a big help. It could save a lot of time creating a query or process to handle operations."
"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."
"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."
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, Vertica, Snowflake, Microsoft Azure Synapse Analytics and AWS Lake Formation, whereas IBM Db2 Warehouse on Cloud is most compared with IBM Db2 Warehouse, IBM Netezza Performance Server 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.