Vantage

Pros

Teradata is used or has been used in past by most of the business enterprises.
It processes of large amounts of data with ease.
Easy to navigate and good graphic user interface
Business users can also use it with basic training and query knowledge

Cons

Big data processing is a challenge due to its existing architectures.
The cloud based option needs to be more affordable and at par with other service providers.

Pros

I like the advanced data management features, the artificial intelligence that is on the platform and its ability to manage multiple data

Cons

since I have been using it I have not yet found any complications with the platform

Pros

Basically we have started to using this teradata database version 15.0 in our application. Some of the pros in using the teradata are:

1. Used for large data-sets and for ad-hoc queries.
2. Used for massive parallel processing (MPP) architecture like a single dataset table has been queried by multiple people and handling large volume of millions of rows.
3. It has a capability to expand a single data set in to enterprise wide.
4. It is fast in handling the queries for huge number of rows.
5. Good ROI since handling huge number of rows along with teradata support.

Cons

Since we are having advantages it is also having its own CONS (Disadvantages):

1. Query handling is little tougher which is different from SQL/T-SQL.
2. Price is higher (Huge) for smaller enterprise applications to handle the parallel queries data.
3. Not having its own tools like Oracle, SQL server, Sybase or any other DBMS to export/Import, reporting etc.,. Only third party told which is having OLEDB/ODBC having can be operated.
4. ROI is higher however the initial investment is more and in stable for smaller enterprise applications.
5. Not user friendly like SQL server/Oracle DBMS.

Pros

Teradata has been an extensively powerful database in prcocessing Terabytes of data. Once you configure the tables, partitions and indexes properly it really works excellently. However, there is a lot of effort required from the IT team to make it work perfectly. Its query performance is really high. Teradata Vantage Platform is also having a lot of AI-ML capabilities which can be used, along with virtualization which is important for any Datawarehouse.

Cons

The fact that a lot of effort is required to make the data structures to be performant does not help a lot. A lot of the things should be done behind the screens by the software based on the query patterns. Also, the costing is a little bit more on the higher side.

Pros

Teradata massive parallel processing gives advantage to other database for data integration and analytics. Query and reporting performance differentiate it with other comparable tools. Also, it offers customized SAP integration solutoin which eleiminates a needs for core SAP integration implementation. Teradata TPT and pushdown implemtation used with Informatica eleminates needs for performance tunning manpower and let end user access reports without performance issue.

Cons

The software is bit pricy and companies should move to cloud solutions wherever security is not a concern.

Pros

The best thing about tera data is it’s completely based on shared nothing architecture that means the data are distributed across the AMPS in parallel way.that helps for faster loading the data into the VDISK and also for faster extraction.because all amps have its own vdisk attached with them. One more thing I liked about teradata is the User management and Locking system it’s providing for data security and user authentication.

Cons

Sometimes it’s harder to understand the Locks mechanism and analytical function that are used inside a procedure for new coming user who wants to learn or use teradata. So it is bit complicated to understand someone’s pre written procedure.

Alternatives Considered

Reasons for Switching to Vantage

Pros

Highly scalable
available vast prebuilt functionality like geospatial, json, xml types etc
works well with hundreds terabytes
ANSI SQl standard, available on AWS, Azure cloud.

Cons

cost is more than the other competitive RDBMS products. Teradata PS services are costlier. Teradata provides lots of Teradata specific functionality which other DBMS products may not have it,so migration from Teradata to other RDBMS may be challenging sometimes.

Pros

No database can match Teradata's parallel processing and speed

Cons

It's quite costlier as compared to other tools so that's an issue for companies

Pros

eradata is the professional standard to measure other vendors against. I have not seen other vendors with the same confidence to arrange reference calls with their clients without a moderator in attendance.
It has many features which helps to easily manage the data.

Cons

Putting Teradata in the hands of someone who is not trained can give them a bad experience. It's like giving a car with a manual transmission to someone who's never driven.

Pros

Very fast and huge volume of data can be run very easily and can retrieve quickly

Cons

Installation takes very good amount of time and bit costly

Pros

Highly scalable, lot of functionality available and easy to use
Can maintain petabytes of data
It can easily integrate with the big data systems

Cons

It is costlier and they are many cheaper solutions available to serve the same purpose

Pros

This software can do everything you need if you are proficient with big data and SQL. I can export large datasets from a server quickly and with delimiter for easy importing.

Cons

This is NOT a point and click data management tool. If you are working with large data you'll need to have experience and understanding with SQL or you will not be successful with Teradata. There are other point and click data bases that are easier.

Pros

I used Teradata extensively at my last company, and I really miss it. The user interface was simple and efficient. Importing data was easy, and query results came quickly provided that users wrote efficiently.

Cons

The only con I can think of has more to do with the occasional differences between Teradata SQL and MySQL, but that is rare, and not really the fault of the software.

Pros

Parallel processing was the key to this database leading it to be a good choice for analysis and reporting in on-premise data sources.

Cons

This product is expensive for storage and computation especially when compared to the cloud capabilites.

Pros

It’s intuitive so when you’re entering in a query, it will color code the commands so you know you’re on the right track. It saves a record of your queries so you can go back to review. I have next to no experience with SQL, but it’s a large component of a new position and teradata makes it somewhat easy to navigate.

Cons

Navigating the data tree in the leftmost column is somewhat confusing. This is not a program you learn by using. It definitely helps to have someone who knows the program walk you through it.

Pros

Good tool for hospital board members to access private, secure information for board meeting. Easy to use and access.

Cons

I have not experienced any difficulties.

Cons

Projects in which we need to use Teradata often take months longer than others. Things get lost in the system, mismanaged and everyone ends up confused and frustrated. We only use it because our compliance area requires it.

Pros

Intuitive interface and easy to use in certain aspects however, with many functionalities that take time to understand

Cons

Could be more feature rich for big data usage scenario

Pros

Teradata store tons and tons of data and is a scalable relational source. It also has a huge help online.

Cons

Connection and queries take a significant amount of time. Errors are not intuitive many a times and have to be deciphered.

Pros

GUI which is very imp. And database fetching records.

Cons

Software wise its good, but need to have more good support.

Pros

cloud and hardware data warehousing are the best services that one can make us eof from this tool. Paralllel processing makes it ver fast and deliver results in short time.

Cons

The hybrid architecture is not that effective and can be make simple to make better use of normal simple design .

Pros

Teradata has huge amounts of support for SQL and is faster than alternatives when retrieving and storing data. No slowdowns at all.

Cons

Teradata is generally more limited and is harder to use than competitors, most notably Oracle. Onboarding process could use a bit of work as well.

Pros

This tool allow to look at the past queries which we have used, so that we can keep a track of them. Also it provides very strong analysis power on the data. It allows to work on huge amount of data in terabytes at same time which is very strong advantage.

Cons

Mostly dependent on java. And console is not very user friendly. Since it works on NOSQL, the ease of usage that we have in RDBMS is missing.