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."The features that I have found most valuable are its cloud and API features."
"You can scale the solution if you need to. Its scalability is good."
"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."
"The solution is scalable."
"I have found the most valuable feature to be the performance. We have a large database in my company and there is not likely a solution that has the performance we need."
"The solution is stable."
"I've never faced any stability issues with the product. I don't recall any bugs, glitches, or crashes. I'd say it's fairly stable and shouldn't cause anyone issues in that regard."
"We use the relational databases for government contracts."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"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."
"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."
"Unbeatable speed and compression with a colummn-structured relational database."
"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"I have been looking for a virtualization database engine from Oracle. They have third-party vendors that can do it but if Oracle comes with its own virtual engine, it would be helpful. Additionally, the solution could be more user-friendly and improve the Transparent Data Encryption."
"Cost is always a concern."
"Upgrade is the most critical phase for the lifecycle of a database. In order to be sure that the migration succeeds, you need to be up-to-date. Therefore, regularly install the patchset and security updates."
"Frankly speaking, Oracle Database is very expensive."
"The cost of this solution needs to be improved."
"We faced some difficulties in the network configuration area. All these things can be fixed with the support of Oracle's networking team. We didn't face any other major problems. Its deployment can be easier. It should be easier to configure for a developer. If a developer is planning a database and trying to configure it, it should be easy for him because many times, we cannot directly get help from DBAs."
"We don't really find that any features are lacking."
"The documentation needs improvement because as it is now, providing support is a headache."
"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."
"Concurrency and functional error messaging."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."
Oracle Database is ranked 2nd in Relational Databases Tools with 274 reviews while SAP IQ is ranked 21st in Relational Databases Tools with 17 reviews. Oracle Database is rated 8.6, while SAP IQ is rated 8.0. The top reviewer of Oracle Database writes "Offers security features that are good, reliable, and stable". 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.