We performed a comparison between Amazon Redshift and Oracle Big Data Appliance based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."The most valuable features of Amazon Redshift are that its fast and efficient. We have lots of TBs of data and it's very fast."
"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."
"We have found Machine Learning use cases are very nice."
"I found the Amazon Redshift computing services easy. I found the computing instances the most incredible in the solution."
"Setup is easy. It's a fast solution with machine learning features, good integration, and a good API."
"Amazon Redshift is very fast. It has really good response times. It's very user-friendly."
"Redshift has an advantage when it comes to administration, making it easier to manage and collaborate."
"Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."
"The best thing about the product is that the end-user can build the reports by themselves without really knowing anything about databases."
"Because Big Data Appliance allows me to have a single source of truth, it means I have clean data that can be monetized and leveraged to gain more insights with real-time reports from the dashboard."
"This is a comprehensive solution that is easy to deploy."
"In the solution, user-based access is quite hard. In general, certain permissions are difficult to manage."
"Amazon should provide more cloud-native tools that can integrate with Redshift like Microsoft's development tools for Azure."
"The product could be improved by making it more flexible."
"Should be made available across zones, like other Multi-AZ solutions."
"We recently moved from the DC2 cluster to the RA3 cluster, which is a different node type and we are finding some issues with the RA3 cluster regarding connection and processing. There is room for improvement in this area. We are in talks with AWS regarding the connection issues."
"They should provide a better way to work with interim data in a structured way than to store it in parquet files locally."
"The solution is unable to work fast."
"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."
"It seems like the deployment of repositories has become more difficult in later versions of the product rather than easier."
"From a technical perspective, Big Data Appliance could be improved with more innovation in the AI and machine-learning parts instead of relying on Cloudera."
"The product should be simplified for the average user."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 58 reviews while Oracle Big Data Appliance is ranked 12th in Data Warehouse with 5 reviews. Amazon Redshift is rated 7.8, while Oracle Big Data 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 Big Data Appliance writes "Fast, and you don't need technical expertise to use it and produce results". Amazon Redshift is most compared with AWS Lake Formation, Snowflake, Teradata, Vertica and Microsoft Azure Synapse Analytics, whereas Oracle Big Data Appliance is most compared with Oracle Exadata, Apache Hadoop, Teradata and Microsoft Azure Synapse Analytics.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all 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.