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."Setup is easy. It's a fast solution with machine learning features, good integration, and a good API."
"For the on-premises version of Amazon Redshift, we need to start from scratch. However, with the cloud version whenever you want to deploy, you can scale up, and down, and it has a data warehousing capability. Redshift has many features."
"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 have primarily used the Redshift Spectrum feature and found it most valuable."
"It's scalable because it's on the cloud."
"Redshift allows you to transform different data formats and consolidate them into one Redshift cluster. This means you can transform various siloed data sources like Excel files and CSV files into Redshift."
"The most valuable feature is its scalability."
"It allows you write complex queries and perform row by row processes."
"The product is good value for money. It is a secure solution."
"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."
"The product’s valuable feature is its capability to pre-configure and pre-install the settings."
"The performance of the system is the solution's most valuable aspect. In combination with the database, it gives perfect results. It's a better system than using other kinds of integrated systems. In general, the ODA control is much simpler to use and offers up the best performance."
"We value the appliance architecture with its “everything-in-a-box” highly standardized setup."
"The most valuable feature is the performance."
"The Oracle database is able to get the data, process it, and return it to the company's CEO's and CFO's within a single day, and thus they are able to find out yesterday's P and L by today. It has drastically reduced the amount and time of processing from seven days to one day."
"The database is solid."
"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."
"There are physically too many pipelines for a company of this size to maintain. For a data scientist, it's very difficult to learn the data in all of these different environments."
"Compatibility with other products, for example, Microsoft and Google, is a bit difficult because each one of them wants to be isolated with their solutions."
"It would be useful to have an option where all of the data can be queried at once and then have the result shown."
"Amazon Redshift does not have the capability to dynamically increase the VM file."
"Amazon Redshift could improve the user interface support."
"Improvement could be made in the area of streaming data."
"This solution lacks integration with non-AWS sources."
"The product is quite complex to set up, initially. It would be ideal if it was simpler."
"Virtualization features could also be improved. A web-based GUI would be a good start."
"I would be happy to see the Oracle Auto Service Request (ASR) pre-installed in it instead of installing it in a separate machine."
"Oracle Database Appliance could improve by having better integration."
"I would like it if the scalability could be increased without having to change versions."
"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."
"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 main thing would be to make ODA more affordable, to make it a more economical machine. Also, I would like to see virtualization, so you could implement all of your functions on one machine. Finally, improvement in the speed and performance would be good."
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 "Simplifies database management tasks and provides high availability and disaster recovery". Amazon Redshift is most compared with AWS Lake Formation, Snowflake, Teradata, Vertica 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.