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 initial setup was straightforward."
"The key advantages are Performance when processing Terabytes of data and scalability."
"It handles large amounts of information with a linear performance increase, in relation to a HW investment."
"Teradata's capabilities enhance data management efficiency, support scalability, and contribute to faster query performance."
"Cuts time to process huge amounts of data with efficient analytical queries."
"Parallel processing features have helped to easily dump any size of data and retrieve data with great performance."
"Teradata is a great, industry-leading data warehousing product that has MPP architecture."
"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."
"I have found the solution to be scalable."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"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."
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
"Vertica is easy to use and provides really high performance, stability, and scalability."
"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."
"Its projections and encoding are excellent tools for tuning large volumes."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"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."
"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 user interface needs to be improved."
"Data ingestion is done via external utilities and not by the query language itself. It would be more convenient to have that functionality within its SQL dialect."
"The following could be better: licensing, architecture openness, integration with other tools."
"There is some improvement required on OLTP level and some analytical function is missing."
"The SQL Assistant is very basic. This tool can be improved for usability."
"Teradata's UI could be more user-friendly."
"I believe the installation process could be streamlined."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"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."
"There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs."
"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."
"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."
"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 55 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.