Vantage Pricing, Features, Reviews and Alternatives

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

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.

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.

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

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.

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.

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.

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.

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.

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.