We performed a comparison between Oracle Java DB and SAP IQ based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."The solution is stable."
"The most valuable feature is automation."
"The additional value of having Java inside the Oracle database is all the security that is applied to an Oracle database will be enforced on Java's stored procedures as well."
"Able to write queries more efficiently and the management of data has become better and easier."
"There have been no issues in relation to stability. We've never really had do to any recoveries. It is very stable."
"It's very clever."
"It has a programming language so anything that we require for Selenium is all available there."
"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."
"Unbeatable speed and compression with a colummn-structured relational database."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"Columnar storage allows high compression, high load rates and high query performance."
"It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."
"The solution could be more user-friendly."
"The solution should continue to keep updating and improving the Java language."
"Needs improvement in consistency issues with respect to timeframes."
"In terms of improvement, I'd like an automation tool that is lower priced. The core prices are very high."
"It'll be better if Oracle Java supports open source technologies, like Node.js."
"The biggest lesson that I have learned from using Oracle products is vendor lock-in."
"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 organization who owns the product does not support it well and appears not to be doing significant development for the future."
"I think the universe should be part of the Sybase IQ tool set."
"Concurrency and functional error messaging."
"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
Oracle Java DB is ranked 23rd in Relational Databases Tools with 7 reviews while SAP IQ is ranked 21st in Relational Databases Tools with 17 reviews. Oracle Java DB is rated 8.2, while SAP IQ is rated 8.0. The top reviewer of Oracle Java DB writes "Ability to handle large volumes and data sets but could be more user-friendly". On the other hand, the top reviewer of SAP IQ writes "Easy to use, highly stable, but integration could improve". Oracle Java DB is most compared with MySQL, SQL Server, Oracle Database, Apache Derby and SAP HANA, whereas SAP IQ is most compared with Snowflake, SAP HANA, SQL Server, SAP BW4HANA and Apache Hadoop.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools 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.