We performed a comparison between MySQL, SAP IQ, and SQL Server based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."The solution is free to use, which is its most valuable aspect."
"I rate the solution's stability a ten out of ten since it has been running flawlessly."
"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."
"It is a very stable solution. I deployed the product six years ago, and it still works fine."
"Compared to other databases, MySQL is cheaper and we were using the community edition which was free of cost. ML is fully integrated with the database in HeatWave. It has also many other features. MySQL is a far better solution in terms of pricing."
"The initial setup was easy. I work in an agile way, which means coding and deploying quickly."
"MySQL is open-source. There are a lot of open-source communities trying to come up with their own patches, and to come up with their own features, which help MySQL develop faster than traditional databases like Oracle, which is closed source."
"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."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"Columnar storage allows high compression, high load rates and high query performance."
"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"The solution can be deployed in a few minutes."
"SQL Server is similar to other Microsoft products, such as BI, they are easy to use. You do not need to have an expensive BD to maintain them. All the useful intuitive features you find in Microsoft solutions you will find in SQL Server."
"You could have an offsite and an onsite, and if the onsite goes down, the offsite picks it up. I like that flexibility to provide continuing operations."
"The initial setup is time-efficient and can be done independently."
"A big advantage is the ability to store any type of data in SQL Server."
"I like that it's very easy to use, and Veeam is excellent. There are tons of experts and writers in the area now, and we don't find the same for other databases."
"I value the ability it gives me to test on small machines and easily scale up to larger devices for live applications."
"It's a good learning environment, it's easy enough to learn and understand. Anybody that picks up the language early on will be able to develop in it."
"The product is a little bit complex and it is difficult to find sufficient documentation."
"At times, the autoscaling does not happen when there is a surge in load."
"MySQL tutorials and guides could be improved. Often they are too complex for someone with no database experience to understand."
"Security is a concern. MySQL could have better security features."
"The solution could improve the monitoring. At the present time, you need to use third-party monitoring solutions."
"The solution could improve by having better performance and security."
"The solution could have better integration and security features."
"It could be more secure."
"I think the universe should be part of the Sybase IQ tool set."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
"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."
"The integration could be better. They are not open-source, so the integration with other platforms is not that easy."
"The treatment of database storage could be improved."
"Indexing, as well as integration, are areas of this product that need improvement."
"The tool is expensive."
"The solution needs to be more secure. It's lacking, compared to, for example, Oracle."
"The UX design of this system needs improvement."
"There should be more tools and documentation for tuning the performance of Microsoft SQL Server. It would be nice to have more tools for tuning because currently, all the tuning that we have to do with our databases is almost manual. We have to read a bunch of knowledge base articles, and this information should be better documented. Its free text search should also be improved. It is quite important for us. Currently, we're developing our own free text search because of the lacking flexibility in Microsoft SQL Server. Therefore, we're kind of using elastic search and making different implementations in order to reach our targets. Using just the native free text search of Microsoft SQL Server is not enough for us. It should have more flexible features as compared to the current version."
"I have experience working with SQL Server 2016 and older versions, including handling JSON data. Initially, I found the JSON capabilities to be less helpful, but over time, they have greatly improved. SQL Server now offers extensive capabilities for working with various forms of data, particularly when communicating with text, such as in JSON format. I particularly prefer working with these features on Azure, as it provides numerous possibilities, especially in the field of business intelligence (BI). Additionally, the serverless platform offered by Azure is highly beneficial and makes tasks easier to manage."