We performed a comparison between Oracle Database Appliance and SAP IQ 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."The database is solid."
"Oracle Database Appliance provides high stability."
"The most valuable feature of Oracle Database Appliance is the ease of management."
"The solution is stable. The product is scalable. The technical support is very helpful. The initial setup is straightforward. I consider the product a strong solution for our customers."
"The most valuable feature of the solution is the ability to combine all the data without the need for additional devices."
"We use the solution for our Java applications."
"Oracle is a stable database."
"The initial setup was straightforward and quick - I was able to configure everything within an hour."
"It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."
"Unbeatable speed and compression with a colummn-structured relational database."
"Columnar storage allows high compression, high load rates and high query performance."
"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"The primary benefit of SAP IQ is its ability to limit the expansion of the costly SAP HANA database, which has limited storage capacity. This necessitates a form of data management that involves moving data from SAP HANA to SAP NLS, which is essentially archiving. This allows us to retain access to the data via a link whenever it is required."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"The tool's setup can be easier."
"The product's pricing is too high. We plan to migrate to another database in three to four years."
"It would be beneficial to have dedicated RAM included in the Oracle Database Appliance."
"We would like the ability to add more storage without having to upgrade to Oracle Exadata."
"They could incorporate a more secure and internet-centric management system for the platform."
"In my opinion only one single command should be used for all ODA models, as it’s confusing."
"The feature that I would like to see improve is the interface. It is really not good. I almost have to work on script by script in it. There is always some issue with the user interface."
"Oracle's product support is an area of concern where improvements are required."
"Concurrency and functional error messaging."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"I think the universe should be part of the Sybase IQ tool set."
"Multiplex is very problematic. There are consistency problems in the metadata, meaning it is possible to lose metadata consistency. You should make sure you have healthy backups."
"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
Oracle Database Appliance is ranked 6th in Data Warehouse with 40 reviews while SAP IQ is ranked 16th in Data Warehouse with 17 reviews. Oracle Database Appliance is rated 8.0, while SAP IQ is rated 8.0. The top reviewer of Oracle Database Appliance writes "Simplifies database management tasks and provides high availability and disaster recovery". On the other hand, the top reviewer of SAP IQ writes "Easy to use, highly stable, but integration could improve". Oracle Database Appliance is most compared with Oracle Exadata, VMware Tanzu Greenplum, Dremio, Actian Ingres and Vertica, whereas SAP IQ is most compared with Snowflake, SAP HANA, SAP BW4HANA, SQL Server and Apache Hadoop. See our Oracle Database Appliance vs. SAP IQ 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.