We performed a comparison between Teradata, TIBCO Live Datamart, and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."We really enjoy the FastLoad, TPump, and MultiLoad features."
"I like this solution's ease of design and the fact that its performance is quite good. It is stable as well."
"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."
"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."
"The initial setup was straightforward."
"Designing the database is easy."
"It is a solid database a lot of different tools to move data."
"There are several features of Teradata that I like. One of the most basic is the indexes. I also like that it provides lower TCO. It also has the optimizer feature which is a good feature and isn't found in other legacy systems. Parallelism is also another feature I like in Teradata because when you are running or hosting on multiple systems, you have this shared-nothing architecture that helps. Loading and unloading in Teradata are also really helpful compared to other systems."
"You can create your own rules that include mathematic calculations."
"The solution has a powerful aggregating feature"
"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."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"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."
"I like the projection feature, which increases query performance."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"The product's initial setup phase is extremely simple."
"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."
"Allows us to take volumes and process them at a very high speed."
"Since I was working on the very basic, legacy systems, the memory thing was always a challenge. If Teradata is moving to the cloud, the space constraint or the memory issue that my company generally faces will eventually resolve, in time. What I'd like to see in the next release of Teradata is that it becomes full-fledged on the cloud, apart from better connectivity to various systems. For example, if I have to read or include a Python script, if I write some basic codes, I should be able to read even unstructured data. I know that it's not supported even in Snowflake, but at least semi-structured data support, if that can be a little more enhanced, that would be good."
"The capability to implement it with comparable performance across various private cloud environments, ensuring adaptability to different infrastructure setups would be beneficial."
"An additional feature I would you like to see included in the next release, is that it needs to be more cloud-friendly."
"I would like to see more integration with many different types of data."
"Apart from Control-M, it would be nice if it could integrate with other tools."
"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."
"It would help to make scaling easier with a reduced cost. "
"It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."
"The solution's setup could be quicker and easier."
"Improvements need to be made on the load balancing side."
"It would be great if this were a managed service in AWS."
"The biggest problem is the cost of cloud deployment."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"We faced some challenges when trying to use the temporary tables feature."
"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."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."
"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."