Teddy EliasSenior Manager, Systems and Network Engineering at a computer software company
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
"Unbeatable speed and compression with a colummn-structured relational database."
"Eighty percent of the ETL operations have improved since implementing this solution."
"The performance is very good and the aggregate records are fast."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"Allows us to take volumes and process them at a very high speed."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"Speed and resiliency are probably the best parts of this product."
"It has improved my organization's functionality and performance."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"When it is about to reach the maximum storage capacity, it becomes slow."
"Support is an area where it could get better."
"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"The geospatial functionality could be designed better."
"We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well."
"They could improve on customer service."
"The only costs after standard licensing fees are for add-ons and upgrades."
"From a cost perspective, the software is less than most of its competitors."
"It's difficult today to compete with open-source solutions. In these areas, there is a lot of competition and the price of this solution is a bit pricy."
"The price could be cheaper and it is best to negotiate the price."
Earn 20 points
SAP® IQ software delivers speed and power for extreme-scale enterprise data warehousing and analytics. Its column-oriented, grid-based massively parallel processing (MPP) architecture and patented data compression and indexing technologies enable companies to exploit the value of huge amounts of data at the speed of business.
Micro Focus Vertica is the most advanced SQL database analytics portfolio built from the very first line of code to address the most demanding Big Data analytics initiatives. Micro Focus Vertica delivers speed without compromise, scale without limits, and the broadest range of consumption models. Choose Vertica on premise, on demand, in the cloud, or on Hadoop. With support for all leading BI and visualization tools, open source technologies like Hadoop and R, and built-in analytical functions, Vertica helps you derive more value from your Enterprise Data Warehouse and data lakes and get to market faster with your analytics initiatives.
To learn more about Micro Focus Vertica Advanced Analytics, visit our website.
SAP IQ is ranked 11th in Data Warehouse with 1 review while Vertica is ranked 4th in Data Warehouse with 8 reviews. SAP IQ is rated 8.0, while Vertica is rated 9.0. The top reviewer of SAP IQ writes "An excellent column-based, enterprise relational database solution with good speed and compression". On the other hand, the top reviewer of Vertica writes "Superior performance in speed and resilience makes this a very good warehousing solution". SAP IQ is most compared with SAP Adaptive Server Enterprise, Apache Hadoop, SAP HANA, Oracle Database and SAP SQL Anywhere, whereas Vertica is most compared with Snowflake, Amazon Redshift, Teradata, SQL Server and Apache Hadoop.
See our list of best Data Warehouse vendors.
We monitor all Data Warehouse 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.