Introducing G2.ai, the future of software buying.Try now

Compare Amazon Redshift and OpenText Vertica

Save
    Log in to your account
    to save comparisons,
    products and more.
At a Glance
Amazon Redshift
Amazon Redshift
Star Rating
(397)4.3 out of 5
Market Segments
Mid-Market (39.5% of reviews)
Information
Pros & Cons
Entry-Level Pricing
$1.22 - $3.26 Per hour
Browse all 6 pricing plans
OpenText Vertica
OpenText Vertica
Star Rating
(216)4.3 out of 5
Market Segments
Enterprise (44.6% of reviews)
Information
Pros & Cons
Not enough data
Entry-Level Pricing
Free
Browse all 4 pricing plans
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
Browse all 6 pricing plans
OpenText Vertica
Vertica Community Edition
Free
Browse all 4 pricing plans
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
8.4
147
8.3
89
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
8.3
63
8.4
22
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
Big Data Processing and DistributionHide 10 FeaturesShow 10 Features
Not enough data
8.4
51
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
Not enough data
Not enough data
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
Amazon Redshift
OpenText Vertica
OpenText Vertica
Amazon Redshift and OpenText Vertica are categorized as Columnar Databases and Data Warehouse
Unique Categories
Amazon Redshift
Amazon Redshift is categorized as Big Data Integration Platforms
OpenText Vertica
OpenText Vertica is categorized as Big Data Processing and Distribution
Reviews
Reviewers' Company Size
Amazon Redshift
Amazon Redshift
Small-Business(50 or fewer emp.)
21.0%
Mid-Market(51-1000 emp.)
39.5%
Enterprise(> 1000 emp.)
39.5%
OpenText Vertica
OpenText Vertica
Small-Business(50 or fewer emp.)
19.5%
Mid-Market(51-1000 emp.)
35.9%
Enterprise(> 1000 emp.)
44.6%
Reviewers' Industry
Amazon Redshift
Amazon Redshift
Information Technology and Services
15.5%
Computer Software
12.7%
Financial Services
7.7%
Retail
5.2%
Telecommunications
4.7%
Other
54.1%
OpenText Vertica
OpenText Vertica
Computer Software
19.0%
Information Technology and Services
17.4%
Financial Services
6.7%
Telecommunications
5.6%
Retail
5.6%
Other
45.6%
Alternatives
Amazon Redshift
Amazon Redshift Alternatives
Google Cloud BigQuery
Google Cloud BigQuery
Add Google Cloud BigQuery
Snowflake
Snowflake
Add Snowflake
Cloudera
Cloudera
Add Cloudera
IBM Db2
IBM Db2
Add IBM Db2
OpenText Vertica
OpenText Vertica Alternatives
Google Cloud BigQuery
Google Cloud BigQuery
Add Google Cloud BigQuery
Snowflake
Snowflake
Add Snowflake
Teradata Vantage
Teradata Vantage
Add Teradata Vantage
Databricks Data Intelligence Platform
Databricks Data Intelligence Platform
Add Databricks Data Intelligence Platform
Discussions
Amazon Redshift
Amazon Redshift 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
Prakash G.
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
Is Amazon redshift good for large datasets considering its cost.
2 Comments
Anshu Raj C.
AC
its costlyRead more
OpenText Vertica
OpenText Vertica Discussions
Who uses Vertica and for what?
2 Comments
Paige R.
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
Paige R.
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