Compare SAP IQ vs. Vertica

Cancel
You must select at least 2 products to compare!
SAP IQ Logo
2,237 views|1,551 comparisons
Vertica Logo
12,463 views|7,530 comparisons
Most Helpful Review
Teddy Elias
Find out what your peers are saying about Snowflake Computing, Oracle, Apache and others in Data Warehouse. Updated: June 2021.
512,221 professionals have used our research since 2012.
Quotes From Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros
"Unbeatable speed and compression with a colummn-structured relational database."

More SAP IQ Pros »

"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."

More Vertica Pros »

Cons
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."

More SAP IQ Cons »

"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."

More Vertica Cons »

Pricing and Cost Advice
"The only costs after standard licensing fees are for add-ons and upgrades."

More SAP IQ Pricing and Cost Advice »

"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."

More Vertica Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
512,221 professionals have used our research since 2012.
Questions from the Community
Ask a question

Earn 20 points

Top Answer: The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful.
Top Answer: 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.
Top Answer: The product could be less expensive and could benefit from a better marketing strategy. In a future release, I would like to have one application to help create intelligent models.
Ranking
11th
out of 30 in Data Warehouse
Views
2,237
Comparisons
1,551
Reviews
1
Average Words per Review
1,235
Rating
8.0
4th
out of 30 in Data Warehouse
Views
12,463
Comparisons
7,530
Reviews
6
Average Words per Review
513
Rating
9.0
Popular Comparisons
Also Known As
Sybase IQ
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
Learn More
Overview

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.

Offer
Learn more about SAP IQ
Learn more about Vertica
Sample Customers
ASR Group, Citrix, State of Indiana, PocketCard Co. Ltd.
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Top Industries
REVIEWERS
Financial Services Firm67%
Marketing Services Firm11%
Healthcare Company11%
Insurance Company11%
VISITORS READING REVIEWS
Computer Software Company37%
Comms Service Provider13%
Financial Services Firm12%
Government6%
REVIEWERS
Computer Software Company22%
Media Company19%
Marketing Services Firm16%
Comms Service Provider13%
VISITORS READING REVIEWS
Computer Software Company33%
Comms Service Provider18%
Financial Services Firm7%
Media Company6%
Company Size
REVIEWERS
Small Business19%
Midsize Enterprise13%
Large Enterprise69%
REVIEWERS
Small Business31%
Midsize Enterprise24%
Large Enterprise45%
Find out what your peers are saying about Snowflake Computing, Oracle, Apache and others in Data Warehouse. Updated: June 2021.
512,221 professionals have used our research since 2012.

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.