We performed a comparison between Amazon Redshift and Oracle Big Data Appliance based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Amazon Redshift is very fast. It has really good response times. It's very user-friendly."
"The most valuable feature is the scalability, as it grows according to our needs."
"Redshift is a major service of Amazon and is very scalable. It enables faster recalculations and data management, helping to retrieve data quickly."
"If the analyst knows SQL, which is comfortable and easy to use to go between all of these tool stacks, I think it's reliable. It's a secure and reliable data warehouse."
"The valuable features are performance, data compression, and scalability."
"Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."
"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."
"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."
"This is a comprehensive solution that is easy to deploy."
"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."
"The best thing about the product is that the end-user can build the reports by themselves without really knowing anything about databases."
"AWS Snowflake has a very good feature for cloning databases. It makes it easy to clone a data warehouse, which is useful. I would like to see this feature in Redshift."
"The explain panel in the Redshift database could be better."
"It takes a lot of time to ingest and update the data."
"Infinite storage is available in Snowflake and is not available in Redshift."
"The product could be improved by making it more flexible."
"Amazon Redshift is a little more expensive than other products."
"Amazon Redshift does not have the capability to dynamically increase the VM file."
"The solution has four maintenance windows so, when it comes to stability, I think it would be better to decrease their number."
"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 59 reviews while Oracle Big Data Appliance is ranked 14th 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 Snowflake, Teradata, AWS Lake Formation, Vertica and Microsoft Azure Synapse Analytics, whereas Oracle Big Data Appliance is most compared with Oracle Exadata, Apache Hadoop, Microsoft Azure Synapse Analytics and Teradata. See our Amazon Redshift vs. Oracle Big Data Appliance report.
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.