We performed a comparison between Teradata and Vertica based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It effectively has allowed us to remove over 20 portion copies of the data sets on other DB platforms for real-time operational reporting purposes."
"The most valuable features are the Shared-nothing architecture and data protection functionality."
"The functionality of the solution is excellent."
"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."
"The most valuable features of Teradata are that it is a massively parallel platform and I can receive a lot of data and get the queries out correctly, especially if it's been appropriately designed. The native features make it very suitable for multiple large data tasks in a structured data environment. Additionally, the automation is very good."
"It's a pre-configured appliance that requires very little in terms of setting-up."
"The initial setup was straightforward."
"It has reduced a lot of reworking on maintaining indexes, partitions, etc."
"The product's initial setup phase is extremely simple."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"I like the projection feature, which increases query performance."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"Its analytics has enabled Pythian's clients to get the business insights as quick as they wanted. Its lower maintenance has also improved the ROI."
"The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money."
"I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data."
"Teradata hardly supports unstructured data or semi-structured data"
"Teradata's UI could be improved."
"Apart from Control-M, it would be nice if it could integrate with other tools."
"The solution could improve by having a cloud version or a cloud component. We have to use other solutions, such as Amazon AWS, Microsoft Azure, or Snowflake for the cloud."
"It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."
"I think the UI is not there yet. It could be improved by being more user-friendly."
"The following could be better: licensing, architecture openness, integration with other tools."
"Limited interest and success in some areas make us hesitate about upgrading."
"The integration of this solution with ODI could be improved."
"They could improve on customer service."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"Documentation has become much better, but can always use some improvement."
"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."
"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."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
Teradata is ranked 3rd in Data Warehouse with 54 reviews while Vertica is ranked 4th in Data Warehouse with 83 reviews. Teradata is rated 8.2, while Vertica is rated 8.2. The top reviewer of Teradata writes "Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". Teradata is most compared with SQL Server, Snowflake, Oracle Exadata, MySQL and IBM Db2 Database, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Oracle Exadata and BigQuery. See our Teradata vs. Vertica report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all Data Warehouse 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.