We performed a comparison between Oracle Database and SAP IQ based on real PeerSpot user reviews.
Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."I have experienced good performance from the solution."
"The feature that I worked with and that excited me the most is one that is not available in other databases, and it involves the use of Java Runtime."
"I have been satisfied with the technical support from Oracle."
"The most valuable feature is that it is a complete product with all of the functionality that you need, and there is no need for any special features."
"Using the product, we make less mistakes, are more organized and faster than if we did it any another way."
"There is a lot of information available on the internet, so problems can easily be fixed."
"It's powerful and fast, and the backup system is wonderful."
"It is a stable product. In terms of recovery, if there is a failure or some kind of fault, we can recover the data. We do not lose it."
"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."
"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."
"It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."
"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."
"Oracle Database could be improved by adding more automation."
"Integration with big data would be helpful since we are planning to load a lot of big data."
"Oracle Database's migration capabilities could be improved because it's very difficult. So even if you migrate where you host your data, be it on Windows SQL Server, there is a problem because migrating the package is highly complex. The technical support could also be faster."
"The monitoring system is not very user friendly and could include a graphic interface."
"We believe that the usability could be improved, especially within the data lakehouse. We found content management to be a little bit more simpler within the GUI part."
"Oracle support is helpful, and they resolve all our issues, but sometimes the response to our clients isn't as prompt as we'd like."
"The licensing formulation is too complicated."
"The integration can be made much easier for the Oracle tools, for example, Oracle Database or OPI. The integration sometimes can be a little complicated for us because we have to do a number of integrations with other tools, such as Oracle computation. The integration could be more streamlined and easier to work with."
"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."
"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."
Oracle Database is ranked 2nd in Relational Databases Tools with 19 reviews while SAP IQ is ranked 21st in Relational Databases Tools with 2 reviews. Oracle Database is rated 8.6, while SAP IQ is rated 8.0. The top reviewer of Oracle Database writes "Good database with decent performance". On the other hand, the top reviewer of SAP IQ writes "Easy to use, highly stable, but integration could improve". Oracle Database is most compared with SAP HANA, SQL Server, MariaDB, IBM Db2 Database and Amazon Aurora, whereas SAP IQ is most compared with Snowflake, SQL Server, SAP HANA, Apache Hadoop and SAP BW4HANA. See our Oracle Database vs. SAP IQ report.
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.