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."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 is the scalability, as it grows according to our needs."
"Amazon Redshift is very fast. It has really good response times. It's very user-friendly."
"It's very easy to migrate from other databases to Redshift. There are migration tools dedicated for this purpose, enabling migration from other databases like MS SQL directly to Redshift. The majority of the scripts will be automatically transposed."
"The most valuable features are that it's easy to set up and easy to connect the many tools that connect to it."
"Redshift's versioning and data security are the two most critical features. When migrating into the cloud, it's vital to secure the data. The encryption and security are there."
"Amazon Redshift offers a relatively flexible structure...I rate the technical support a nine out of ten."
"I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing."
"The most valuable feature of the solution is the ability to combine all the data without the need for additional devices."
"Oracle has good technical support."
"The product is very light."
"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."
"Oracle Database Appliance provides high stability."
"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."
"Easy management (it saves a lot of installation and patching time)."
"The solution is pretty automated, which takes out the possibility of human error."
"When working with third-party services requires additional integrations and configurations, which can sometimes add more cost."
"The solution has four maintenance windows so, when it comes to stability, I think it would be better to decrease their number."
"I would like to improve the pricing and the simplicity of using this solution."
"They should provide a better way to work with interim data in a structured way than to store it in parquet files locally."
"In our experiments, the handling of unstructured data was not very smooth."
"There are too many limitations with respect to concurrency."
"The technical support should be better in terms of their knowledge, and they should be more customer-friendly."
"Should be made available across zones, like other Multi-AZ solutions."
"They could incorporate a more secure and internet-centric management system for the platform."
"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."
"I would rate the scalability a seven out of ten. It has some problems. Databases are huge. This leads to needing more and more RAM and capacity resources, making it hard to scale. Because of this, we use Exadata. That's definitely a point for improvement."
"The license cost could be cheaper, especially for long-term contracts."
"Sometimes, we cannot upgrade or patch it easily. The performance needs to improve."
"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."
"We would like the ability to add more storage without having to upgrade to Oracle Exadata."
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, Vertica, Snowflake, Microsoft Azure Synapse Analytics and AWS Lake Formation, 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.