What users are saying about
14 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.7 out of 100
21 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.8 out of 100

Likelihood to Recommend

Teradata Data Warehouse Appliance

It is highly applicable for large, corporate companies with data coming from multiple sources. Teradata can be used as an ODS (Operational Data Store) to merge the source data, then it can also be used to create development/UAT databases, and production databases under the same server. It is capable of processing billions of records per day. It is less appropriate for companies with a single source of data.
Anonymous | TrustRadius Reviewer

Vertica

Vertica as a data warehouse to deliver analytics in-house and even to your client base on scale is not rivaled anywhere in the market. Frankly, in my experience it is not even close to equaled. Because it is such a powerful data warehouse, some people attempt to use it as a transactional database. It certainly is not one of those. Individual row inserts are slow and do not perform well. Deletes are a whole other story. RDBMS it is definitely not. OLAP it rocks.
Eva Donaldson | TrustRadius Reviewer

Pros

Teradata Data Warehouse Appliance

  • Can query multiple databases within one server and view all results in one window. Helps speed up analysis.
  • Teradata uses AMPs (Access Module Processors) to increase speed of data processing/queries. You must use 'COLLECT STATISTICS' properly to efficiently use the AMPs.
  • Most standard SQL practices work on Teradata. Also, Teradata formats the query in a nice colored structure.
  • Can search for tablenames or specific columnnames across the entire server. Helps when changing a specific column or table structure.
Anonymous | TrustRadius Reviewer

Vertica

  • Extremely fast query performance - Vertica is one of the fastest query engines out there.
  • Scales to TBs - Scales reasonably well up to 10-20 nodes and 10 - 100s of TB of data.
  • Easy to Use - Fairly easy to user, we made quite some headway with just 1 person running it for a while.
Praveen Murugesan | TrustRadius Reviewer

Cons

Teradata Data Warehouse Appliance

  • Errors on compiling a procedure are sometimes hard to decipher. Teradata provides a line number of the error but this number does not always match the line number of the procedure in the query window.
  • Teradata won't run a query if I copy and paste from my internal company chat. Something with the formatting from the chat creates a syntax error, so I have to take time to rewrite the query.
  • I haven't been able to insert multiple new rows into a table with 1 insert. Other SQL programs allow this with a comma, but Teradata makes you create separate inserts for each row.
Anonymous | TrustRadius Reviewer

Vertica

  • Could use some work on better integrating with cloud providers and open source technologies. For AWS you will find an AMI in the marketplace and recently a connector for loading data from S3 directly was created. With last release, integration with Kafka was added that can help.
  • Managing large workloads (concurrent queries) is a bit challenging.
  • Having a way to provide an estimate on the duration for currently executing queries / etc. can be helpful. Vertica provides some counters for the query execution engine that are helpful but some may find confusing.
  • Unloading data over JDBC is very slow. We've had to come up with alternatives based on vsql, etc. Not a very clean, official on how to unload data.
Traian Antonescu | TrustRadius Reviewer

Support

Teradata Data Warehouse Appliance

No score
No answers yet
No answers on this topic

Vertica

Vertica 7.0
Based on 1 answer
HP/Micro Focus Vertica support is in par with other bigger vendors. In addition to this, there is enough best practices documentation available for some of the most common ways you will use Vertica that makes it easy to get Vertica up and running.
Anonymous | TrustRadius Reviewer

Alternatives Considered

Teradata Data Warehouse Appliance

No answers on this topic

Vertica

Presto would be a good solution that would be less expensive and would also allow direct querying of all our data on Hadoop while maintaining good speed.
Anonymous | TrustRadius Reviewer

Return on Investment

Teradata Data Warehouse Appliance

  • Enabled next-day reporting.
  • Better customer service as field technicians can see instant performance.
  • Needed to hire more employees for overnight support.
Anonymous | TrustRadius Reviewer

Vertica

  • For our internal business we have insights we could never have had without Vertica. We can actually see where our money is coming from and point our marketing and sales strategies in the correct direction thereby returning far more than we pay.
  • For our customers we can offer services they had been begging for. Before implementing Vertica we had no insight on a client's marketing across all their activities because the data was just too large. Now, there is no question we can't answer.
Eva Donaldson | TrustRadius Reviewer

Pricing Details

Teradata Data Warehouse Appliance

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Vertica

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Add comparison