We performed a comparison between Apache Hadoop and Oracle Database 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."One valuable feature is that we can download data."
"The ability to add multiple nodes without any restriction is the solution's most valuable aspect."
"Its integration is Hadoop's best feature because that allows us to support different tools in a big data platform."
"What comes with the standard setup is what we mostly use, but Ambari is the most important."
"High throughput and low latency. We start with data mashing on Hive and finally use this for KPI visualization."
"Hadoop is extensible — it's elastic."
"The most valuable features are powerful tools for ingestion, as data is in multiple systems."
"Since both Apache Hadoop and Amazon EC2 are elastic in nature, we can scale and expand on demand for a specific PoC, and scale down when it's done."
"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."
"Oracle has good technical support."
"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 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."
"Easy management (it saves a lot of installation and patching time)."
"The main feature is the management and manageability of the tool. We can create a VM on a laptop within a couple of clicks."
"I give it a nine out of 10 because it gives the customer easy access to a complete database solution within 30 minutes."
"In the next release, I would like to see Hive more responsive for smaller queries and to reduce the latency."
"It could be more user-friendly."
"The upgrade path should be improved because it is not as easy as it should be."
"General installation/dependency issues were there, but were not a major, complex issue. While migrating data from MySQL to Hive, things are a little challenging, but we were able to get through that with support from forums and a little trial and error."
"We would like to have more dynamics in merging this machine data with other internal data to make more meaning out of it."
"Hadoop's security could be better."
"I think more of the solution needs to be focused around the panel processing and retrieval of data."
"From the Apache perspective or the open-source community, they need to add more capabilities to make life easier from a configuration and deployment perspective."
"Oracle Database Appliance patching comes out two to three months after the regular patching cycle."
"Oracle Database Appliance could improve by having better integration."
"I would like it if the scalability could be increased without having to change versions."
"Oracle Database Appliance is stopping support for the standard edition and only continuing support for the RAC One Node. They did not inform us and we are having problems with our customers. We are not having to change our systems from standard to something else."
"The product is quite complex to set up, initially. It would be ideal if it was simpler."
"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."
"Oracle's product support is an area of concern where improvements are required."
"Since we don't have the room to scale up, I rate this solution a six out of ten for scalability."
Apache Hadoop is ranked 5th in Data Warehouse with 32 reviews while Oracle Database Appliance is ranked 6th in Data Warehouse with 39 reviews. Apache Hadoop is rated 7.8, while Oracle Database Appliance is rated 8.0. The top reviewer of Apache Hadoop writes "A file system for data collection that contains needed information and files". On the other hand, the top reviewer of Oracle Database Appliance writes "Simplifies database management tasks and provides high availability and disaster recovery". Apache Hadoop is most compared with Azure Data Factory, Microsoft Azure Synapse Analytics, Oracle Exadata, Snowflake and Teradata, whereas Oracle Database Appliance is most compared with Oracle Exadata, VMware Tanzu Greenplum, Dremio, Actian Ingres and Amazon Redshift. See our Apache Hadoop vs. Oracle Database Appliance report.
See our list of best 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.