We performed a comparison between MySQL, 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."The deployment process is pretty fast."
"We use it as a data store and from that perspective, we get everything we need."
"It has a remote access feature to manage the database from a remote location. This enables in-work collaboration."
"The initial setup was easy. I work in an agile way, which means coding and deploying quickly."
"The solution is very simple. It's easy to use. That's the most important feature."
"The one interesting thing about this product is that it is open source. It comes from an open source product. MySQL has been positioned as open source, but it also provides support."
"The solution helps us perform with our databases and extract data."
"The feature that I have found most valuable is its ubiquity. MySQL is everywhere, so if I need to find a developer to do things to it that I don't know, it's very easy to find someone who has expertise in it."
"Unbeatable speed and compression with a colummn-structured relational database."
"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."
"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."
"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"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."
"It works well in general."
"The auto-backup replication is a perfect feature. That is the feature I liked the most."
"SAP SQL Anywhere is very helpful."
"The performance, stability, and security are areas with shortcomings in MySQL, where improvements are required."
"The documentation is pretty weak and should be improved."
"It should have some code analytical functions. It can also have a monitoring tool."
"When I run into issues, I really have to research how to fix them."
"The solution could improve by having better performance and security."
"The manuals or documentation could be better."
"I did the implementation of the solution myself and I used community support. The support from the vendor costs money."
"The solution could be more secure."
"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."
"I think the universe should be part of the Sybase IQ tool set."
"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."
"Concurrency and functional error messaging."
"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."
"It is not as secure as it could be."
"SAP SQL Anywhere needs to incorporate functionalities like SAP S/4HANA."