Introducing G2.ai, the future of software buying.Try now
Compare Amazon Redshift and OpenText Vertica 
Featured Products
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
Starburst
Visit Website
At a Glance
Market Segments
Mid-Market (39.5% of reviews)
Enterprise (44.6% of reviews)
Entry-Level Pricing
$1.22 - $3.26 Per hour
Free
Amazon Redshift
Star Rating
(397)4.3 out of 5
Market Segments
Mid-Market (39.5% of reviews)
Pros & Cons
Entry-Level Pricing
$1.22 - $3.26 Per hour
Browse all 6 pricing plansOpenText Vertica
Star Rating
(216)4.3 out of 5
Market Segments
Enterprise (44.6% of reviews)
Pros & Cons
Not enough data
Entry-Level Pricing
Free
Browse all 4 pricing plansSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that OpenText Vertica excels in data integration with a score of 8.4, while Amazon Redshift shines in data quality with a higher score of 8.8. Reviewers mention that Vertica's ability to seamlessly integrate various data sources is a significant advantage for enterprises looking to consolidate their data.
- Reviewers mention that OpenText Vertica's built-in data analytics feature scores 8.5, which is higher than Amazon Redshift's score of 8.1. Users say that Vertica's analytics capabilities allow for more in-depth insights directly within the database, enhancing decision-making processes.
- G2 users highlight that Amazon Redshift offers superior cloud deployment options, scoring 8.9 compared to Vertica's 7.9. Users report that Redshift's cloud-native architecture provides better scalability and flexibility for businesses looking to expand their data operations.
- Users on G2 note that OpenText Vertica has a strong performance in real-time data collection with a score of 8.6, which is not directly comparable to Redshift as it lacks this specific metric. Reviewers mention that this feature is crucial for businesses that require immediate data insights for operational efficiency.
- Reviewers mention that Amazon Redshift has a slight edge in security features, particularly in role-based authorization, scoring 8.7 compared to Vertica's 8.4. Users say that Redshift's robust security measures are essential for organizations handling sensitive data.
- Users report that OpenText Vertica's data compression feature scores 8.5, while Amazon Redshift's is slightly lower at 8.4. Reviewers mention that Vertica's efficient data compression capabilities help in reducing storage costs and improving query performance, making it a preferred choice for data-heavy applications.
Pricing
Entry-Level Pricing
Amazon Redshift
RA3.4xlarge
$1.22 - $3.26
Per hour
On-demand, 1-Year, or 3-Year Terms
- Commit to save up to 34%
OpenText Vertica
Vertica Community Edition
Free
Free to use for up to 1TB and three nodes
- https://www.vertica.com/register/
Free Trial
Amazon Redshift
Free Trial is available
OpenText Vertica
Free Trial is available
Ratings
Meets Requirements
8.7
281
8.6
147
Ease of Use
8.7
281
8.5
148
Ease of Setup
8.6
138
8.1
84
Ease of Admin
8.4
128
8.3
89
Quality of Support
8.5
264
8.1
146
Has the product been a good partner in doing business?
8.7
127
8.3
87
Product Direction (% positive)
8.8
252
8.0
143
Features by Category
Data Management
8.8
133
|
Verified
8.4
71
|
Verified
8.4
125
|
Verified
8.5
72
|
Verified
8.8
131
|
Verified
8.6
73
8.0
127
|
Verified
8.5
66
|
Verified
7.6
102
|
Verified
7.9
43
|
Verified
8.3
118
|
Verified
8.4
49
|
Verified
Integration
7.9
101
|
Verified
7.7
43
|
Verified
8.7
128
|
Verified
8.4
65
|
Verified
8.6
119
|
Verified
8.2
50
|
Verified
Deployment
8.1
102
8.3
66
|
Verified
8.9
130
|
Verified
7.9
51
|
Verified
Performance
8.9
134
|
Verified
8.3
71
|
Verified
Security
8.7
126
|
Verified
8.3
66
|
Verified
8.8
128
|
Verified
8.5
67
|
Verified
Generative AI
7.3
20
8.3
8
7.2
19
7.9
8
Storage
8.4
53
8.4
22
8.4
56
8.0
22
Availability
8.6
47
8.4
20
8.2
50
8.2
22
8.4
48
8.6
22
Performance
8.2
48
8.5
21
Security
8.7
47
8.4
22
8.4
52
8.6
22
8.1
47
8.2
19
8.5
48
8.2
21
Support
7.9
43
8.4
15
8.5
47
8.3
17
Database
Not enough data
8.6
48
Not enough data
8.7
47
Not enough data
8.6
47
Integrations
Not enough data
8.4
41
Not enough data
8.1
39
Platform
Not enough data
8.3
37
Not enough data
8.4
44
Not enough data
8.1
39
Processing
Not enough data
8.3
41
Not enough data
8.7
46
Building Reports
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Platform
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Categories
Categories
Shared Categories
Amazon Redshift and OpenText Vertica are categorized as Columnar Databases and Data Warehouse
Unique Categories
Amazon Redshift is categorized as Big Data Integration Platforms
OpenText Vertica is categorized as Big Data Processing and Distribution
Reviews
Reviewers' Company Size
Amazon Redshift
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
OpenText Vertica
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Small-Business
(50 or fewer emp.)
Mid-Market
(51-1000 emp.)
Enterprise
(> 1000 emp.)
Reviewers' Industry
Information Technology and Services
15.5%
Computer Software
12.7%
Financial Services
7.7%
Retail
5.2%
Telecommunications
4.7%
Other
54.1%
Computer Software
19.0%
Information Technology and Services
17.4%
Financial Services
6.7%
Telecommunications
5.6%
Retail
5.6%
Other
45.6%
Alternatives
Discussions
Should I use with a data mart for a frontend tool that make request on it ?
3 Comments
NM
Hi Mehdi
Can you elaborate your question?
AWS Redshift is a DataBase/Data Warehouse service, which is Ideal for Analytical use cases.
You can...Read more
When can I use Amazon redshift?
3 Comments
PG
Redshift is big data warehousing solution to handle petabytes of data and also for real time decisions. If you want highly optimized data warehousing...Read more
Who uses Vertica and for what?
2 Comments
PR
A LOT of companies, from tiny startups to the biggest data companies.
7 of top 10 telecoms in world, including AT&T, plus companies like Anritsu that sell...Read more
Is it hard to learn to be a Vertica user? Admin?
2 Comments
PR
Also, check out the Vertica Academy: https://academy.vertica.com/ Free classes to learn how to admin Vertica, including certification. Read more
What’s the best use case for Vertica?
1 Comment
MG
For Finance: Fraud detection, Anti-money laundering, Risk management
For Government: Law enforcement, Counter terrorism, Traffic flow optimization
For...Read more
Hunting for software insights?
With over 3 million reviews, we can provide the specific details that help you make an informed software buying decision for your business. Finding the right product is important, let us help.
