We performed a comparison between SAP IQ and SQL Server based on real PeerSpot user reviews.
Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."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."
"Unbeatable speed and compression with a colummn-structured relational database."
"The initial setup is easy."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"The product is easy to learn."
"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."
"The documentation and manuals are very good."
"We use it for our on-premises solutions, virtual servers and SSAS, SSRS packages. Also, our applications are .NET based, so it made to use it."
"SQL Server provides good performance. Most of the SQL solutions can be integrated and this solution is no different, you are able to link other databases. For example, we have Oracle running a Postgres Server and it is linked. It follows the ISO standard when it comes to commands, it works well."
"We've found it to basically be pretty problem-free."
"They have improved the UI and ease of accessing the database and server which is good. You can load it up and start using it from the very minute it is implemented."
"The license fee is very low."
"It is integrated with Microsoft tools."
"I like the availability group functionality. We are setting up more clusters using availability groups. The enterprise licensing or Software Assurance makes it a little bit cheaper as well. It is nice to have that read-only copy for reporting and everything else."
"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"The tool gets stuck sometimes."
"Concurrency and functional error messaging."
"There is very little documentation available."
"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."
"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."
"Additional interfaces would be an improvement."
"For a big amount of data, when we are speaking about IoT Segments, and Big Data projects, there are performance issues."
"Their datatypes need improvement."
"Sometimes, the tool doesn't support all the native features, and because of this, our company has to customize it to meet our requirements, which is a challenging process for our company's engineers."
"In some cases it is quite difficult, like the lack of ease of the replication and other issues. They have to improve on that. They do not have features like "always on," which is complicated."
"They could improve the solution by allowing more portability between on-premise and the cloud."
"The Task Scheduler has a lot of shortcomings. This could be improved quite a bit."
"As SQL server could not support the number of connections we desired, we were forced to go with Oracle."
SAP IQ is ranked 21st in Relational Databases Tools with 19 reviews while SQL Server is ranked 1st in Relational Databases Tools with 260 reviews. SAP IQ is rated 7.8, while SQL Server is rated 8.4. The top reviewer of SAP IQ writes "Easy to use, highly stable, but integration could improve". On the other hand, the top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". SAP IQ is most compared with Snowflake, SAP HANA, SAP BW4HANA, Apache Hadoop and SAP Adaptive Server Enterprise, whereas SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, LocalDB and IBM Db2 Database. See our SAP IQ vs. SQL Server report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.