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."It is a scalable solution."
"The initial setup is easy."
"However, it is easy to scale MySQL using the functions provided with the product."
"It is free, which is probably its most valuable feature. It is a pretty full-featured relational database. It really does everything we need it to do."
"It is very easy to install and has all basic database features."
"My main reason for using MySQL for this small customer database company and for some kinds of scientific projects was that I had to do the installation myself. I didn't have a database administration team behind me. Therefore, I was looking for something very easy to handle. MySQL is easy to install, connect, and do all such things."
"The product is flexible and easy to use."
"The main advantage is the very large user base. This enables users to fix about any issue by answering any question."
"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."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"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."
"Columnar storage allows high compression, high load rates and high query performance."
"The most valuable features of SAP SQL Anywhere are the ease of use and the user interface is intuitive."
"It works well in general."
"We've found the solution very reliable overall. It's very fast."
"The auto-backup replication is a perfect feature. That is the feature I liked the most."
"SAP SQL Anywhere is very helpful."
"Improvements are required in character set support, scalability, and big data sets."
"MySQL could be improved by adding more automation."
"Its performance should be better. When we use big data, it is slow in performance. We should be able to use mirroring for improved performance."
"The solution could improve by having better performance and security."
"When working with a cluster wide, I have to use the MySQL cluster version."
"The solution could have better integration and security features."
"The replication needs improvement. It's becoming a native cloud product like Oracle DB or Cockroach DB."
"When it comes to supporting big data, there is space to improve upon the database engines that are supported by MySQL."
"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."
"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."
"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."
"SAP SQL Anywhere needs to incorporate functionalities like SAP S/4HANA."
"It is not as secure as it could be."
"The interface is not easy in comparison to the SQL Server. It could be more user-friendly."
"A problem we are experiencing now is when doing a backup in SQL 2012 and 14."
"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."