We performed a comparison between Oracle Database, SAP IQ, and SAP SQL Anywhere based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."Compared to other databases, Oracle Database is very simple to manage in terms of the database itself."
"It is easy to set up on their engineered systems."
"I am not an IT person. I am an end-user of this solution, and based on my experience, it is comfortable to work with. Everything is okay, and the data is timely available. It can also be easily integrated."
"It's fast compared to other databases."
"In general, the product is strong enough and offers high performance."
"The main feature of Oracle Database is its performance."
"The solution has great security."
"The pricing is very competitive. Oracle is still the number one database company. From the technical aspects, Oracle Database is the best solution for small, medium, and big industries."
"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."
"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"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."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"The most valuable features of SAP SQL Anywhere are the ease of use and the user interface is intuitive."
"The auto-backup replication is a perfect feature. That is the feature I liked the most."
"SAP SQL Anywhere is very helpful."
"We've found the solution very reliable overall. It's very fast."
"It works well in general."
"I can only remember that setting up Oracle Database was a pain because it uses Java."
"In my opinion, the pricing of all the additional tools that Oracle provides is very complicated. The pricing model is very unfriendly for the user, and for the web vendors."
"The queries performance could improve compared to other products."
"The price could be better. Oracle Database could also be easier to scale."
"It's not very user-friendly, and it's a little complex. Another issue that I don't like is the licensing complexity."
"The licensing model is complicated and could be improved."
"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 initial setup could be easier."
"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 solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."
"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 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."
"It is not as secure as it could be."
"SAP SQL Anywhere needs to incorporate functionalities like SAP S/4HANA."
"The interface is not easy in comparison to the SQL Server. It could be more user-friendly."
"We have had some stability issues with SAP SQL Anywhere, but I am not sure if it is an application or network issue. We sometimes have a large amount of data being queried and it cannot handle it."
"A problem we are experiencing now is when doing a backup in SQL 2012 and 14."