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."The feature that we find most valuable is its ability to perform Massive Parallel Processing."
"The flexibility in design is very good."
"Teradata has good performance, the response times are very fast. Overall the solution is easy to use. When we do the transformation, we have all of our staging and aggregation data available."
"Things have started moving faster in my company, such as data retrieval happens more quickly."
"It has massive parallel processing ability to do large amounts of concurrent querying."
"Building a data warehouse with Teradata has definitely helped a lot of our downstream applications to more easily access information."
"Auto-partitioning and indexing, and resource allocation on the fly are key features."
"Teradata's best feature is its speed with historical data."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"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."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"I enjoy the cybersecurity and backup features."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"Teradata hardly supports unstructured data or semi-structured data"
"The cloud is the new challenge and the new opportunity."
"GUI of administrative tools is really outdated."
"Needs compatibility with more Big Data platforms."
"Teradata is an expensive tool. Like, if you're already using Microsoft products like Windows, they'll market all their products together. And with the rise of cloud technologies, companies will adopt solutions that offer them some privileges or facilities. Similar to how SAP does it in the market, so do Microsoft and other companies. Even Oracle and other such tools are quite commonly seen compared to Teradata's competitors in everyday solutions."
"Teradata needs to expand the kind of training that's available to customers. Teradata only offers training directly and doesn't delegate to any third-party companies. As a result, it's harder to find people trained on Teradata in our market relative to Oracle."
"Teradata is a bit late for the cloud."
"I'm not sure about the unstructured data management capabilities. It could be improved."
"I believe the installation process could be streamlined."
"It needs integration with multiple clouds."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"We faced some challenges when trying to use the temporary tables feature."
"They could improve the integration and some of the features in the cloud version."
"The integration with AI has room for improvement."
"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."
"Limitations in group by projections is where I would like to see an improvement."
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 Oracle Database, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, BigQuery and Oracle Exadata. 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.