We performed a comparison between SAP IQ, SQL Server, and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."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."
"It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."
"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."
"Unbeatable speed and compression with a colummn-structured relational database."
"The performance is great."
"It is the latest technology and pretty powerful in terms of the high availability of the virtual server."
"I like that it's a cloud solution, is simple to set up, and is simple to use."
"It is easy to use and easy to perform a backup."
"Easy to implement and user-friendly relational database management system. This product is stable and scalable."
"SQL Server is quite user-friendly. I have experience with Oracle and PostgreSQL, so out of three, I like SQL Server a lot."
"This solution is user-friendly and easy to understand."
"SQL Server and their offers are very good. You can switch over, export, and do other things."
"Eighty percent of the ETL operations have improved since implementing this solution."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data."
"We are also opening new areas of business and potential new revenue streams using Vertica's analytic functions, most notably geospatial, where we are able to run billions of comparisons of lat/long point locations against polygon and point/radius locations in seconds. "
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"Speed and resiliency are probably the best parts of this product."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"I enjoy the cybersecurity and backup features."
"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."
"Concurrency and functional error messaging."
"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."
"Performance could be improved. There could be more support to PHP-based websites and to providing direct plugins for connections, and the related services or application services could be improved."
"Additional interfaces would be an improvement."
"SQL Server could improve by enhancing the integration abilities, adding more inbuilt data security features, and simplifying the maintenance."
"It may be a licensing issue, but sometimes its operating speed becomes slow if we have multiple users. It's lacking some performance, but it's acceptable because we have a heavy load."
"We want to move to Azure, and the solution could be made better to make the process easier for the migration from on-premise to the cloud."
"In terms of what could be improved, everything on-premise is now moving to the cloud. Obviously SQL Server has also moved, because Microsoft Excel has its own cloud called Azure Finance. Every solution comes with its own advantages and disadvantages."
"The interface of the tool has certain shortcomings, making it an area where improvements are required."
"SQL Server doesn't have proper bitmap indexing, proper columnar databases, or proper implementation of materialized views."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"It's hard to make it slow for a small data volume. For large volumes, it's hard to make it work. It's also hard to make it faster, and to make it scale."
"It would be great if this were a managed service in AWS."
"The biggest problem is the cost of cloud deployment."
"We faced some challenges when trying to use the temporary tables feature."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"Very bad support, I would rate it two out of 10."
"Documentation has become much better, but can always use some improvement."