We performed a comparison between SAP IQ, SAP SQL Anywhere, 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 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."
"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."
"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."
"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."
"SAP SQL Anywhere is very helpful."
"It works well in general."
"The auto-backup replication is a perfect feature. That is the feature I liked the most."
"The most valuable features of SAP SQL Anywhere are the ease of use and the user interface is intuitive."
"SQL Server, a widely adopted database management system, is utilized across numerous sectors. Initially competing with Oracle and Db2, SQL Server has gained popularity. It serves as the backend database for a variety of applications."
"The management studio is probably the thing we use the most for running quick queries and creating quick reports. Quite often, somebody comes and says, "Hey, can you find XYZ?" It is so much easier just to jump in there and run a quick query."
"SQL Server is easy to manage."
"It is easy to use and easy to perform a backup."
"It integrates well with other platforms."
"This solution has proven stability and operational power."
"Agent service is a good feature of SQL Server, where you can schedule certain tasks."
"Scalability, cluster ability, ease of use, ease of implementation — these are all great."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
"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."
"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."
"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."
"It is not as secure as it could be."
"A problem we are experiencing now is when doing a backup in SQL 2012 and 14."
"For a big amount of data, when we are speaking about IoT Segments, and Big Data projects, there are performance issues."
"While using it, we really didn't experience any pain points."
"Query optimitzer could be simplified."
"The scalability is adequate but could improve."
"You do need to have technical knowledge in order to install the solution. It's not something a layperson can do."
"The price could be better. It costs a lot, and competing databases like Postgres are free."
"The stored procedure integration with our development could be better. Things are always changing very fast at Microsoft, and it takes a lot of resources to get on top of it. We're struggling with version control. In terms of new features, we don't have any feature requests. We are not focusing on the database."
"I would like to see improvements made to the stability of SQL Server, as well as more analytics requirements."