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."This service can merge and integrate well with all databases."
"I have primarily used the Redshift Spectrum feature and found it most valuable."
"It allows for the storage of huge amounts of data."
"It is very easy to dump data into the tool."
"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 is a major service of Amazon and is very scalable. It enables faster recalculations and data management, helping to retrieve data quickly."
"Though Amazon Redshift is good, it depends on what kind of business you're trying to do, what type of analytics you need, and how much data you have."
"The most valuable feature of Redshift is its cluster."
"We primarily use it for OLTP, which has improved our costs."
"Oracle Database Appliances are specifically designed for Oracle databases. They have built-in utilities and tools that simplify management, making them the best option for Oracle database management systems."
"If the database goes down on one of the servers, the load is automatically shifted to another server. You can troubleshoot the one that is down without affecting uptime."
"We value the appliance architecture with its “everything-in-a-box” highly standardized setup."
"The initial setup was straightforward and quick - I was able to configure everything within an hour."
"The product is good value for money. It is a secure solution."
"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."
"The most valuable feature of the solution is the ability to combine all the data without the need for additional devices."
"They should provide a better way to work with interim data in a structured way than to store it in parquet files locally."
"For people who struggle with IAM or role-based management, the setup isn't easy."
"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."
"If you require a highly scalable solution, I would not recommend Amazon Redshift."
"The product could be improved by making it more flexible."
"The initial setup is a complex process, especially for someone who is not familiar with nodes and configuring terms like RPUs."
"The solution could improve in handling more data formats and more native support for RDF."
"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."
"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."
"Technical support is not so great. It could be much better. The maintenance, for an enterprise system, isn't so great. It's also extremely expensive."
"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."
"Since we don't have the room to scale up, I rate this solution a six out of ten for scalability."
"The product's technical support services need improvement."
"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."
"It would be beneficial to have dedicated RAM included in the Oracle Database Appliance."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 61 reviews while Oracle Database Appliance is ranked 7th 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 Teradata, Snowflake, AWS Lake Formation, Vertica and Microsoft Azure Synapse Analytics, whereas Oracle Database Appliance is most compared with Oracle Exadata, VMware Tanzu Data Services, 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.