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."Building a data warehouse with Teradata has definitely helped a lot of our downstream applications to more easily access information."
"We really enjoy the FastLoad, TPump, and MultiLoad features."
"The initial setup was straightforward."
"Teradata's best feature is its speed with historical data."
"I found all parts --loading, transformation, processing & querying work in parallel, and end-to-end-- to be valuable."
"Teradata can be deployed on-premise, on the cloud, or in a virtual machine, which means customers can move without having to create their architecture all over again."
"Teradata's most valuable feature is that it's easy to use."
"The key advantages are Performance when processing Terabytes of data and scalability."
"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."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"It has improved my organization's functionality and performance."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
"Allows us to take volumes and process them at a very high speed."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"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."
"The Vertica architecture means it can process/ingest data in parallel to reporting and analyzing because of its in-memory Write-Optimized Storage sitting alongside the analytics optimized Read-Optimized Storage."
"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."
"Teradata is an old data warehouse, and they're not improving in terms of new, innovative features."
"It needs a teaching web site with more training on third-party tools used for BI."
"Teradata needs to pay attention to the cloud-based solution to make sure it runs smoothly."
"Teradata hardly supports unstructured data or semi-structured data"
"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."
"I would like to see more integration with many different types of data."
"The setup is not straightforward."
"Vertica seems to scale well, except for one use case where you are on a multi-node cluster. For example, if you had a nine-node cluster, one node goes down, then the eight nodes don't scale, because the absence of the node is very apparent, which is a problem. If you have nine nodes or multiple nodes, the whole idea is that if one of those nodes goes down, then you should not see an impact on the system if you have enough capacity. Even though we have enough capacity, you can still see the impact of the one node going down."
"They could improve the integration and some of the features in the cloud version."
"It needs integration with multiple clouds."
"We faced some challenges when trying to use the temporary tables feature."
"The integration with AI has room for improvement."
"I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
Teradata is ranked 3rd in Data Warehouse with 54 reviews while Vertica is ranked 4th in Data Warehouse with 82 reviews. Teradata is rated 8.2, while Vertica is rated 8.4. 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.