We performed a comparison between Amazon Redshift and Oracle Database Appliance 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 stability of Amazon Redshift is good."
"The most valuable feature of Amazon Redshift is its ability to handle really large sets of data."
"The most valuable feature is that the solution is fully embedded in the AWS stack."
"The most valuable features are that it's easy to set up and easy to connect the many tools that connect to it."
"The processing of data is very fast."
"The main benefit is that our portal for end users is running in AWS, so we can easily connect it to other AWS services."
"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."
"The performance due to the all-flash of ODA is very nice."
"Oracle Database Appliance provides high stability."
"Oracle Database Appliance is a stable solution. We have clients that have been running it for 10 years."
"The most valuable feature is the performance."
"The solution is stable. The product is scalable. The technical support is very helpful. The initial setup is straightforward. I consider the product a strong solution for our customers."
"We value the appliance architecture with its “everything-in-a-box” highly standardized setup."
"The solution is simple to use and easy to maintain."
"The solution is pretty automated, which takes out the possibility of human error."
"The product could be improved by making it more flexible."
"This solution lacks integration with non-AWS sources."
"Infinite storage is available in Snowflake and is not available in Redshift."
"Migrating data from other data sources can be challenging when you are working with multibyte character sets."
"AWS Snowflake has a very good feature for cloning databases. It makes it easy to clone a data warehouse, which is useful. I would like to see this feature in Redshift."
"For people who struggle with IAM or role-based management, the setup isn't easy."
"The technical support should be better in terms of their knowledge, and they should be more customer-friendly."
"It takes a lot of time to ingest and update the data."
"The feature that I would like to see improve is the interface. It is really not good. I almost have to work on script by script in it. There is always some issue with the user interface."
"The product's pricing is too high. We plan to migrate to another database in three to four years."
"Oracle Database Appliance could improve by having better integration."
"In terms of what can be be improved, I'd say Artificial Intelligence, AI. It would be really helpful if AI was incorporated within the solution."
"Virtualization needs improvement. It's not easy to back up the virtual machines in the Oracle VM architecture. I would also like to see native support for Veeam Backup Software."
"Virtualization features could also be improved. A web-based GUI would be a good start."
"Even though the solution can handle a lot of data, it's just too expensive currently."
"Oracle's product support is an area of concern where improvements are required."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 60 reviews while Oracle Database Appliance is ranked 6th in Data Warehouse with 40 reviews. Amazon Redshift is rated 7.8, while Oracle Database Appliance is rated 8.0. 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 Oracle Database Appliance writes "Simplifies database management tasks and provides high availability and disaster recovery". Amazon Redshift is most compared with Snowflake, Teradata, AWS Lake Formation, Vertica and Microsoft Azure Synapse Analytics, whereas Oracle Database Appliance is most compared with Oracle Exadata, VMware Tanzu Greenplum, Dremio, Actian Ingres and Vertica. See our Amazon Redshift vs. Oracle Database Appliance report.
See our list of best Cloud Data Warehouse vendors and best 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.