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."Cuts time to process huge amounts of data with efficient analytical queries."
"The most valuable features are the Shared-nothing architecture and data protection functionality."
"We really enjoy the FastLoad, TPump, and MultiLoad features."
"I've never had any issues with scalability."
"The solution scales well on the cloud."
"The most valuable features are the large volume of data and the structuring of the data to optimize it and get very optimal data warehouse solutions for customers."
"Things have started moving faster in my company, such as data retrieval happens more quickly."
"Viewpoint, the detailed query logs and performance statistics are valuable features."
"The extensibility and efficiency provided by their C++ SDK."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"Vertica is a great product because customers can compress and code data. The infrastructure that data warehouse solutions need is a commodity server so that customers don't have to invest in infrastructure."
"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."
"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."
"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."
"It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands."
"Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation."
"The setup is not straightforward."
"The cloud is the new challenge and the new opportunity."
"I've been using the same UI for 20 years in Teradata. It could use some updating. Adding more stability around Teradata Studio would be outstanding. Teradata Studio is a Java-based version of their tool. It's much better now, but it still has some room for improvement."
"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."
"Apart from Control-M, it would be nice if it could integrate with other tools."
"There is a need to improve performance in high transaction processes, as well as the reporting system."
"The following could be better: licensing, architecture openness, integration with other tools."
"The solution needs improvement in its stability, support and pricing."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"They could improve the integration and some of the features in the cloud version."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"It would be great if this were a managed service in AWS."
"Support is an area where it could get better."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"We faced some challenges when trying to use the temporary tables feature."
"The biggest problem is the cost of cloud deployment."
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, 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.