Teradata VantageCloud (SaaS)
TeradataExternal reviews
341 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Best tool for ETL pipelines
What do you like best about the product?
We could do various extract transformation and loading process with this tool. Very helpful and easy to learn.
What do you dislike about the product?
Needs to make it more dynamic. And it should support other dynamic variable thing.
What problems is the product solving and how is that benefiting you?
Yes not just me it is benefiting our organization as well. Saves a lot of cost and man power.
Best data Warehousing tool
What do you like best about the product?
The best part about teradata is that i can easily play with larger datasets
What do you dislike about the product?
There is nothing to dislike the tool does its job perfectly and i am very much satisfied with it
What problems is the product solving and how is that benefiting you?
I have been using this with AWS and the tools is awesome
This tools has been helping in managing operations and security.
This tools has been helping in managing operations and security.
Great Product & Services
What do you like best about the product?
It enables people with complex problems to analyse effectively which is highly scalable and solve problems with its multi-cloud data platform and it supports hybrid environments.
What do you dislike about the product?
Teradata vantage is harder to use than it's alernatives
What problems is the product solving and how is that benefiting you?
Data Management and Analytics
i am using teradata for connect multi cloud
What do you like best about the product?
easy to integration , Ease of implementation
What do you dislike about the product?
which iservices i am using. i am fully satidfied with teradata.
What problems is the product solving and how is that benefiting you?
by using teradata i have integarte my all clouds to my dataware house
Teradata Vantage provides strong analytical capabilities for structured data that offers performence
What do you like best about the product?
it is good for data warehouse as we are using it in our organization its ease of use for RDMS.
What do you dislike about the product?
not such any of now keep it up for your future success.
What problems is the product solving and how is that benefiting you?
we have trading application it is use to trade scrips for exchanges NSE,BSE.
Experienced Advanced Analytics Platform with a touch of AI and ML
What do you like best about the product?
Teradata vantage is a very good & advanced tool for making analytics reports & refining data from data warehouse,lakes & repositories. It is a highly scalable & securable solution that integrates wide range of technologies & one can experience advanced analytics with a blend of AI,ML & other business intelligence & data visualization tools. What I liked the most are its flexibility feature we can deploy it in any mode whether it's on premises , on cloud or even in hybrid mode. I use this tool frequently to make data analysis more understanding & demanding in today's business scenarios.
What do you dislike about the product?
Its not so ease Implementing & maintenance cost is quite high according to some SMEs or not so big organisations. Also it is a difficult to manage due to its technical complexities and one may can experience struggle while leveraging this tool. Its lock in feature also made it less used tool in small & medium enterprises. High need of resources for running workloads over this analytical tool is also we can considered as a negative point.
What problems is the product solving and how is that benefiting you?
Teradata helps in maintaing scalability & its flexible deployment in all mode make it easy to understand.Its Advanced analytics capacity to refine data from warehouse or any other repositories without making much efforts are quite impressive. With the use of this tool now I'm able to integrate comprehensive data from multiple data sources. It also helps in data optimization & hence improving & solving Big data analytics & complex queries. It directly contributes in driving business innovation.
Fisrt Impression of Teradata Vantage
What do you like best about the product?
Its computing capacity and pricing. It can efficiently manages all the resources and we easily deploy our models here.
What do you dislike about the product?
It UI isn't much attractive. As compare to others less no of resources available.
What problems is the product solving and how is that benefiting you?
I want to deploy my recommendation models and I can easily deploy my model using NCF which is neural network and requires high computational power.
Excellent
What do you like best about the product?
This is useful for any industry be it large or small.
What do you dislike about the product?
I dont dislike anything about teradata vantage
What problems is the product solving and how is that benefiting you?
Can handle huge data sets without any discrepancies and cery effective as well
Needs improvement in its stability, support and pricing
What is our primary use case?
What is most valuable?
It's very mature from as technology perspective.
What needs improvement?
The solution overall needs improvement in its stability, support and pricing.
For how long have I used the solution?
I have been using Teradata for 23 years.
What do I think about the stability of the solution?
The stability is bad.
What do I think about the scalability of the solution?
Two clients are using the solution.
How was the initial setup?
The initial setup is straightforward.
What other advice do I have?
Overall, I rate the solution a one out of ten.
Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities
What is our primary use case?
The use cases vary based on the projects. In most projects, I worked with ETL tools like Informatica alongside Teradata. However, there was a specific project where we built a real-time data warehouse for active directory data using Teradata.
Oracle was the source system, with potential additional sources feeding into the Oracle database. We used Unix scripting to extract data from Oracle and leverage a colleague's expertise in Unix for the Teradata portion.
We wrote ETL queries and performed data profiling before loading the data into the target data warehouse for further processing by other tools.
Our task was to create a data warehouse, an active data warehouse in Teradata.
How has it helped my organization?
We created and constructed the warehouse. We used multiple loading processes like MultiLoad, FastLoad, and Teradata Pump. But those are loading processes, and Teradata is a powerful tool because if we consider older technologies, its architecture with nodes, virtual processes, and nodes is a unique concept.
Later, other technologies like Informatica also adopted the concept of nodes from Informatica PowerCenter version 7.x. Previously, it was a client-server architecture, but later, it changed to the nodes concept. Like, we can have the database available 24/7, 365 days. If one node fails, other nodes can take care of it. Informatica adopted all those concepts when it changed its architecture. Even Oracle databases have since adapted their architecture to them.
However, this particular Teradata company initially started with its own different type of architecture, which major companies later adopted.
It has grown now, but initially, whatever query we sent it would be mapped into a particular component. After that, it goes to the virtual processor and down to the disk, where the actual physical data is loaded.
So, in between, there's a map, which acts like a data dictionary. It also holds information about each piece of data, where it's loaded, and on which particular virtual processor or node the data resides. Because Teradata comes with a four-node architecture, or however many nodes we choose, the cost is determined by that initially. So, what type of data does each and every node hold? It's a shared-no architecture.
So, whatever task is given to a virtual processor it will be processed. If there's a failure, then it will be taken care of by another virtual processor.
Moreover, this solution has impacted the query time and data performance.
In Teradata, there's a lot of joining, partitioning, and indexing of records. There are primary and secondary indexes, hash indexing, and other indexing processes.
To improve query performance, we first analyze the query and tune it. If a join needs a secondary index, which plays a major role in filtering records, we might reconstruct that particular table with the secondary index.
This tuning involves partitioning and indexing. We use these tools and technologies to fine-tune performance.
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. But, these technologies are quite old now.
With newer big data technologies, we've worked with a four-layer architecture, pulling data from Hadoop Lake to Teradata. We configure Teradata with the appropriate hostname and credentials, and use BTEQ queries to load data.
Previously, we converted the data warehouse to a CLD model as per Teradata's standardized procedures, moving from an ETL to an EMT process. This allowed us to perform gap analysis on missing entities based on the model and retrieve them from the source system again. We found Teradata integration straightforward and compatible with other tools.
What is most valuable?
What needs improvement?
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.
For how long have I used the solution?
I have been using this solution for seven years.
How are customer service and support?
Teradata's technical support is responsive. Although I haven't directly interacted with them, my colleagues at Captivine have.
They've efficiently resolved queries, adhering to SLAs, often within two to three days, even with time zone differences between India and the US. This quick turnaround is especially crucial for client or production issues that require urgent attention.
We didn't frequently encounter issues with Teradata because the tools are robust and well-documented. Teradata provides comprehensive documentation and resources with the purchase of a license, aiding our day-to-day operations.
There was one exception case, but overall, we managed well with the resources provided by Teradata.
How would you rate customer service and support?
Neutral
Which solution did I use previously and why did I switch?
Currently, I work closely with the AI and ML team, focusing on frameworks like NumPy.
At my company, we use Snowflake as a data warehouse. I primarily worked on the ETL side, ensuring data accuracy, governance, modeling, and loading data into the Snowflake warehouse. But it was part of a particular project.
I've also used Oracle as a source and target, as well as SQL Server. In my experience at Capgemini North America, most clients like Elkhared, Levi's, General Electric, etc., used Teradata as their primary database.
While the architecture has evolved with new technologies, Teradata remains a powerful tool.
What's my experience with pricing, setup cost, and licensing?
Teradata is an expensive tool.
Teradata, along with Informatica, is expensive. Teradata is still widely used in the Middle East, especially in banks across Dubai and Saudi Arabia, indicating its continued relevance. Compared to open-source solutions and other market offerings, Teradata remains on the higher end of the pricing spectrum.
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.
What other advice do I have?
Considering its strength in data warehouse technology, I'd rate it between a nine out of ten. For data warehousing specifically, it has a lot of built-in components that can handle various requirements.
However, there's also big data technology to consider these days. But for a traditional data warehouse environment, Teradata is a very successful solution, a very good database, actually.
showing 81 - 90