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."It effectively has allowed us to remove over 20 portion copies of the data sets on other DB platforms for real-time operational reporting purposes."
"When it comes to integration, tools like Informatica seamlessly connect with Teradata. We ensure the Teradata database is configured correctly in Informatica, including the proper hostname and properties for the load process. We didn't find any major complexity or issues with integration."
"The two types of partitioning have been very significant for us - row and columnar partitioning."
"Teradata is a great, industry-leading data warehousing product that has MPP architecture."
"Their extensive experience in data warehousing, the platform's performance, and their strong reputation in the market are the most valuable."
"A conventional and easily defined way to build a data warehouse or a layer of data marts."
"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."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"The extensibility and efficiency provided by their C++ SDK."
"The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"Vertica is easy to use and provides really high performance, stability, and scalability."
"The solution is quick, has good compression data, and is not expensive."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"The most valuable feature of Vertica is the unmatchable database performance."
"Its analytics has enabled Pythian's clients to get the business insights as quick as they wanted. Its lower maintenance has also improved the ROI."
"Data synchronization to the DR site."
"It needs a teaching web site with more training on third-party tools used for BI."
"Teradata is a bit late for the cloud."
"I would like to see an improved Knowledge Base on the web."
"Teradata's UI could be more user-friendly."
"The current operational approach needs 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."
"Teradata needs to pay attention to the cloud-based solution to make sure it runs smoothly."
"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."
"It needs integration with multiple clouds."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"Very bad support, I would rate it two out of 10."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"Limitations in group by projections is where I would like to see an improvement."
"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.