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."Most of our customers have been using multitenant options. Advanced Compression and Advanced Security are the most valuable features in most customer environments."
"In general, the product is strong enough and offers high performance."
"Oracle is somewhat user-friendly, and most customization or integration with Oracle-related projects is simple."
"The feature I find most valuable about this solution is the reliability."
"The performance of the solution is impeccable."
"Its performance is good. It is also stable and scalable."
"We find the solution to be stable."
"It's fast compared to other databases."
"It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."
"Columnar storage allows high compression, high load rates and high query performance."
"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."
"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."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"We've found the solution very reliable overall. It's very fast."
"The most valuable features of SAP SQL Anywhere are the ease of use and the user interface is intuitive."
"SAP SQL Anywhere is very helpful."
"The auto-backup replication is a perfect feature. That is the feature I liked the most."
"It works well in general."
"On the ERP side, they do not seem to be improving the on-premises version. They seem to want to push the cloud option on users."
"It could be slightly more intuitive, but other than that, we really like it as a solution."
"How you implement or deploy the product can be an area of concern that can be made a bit easier."
"The solution is a bit expensive."
"It could be cheaper and easier to manage. Support could also be better. Performance could be better. Sometimes testing impacts the prediction performance. We have a complex server that serves both prediction and testing. Sometimes testing applies to many other deployments that impact the service provided. It's a problem for our company."
"The stability could be improved."
"This product would be improved with Support Services for more production access."
"The compression does not give much value-add or provide performance benefits as was highlighted."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"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."
"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."
"SAP SQL Anywhere needs to incorporate functionalities like SAP S/4HANA."
"A problem we are experiencing now is when doing a backup in SQL 2012 and 14."
"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."
"It is not as secure as it could be."