Teradata Vantage

What do you like best?

The best thing is Teradata Vantage is to work with the Teradata SQL Engine itself. This MPP DBMS allows to process a huge amount of data with great perfomance since it works by the concept of nodes (amps), being scalable and offering great reliability about data recovering, massive processing managing, data backup etc. It's much faster and convenient to develop ETL process inside Teradata since it is designed to work effectively with no need to many subqueries as in other SQL DBMS. Plus, the Teradata Vantage integrates Python, R and other tools that allows to work and develop complex Data Science wise processes (Machine Learning, AI, Analytics etc). As Teradata Engine can manage very well all the running processes, hardly developers will need to keep bothering the DBA asking to kill orphan processes so he can focus in what's really important for the business.

What do you dislike?

In terms of the Teradata SQL Engine, I would say that could be a problem for some people used to work with conventional DBMS to learn how Teradata works. There are many different concepts such as Primary Index, Secondary Index, Partitioned Primary Index, Join Index etc which are essentials to be well understood, applied and designed to obtain best results on performance and usability. I believe Teradata products tends to be way more expensive than any other else big brand even though being justified for the amazing quality.

What problems are you solving with the product? What benefits have you realized?

Teradata Vantage is a good choice for everyone who wants to explore and maximize the development of advanced analytics and data processing processes. When you have a well defined architecture of development, it tends to be very fast to develop jobs and solve business problems. You will not spend your time on silliness, you can really focus your energy on what is important for your business.