Teradata vs Vertica

Teradata is ranked 3rd in Relational Databases with 13 reviews vs Vertica which is ranked 2nd in Data Warehouse with 52 reviews. The top reviewer of Teradata writes "It is the core of our fundamental real-time reporting and operational planning. ". The top reviewer of Vertica writes "The ability to view running queries and cancel problem ones from the Management Console is a very nice feature". Teradata is most compared with Oracle Exadata, Vertica and SQL Server. Vertica is most compared with Oracle Exadata, Teradata and Pivotal Greenplum. See our Teradata vs Vertica report.
Cancel
You must select at least 2 products to compare!
+Add products to compare
Most Helpful Review
Teradata vs. vertica report from it central station 2018 01 04 thumbnail
Find out what your peers are saying about Teradata vs. Vertica and others in Relational Databases
252,993 professionals have used our research since 2012.

Quotes From Members Comparing Teradata vs Vertica

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
Pros
The key advantages are Performance when processing Terabytes of data and scalability.Improved performance of ETL procedures, reporting.We did performance testing. We had a set of real life MicroStrategy reports. Our conditions were: Not allowed to redesign data model, not allowed to rewrite the queries, all queries should be generated by MicroStrategy, no aggregates. Teradata appeared to be way faster than a similarly configured (in terms of hardware) Oracle server.

Read more »

The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors.I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution.Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data.Partition and join back to node are easy and simple for DBAs.DBAs don’t need to add a partition every month/quarter like with other DBs.Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance.The fast columnar store database structure allows our query times to be at least 10x faster than on any other database.We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently.

Read more »

Cons
The following could be better: licensing, architecture openness, integration with other tools.GUI of administrative tools is really outdated.

Read more »

I believe the installation process could be streamlined.There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs.Very bad support, I would rate it two out of 10.Performance of management of metadata layer (database catalog) needs improvement. We still have to have smaller customers on PostgreSQL; Vertica cannot manage thousands of schemata.Suboptimal projection design causes queries to not scale linearly.Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes.Documentation has become much better, but can always use some improvement.

Read more »

Pricing and Cost Advice
Teradata is expensive but gives value for money, especially if you don't want to move your data to the cloud.It is still a very expensive solution. While I very much like the pure technological supremacy of the software itself, I believe Teradata as a company needs to become more affordable. They are already losing the market to more flexible or cheaper competitors.

Read more »

I think it's starting to get a little expensive. Open source products are starting to get more robust, so I think that's something that they need to start looking at in terms of licensing.The first TB is free and you can use all the Vertica features. After 1TB you have to pay for licensing. The product is worth it, but be aware of this condition, and plan. The compression ratio is explained in the documentation.Start with license per 1TB. Starting from hundreds of TB there is unlimited licensing to be considered. Move historical data to HDFS/S3 which are significantly cheaper or even free.Work with a vendor, if possible, and take advantage of more aggressive discounts at mid-fiscal year (April) and fiscal year-end (October).​

Read more »

Teradata vs. vertica report from it central station 2018 01 04 thumbnail
Find out what your peers are saying about Teradata vs. Vertica and others in Relational Databases
252,993 professionals have used our research since 2012.
Ranking
RANKING
Views
13,634
Comparisons
11,614
Reviews
11
Followers
1,375
Avg. Rating
8.8
Views
22,468
Comparisons
9,087
Reviews
52
Followers
1,303
Avg. Rating
8.1
Top Comparisons
Top Comparisons
Jt hjyjg 400x400
Compared 16% of the time.
Micro focus logo
Compared 11% of the time.
Microsoft 400x400
Compared 10% of the time.
See more Teradata competitors »
Jt hjyjg 400x400
Compared 14% of the time.
Teradata
Compared 12% of the time.
Pivotal logo
Compared 10% of the time.
See more Vertica competitors »
Also Known As
Also Known AsMicro Focus Vertica, HPE Vertica, HPE Vertica on Demand
Website/Video
Website/VideoTeradata
  • Vendor 8124 screenshot 1514062917
Micro Focus
  • Vendor 7619 screenshot 1516468546
OverviewQuestionmark icon
Overview

Teradata's portfolio of big data analytic solutions, integrated marketing applications, and services help organizations gain a sustainable competitive advantage with data.

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.

Sample Customers
Sample CustomersNetflixCerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Top IndustriesQuestionmark icon
Top Industries
VISITORS READING REVIEWS
Financial Services Firm
23%
Comms Service Provider
17%
Software R&D Company
6%
Energy/Utilities Company
6%
REVIEWERS
Marketing Services Firm
23%
Software R&D Company
19%
Media Company
16%
Comms Service Provider
13%
VISITORS READING REVIEWS
Financial Services Firm
23%
Comms Service Provider
14%
Marketing Services Firm
10%
Media Company
10%
Company SizeQuestionmark icon
Company Size
REVIEWERS
Small Business
7%
Midsize Enterprise
14%
Large Enterprise
79%
VISITORS READING REVIEWS
Small Business
17%
Midsize Enterprise
14%
Large Enterprise
69%
REVIEWERS
Small Business
30%
Midsize Enterprise
26%
Large Enterprise
44%
VISITORS READING REVIEWS
Small Business
25%
Midsize Enterprise
25%
Large Enterprise
50%
Teradata vs. vertica report from it central station 2018 01 04 thumbnail
Find out what your peers are saying about Teradata vs. Vertica and others in Relational Databases
Download now
252,993 professionals have used our research since 2012.
We monitor all Relational Databases 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.

Sign Up with Email