Compare Microsoft SQL Server and OpenText Vertica 
Featured Products
At a Glance
Market Segments
Enterprise (45.5% of reviews)
Enterprise (44.6% of reviews)
Entry-Level Pricing
No pricing available
Free
Microsoft SQL Server
Star Rating
(2,261)4.4 out of 5
Market Segments
Enterprise (45.5% of reviews)
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about Microsoft SQL ServerOpenText 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.
- G2 reviewers report that Microsoft SQL Server excels in user experience, particularly for beginners. Users appreciate its intuitive interface in SQL Server Management Studio (SSMS) and straightforward implementation process, making it easy to get started with database management.
- According to verified reviews, OpenText Vertica shines in handling large datasets and complex queries, making it a preferred choice for analytics and Big Data. Users highlight its ability to process millions of rows in real-time, which is crucial for businesses needing quick insights.
- Users say that Microsoft SQL Server offers robust features like the 'Always On' functionality, which enhances database durability and performance. This feature, along with strong security measures, contributes to its reputation for reliability in enterprise environments.
- Reviewers mention that OpenText Vertica provides flexibility in data processing, allowing users to perform multiple tasks simultaneously. The integration of data lakes and the ability to add more clusters for scaling are particularly noted as advantages for businesses dealing with heavy data loads.
- G2 reviewers highlight that Microsoft SQL Server has a strong support system, with users praising the quality of assistance available. This support, combined with its seamless integration with other Microsoft tools, enhances the overall user experience and productivity.
- According to recent user feedback, while OpenText Vertica is effective for analytics, some users feel it may not be as user-friendly as Microsoft SQL Server, particularly for those less experienced in data management. This could pose a challenge for teams looking for a more accessible solution.
Pricing
Entry-Level Pricing
Microsoft SQL Server
No pricing availableOpenText Vertica
Vertica Community Edition
Free
Free to use for up to 1TB and three nodes
- https://www.vertica.com/register/
Free Trial
Microsoft SQL Server
No trial information availableOpenText Vertica
Free Trial is available
Ratings
Meets Requirements
9.0
1,854
8.6
147
Ease of Use
8.6
1,870
8.5
148
Ease of Setup
8.1
992
8.1
84
Ease of Admin
8.3
950
8.3
89
Quality of Support
8.3
1,649
8.1
146
Has the product been a good partner in doing business?
8.4
900
8.3
87
Product Direction (% positive)
8.4
1,825
8.0
143
Features by Category
Data Management
Not enough data
8.4
71
|
Verified
Not enough data
8.5
72
|
Verified
Not enough data
8.6
73
Not enough data
8.5
66
|
Verified
Not enough data
7.9
43
|
Verified
Not enough data
8.4
49
|
Verified
Integration
Not enough data
7.7
43
|
Verified
Not enough data
8.4
65
|
Verified
Not enough data
8.2
50
|
Verified
Deployment
Not enough data
8.3
66
|
Verified
Not enough data
7.9
51
|
Verified
Performance
Not enough data
8.3
71
|
Verified
Security
Not enough data
8.3
66
|
Verified
Not enough data
8.5
67
|
Verified
Generative AI
Not enough data
8.3
8
Not enough data
7.9
8
Management
8.9
153
Not enough data
8.8
153
Not enough data
9.2
158
Not enough data
8.9
153
Not enough data
8.9
156
Not enough data
Maintenance
8.9
154
Not enough data
9.0
159
Not enough data
9.0
154
Not enough data
Security
8.9
153
Not enough data
9.1
155
Not enough data
Management
9.0
149
Not enough data
9.2
151
Not enough data
8.8
137
Not enough data
8.8
142
Not enough data
Support
8.6
145
Not enough data
9.0
149
Not enough data
8.6
144
Not enough data
8.4
151
Not enough data
Security
8.8
148
Not enough data
9.0
148
Not enough data
8.8
145
Not enough data
9.0
149
Not enough data
Performance
8.7
144
Not enough data
8.8
141
Not enough data
8.7
147
Not enough data
8.6
145
Not enough data
8.8
146
Not enough data
Database Features
8.9
1287
Not enough data
9.0
1291
Not enough data
8.9
1299
Not enough data
8.7
1266
Not enough data
8.8
1267
Not enough data
8.8
1271
Not enough data
9.1
1291
Not enough data
Storage
Not enough data
8.4
22
Not enough data
8.0
22
Availability
Not enough data
8.4
20
Not enough data
8.2
22
Not enough data
8.6
22
Performance
Not enough data
8.5
21
Security
Not enough data
8.4
22
Not enough data
8.6
22
Not enough data
8.2
19
Not enough data
8.2
21
Support
Not enough data
8.4
15
Not enough data
8.3
17
Database
8.5
56
8.6
48
8.8
57
8.7
47
8.4
54
8.6
47
Integrations
7.8
45
8.4
41
8.2
45
8.1
39
Platform
8.2
50
8.3
37
8.5
53
8.4
44
8.2
45
8.1
39
Processing
8.5
52
8.3
41
8.5
55
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
Microsoft SQL Server and OpenText Vertica are categorized as Big Data Processing and Distribution
Unique Categories
Microsoft SQL Server is categorized as Relational Databases, Database Management Systems (DBMS), and On-Premise Data Integration
OpenText Vertica is categorized as Data Warehouse and Columnar Databases
Reviews
Reviewers' Company Size
Microsoft SQL Server
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
24.1%
Computer Software
13.7%
Hospital & Health Care
5.4%
Financial Services
4.3%
Higher Education
2.9%
Other
49.6%
Computer Software
19.0%
Information Technology and Services
17.4%
Financial Services
6.7%
Hospital & Health Care
5.6%
Marketing and Advertising
5.6%
Other
45.6%
Alternatives
Discussions
How could I make much easier the experience with the order of my database?
4 Comments
AF
You can create different tables with your employee information eg employee table, employee roles etc. Then you can create a single view that will pull data...Read more
What is the best way to save your queries?
4 Comments
CA
I recommend that you use the saved querys in plain text or .sql or txt format you can use the same sql server query creator or a notepad +++ tool, they are...Read more
How can I work on the same query if the connection is lost (timeout) and then I reconnect?
4 Comments
JE
When this happens to me in SQL Server Management Studio, I just have to type USE {your database name here} and then select only that statement and execute...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.
