We performed a comparison between SAP IQ, Teradata IntelliFlex, and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."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."
"Columnar storage allows high compression, high load rates and high query performance."
"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."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"The product's scalability is great. Scalability-wise, I rate the solution a ten out of ten."
"IntelliFlex is easy to scale - one of its best features is that you can upscale it to the size you want."
"Intelliflex is very scalable. In fact, scalability has improved 100 times by Intelliflex, in my personal opinion."
"The solution's banking model, called FSLDM (Financial Services Logical Data Model), is sophisticated and good."
"It is very stable. It's 100% uptime. Speed and resilience are one of the greatest features of this product. In almost twenty years we've never had downtime, except for outages for patches and upgrades. We've never had a system failure in twenty years."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"The extensibility and efficiency provided by their C++ SDK."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"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."
"Concurrency and functional error messaging."
"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."
"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."
"The initial setup is complex because there are a lot of factors that come into play, including the amount of software and applications that require access."
"The solution’s pricing, scalability, and technical support response time could be improved."
"The only issue our company has with Teradata IntelliFlex is that it is not cost-effective because of the way the product has been designed."
"They should add more connectors to different platforms."
"The reporting side wasn't very good in the past, but with the latest versions, it's getting better. Still, the friendliness of the PDC reporting and functionality needs to be improved."
"Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"The integration with AI has room for improvement."
"I have found that coding support could be simplified."
"The integration of this solution with ODI could be improved."
"Very bad support, I would rate it two out of 10."
"It needs integration with multiple clouds."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."