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."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 found the Amazon Redshift computing services easy. I found the computing instances the most incredible in the solution."
"The solution's flexibility is its most valuable feature. It's also easy to scale and has relatively painless pricing."
"You can copy JSON to the column and have it analyzed using simple functions."
"Amazon Redshift offers a relatively flexible structure...I rate the technical support a nine out of ten."
"The most valuable feature of Redshift is its cluster."
"Redshift Spectrum is the most valuable feature."
"Redshift's Excel features are handy. Redshift spectrum allows you to directly query the data on an Excel sheet. Now, SQL Server also allows this, but Redshift has many more features."
"I give it a nine out of 10 because it gives the customer easy access to a complete database solution within 30 minutes."
"The product is excellent. It is simple and reliable in terms of installation and maintenance."
"Easy management (it saves a lot of installation and patching time)."
"The most valuable feature of Oracle Database Appliance is the ease of management."
"Oracle has good technical support."
"Oracle Database Appliance is a stable solution. We have clients that have been running it for 10 years."
"Oracle is a stable database."
"We use the solution for our Java applications."
"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."
"I would like to improve the pricing and the simplicity of using this solution."
"Planting is the primary key enforcement that should be improved."
"The solution could improve in handling more data formats and more native support for RDF."
"Running parallel queries results in poor performance and this needs to be improved."
"Redshift's GUI could be more user-friendly. It's easier to perform queries and all that stuff in Azure Synapse Analytics."
"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."
"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."
"Oracle Database Appliance is stopping support for the standard edition and only continuing support for the RAC One Node. They did not inform us and we are having problems with our customers. We are not having to change our systems from standard to something else."
"Sometimes, we cannot upgrade or patch it easily. The performance needs to improve."
"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."
"The setup is a bit complex."
"Oracle's product support is an area of concern where improvements are required."
"In my opinion only one single command should be used for all ODA models, as it’s confusing."
"Oracle Database Appliance patching comes out two to three months after the regular patching cycle."
"It would be beneficial to have dedicated RAM included in the Oracle Database Appliance."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 58 reviews while Oracle Database Appliance is ranked 6th in Data Warehouse with 39 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 "Stable solution with opportunities for performance enhancement". Amazon Redshift is most compared with AWS Lake Formation, Snowflake, Vertica, Teradata and Microsoft Azure Synapse Analytics, whereas Oracle Database Appliance is most compared with Oracle Exadata, VMware Tanzu Greenplum, Dremio, Actian Ingres and Microsoft Azure Synapse Analytics. 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.