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."Oracle Database has high-level features that are very good."
"This solution has the best performance, bar none."
"Significant assistance in tuning both the migration process and the production database was provided by Oracle Consulting Services, which provided excellent and very professional advice."
"The latest version is a lot more organized than the previous version. We can check out the regular files and our dictionaries and our created files, which are a little better organized right now."
"The reliability is the solution's most valuable feature. We've had great success with the solution."
"There is a lot of information available on the internet, so problems can easily be fixed."
"It is user-friendly. It didn't take me much time to learn it."
"Technical support has been helpful so far."
"The product is easy to learn."
"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"The initial setup is easy."
"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."
"Unbeatable speed and compression with a colummn-structured relational database."
"Columnar storage allows high compression, high load rates and high query performance."
"The initial setup was very complex - best case, it takes between four and six hours to set up."
"I'm in Indonesia. From what I know, Ali Cloud has already built a center in Indonesia, and Google also has a data center in Indonesia. I have heard that Amazon will also build a data center in Indonesia, and the same will be with Azure if they deal with the Indonesian government. I'm quite appreciative of what Amazon has done by deciding to have a local data center. I expect Oracle to do the same, but Oracle doesn't seem to have plans to build a data center in Indonesia. This is something that needs to be improved. Oracle should follow all the other cloud providers who see a potential market in Indonesia. It would be better for Oracle to be equal to other cloud providers and have a data center in Indonesia so they can compete. Having a local data center means that they can avoid performance issues, the latency of the network, and all the things that are related to the network for internet-based solutions. Customers in Indonesia expect a local data center."
"The solution is very, very expensive. This keeps it as a niche product."
"Oracle Database has improved how we do our administrative backups. The solution has a smaller footprint than 11g, it's more efficient on the resources for the users. It has a smoother user experience with the ERP and fewer field transactions."
"The solution is a bit expensive."
"A lot of features have bugs or choose the wrong way to process data."
"It's not very user-friendly, and it's a little complex. Another issue that I don't like is the licensing complexity."
"The integration could be improved. If you are integrating with other Oracle products, it is fine, however, if your goal is to integrate with third-party products, Oracle isn't as good."
"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."
"There is very little documentation available."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"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."
"The tool gets stuck sometimes."
Oracle Database is ranked 2nd in Relational Databases Tools with 283 reviews while SAP IQ is ranked 21st in Relational Databases Tools with 19 reviews. Oracle Database is rated 8.6, while SAP IQ is rated 7.8. The top reviewer of Oracle Database writes "Supports a large volume of transactions compared to other databases". 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, SAP BW4HANA and Apache Hadoop. 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.