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."Designing the database is easy."
"It is a stable program."
"The feature that we find most valuable is its ability to perform Massive Parallel Processing."
"The key advantages are Performance when processing Terabytes of data and scalability."
"Things have started moving faster in my company, such as data retrieval happens more quickly."
"The most valuable feature of Teradata is security. It runs on Unix and Linux platforms which provide better security."
"I found all parts --loading, transformation, processing & querying work in parallel, and end-to-end-- to be valuable."
"We really enjoy the FastLoad, TPump, and MultiLoad features."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"Allows us to take volumes and process them at a very high speed."
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
"I enjoy the cybersecurity and backup features."
"Vertica is easy to use and provides really high performance, stability, and scalability."
"Eighty percent of the ETL operations have improved since implementing this solution."
"The extensibility and efficiency provided by their C++ SDK."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"The scalability could be better. The on-premises solution is always more complicated to scale."
"The solution is stable. However, there are times when we are using large amounts of data and we can see some latency issues."
"An additional feature I would you like to see included in the next release, is that it needs to be more cloud-friendly."
"The capability to implement it with comparable performance across various private cloud environments, ensuring adaptability to different infrastructure setups would be beneficial."
"We tried to use case Teradata for a data warehouse system, but we had some problems in relation to the Teradata system, CDC tools, and source databases. We were unable to transfer data from HPE Integrity mainframe to Teradata."
"The cloud is the new challenge and the new opportunity."
"The setup is not straightforward."
"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."
"Support is an area where it could get better."
"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."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"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."
"The integration of this solution with ODI could be improved."
"The documentation of Vertica is an area with shortcomings where improvements are required."
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.