Teradata Database

(61)
4.2 out of 5 stars

The Teradata Database easily and efficiently handles complex data requirements and simplifies management of the data warehouse environment.

Work for Teradata Database?

Learning about Teradata?

We can help you find the solution that fits you best.

Find the Right Product

Teradata Database Reviews

Ask Teradata a Question
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • User Industry
Ratings
Company Size
User Role
User Industry
Showing 65 Teradata reviews
LinkedIn Connections
Teradata review by <span>Victor C.</span>
Victor C.
Validated Review
Verified Current User
Review Source

Data "Power" house

Reviewed On
Validated Review
Verified Current User
What do you like best?

> Teradata is one of the most reliable RDBMS platforms available in the market

> Teradata is a power house when it comes to hosting a large data warehouse with greater storage and faster processing power

> Importing and exporting data is super easy with the teradata utilities

> Teradata has a strong admin setup which helps keep your data safe using a sound layer of access control

What do you dislike?

> Teradata can get tangled up in multiple queries running simultaneously and result in a much delayed processing

> I think the UI is still backdated and desperately needs a next gen look and feel

Recommendations to others considering the product

> You should purchase teradata if you are looking for stability, scalability and reliability.

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

> We have a large data warehouse that has been performing great for the past 4 years

> It serves as our organization's data back bone

> We have been able to use teradata to fuel our tableau data extracts and thus use it for data analysis

0 of 0 found this helpful.
Helpful?
Sign in to G2 Crowd to see what your connections have to say about Teradata Database
Headshots
Teradata review by <span>Sandeep T.</span>
Sandeep T.
Validated Review
Verified Current User
Review Source

Easy use software!

Reviewed On
Validated Review
Verified Current User
What do you like best?

Wow! There are so many things.

-> I guess I can start with MPP architecture. Yes, of course other database shave caught up to Teradata with that regard.

-> easy syntax. The syntax of Teradata is clean and pure. It is not as complicated as SQL Server or Oracle.

-> Used extensively for Datawarehousing and Business Intelligence Applications

-> Primary and Secondary Index for Data Storage and Data Retreival

-> Full table scanning is a real possibility in this table, without taking much time.

-> Fastload, Multiload capablities couples with t-pump for near real time operations.

What do you dislike?

Having worked on this database for quite a few years, there is very little that I do not like about this product.

-> The fast load and multiload are currently a set of scripts. If this can be somehow made into a GUI that can enable easier load of data (like the fastload and multiload supported expressions in other ETL tools) it could be useful.

-> May be if at all there was anything to be worked on (like 1/10 chances if any changes would be made), may be the GUI (the visuals) could be made a little more appealing.

Recommendations to others considering the product

Great Product. Depends on the application to be used. If the company needs massive data to be queries and reported on then go for Teradata. If the data volume is not too high this could be a costly expense.

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

I have worked on more than a couple of projects dealing with Teradata Database. The best of the implementations was as a Data Driven Decision making application.

Benefits

-> Can load multiple sources of data

-> Unlike SQL Server or Oracle, there was no need to write PL/SQL. SQL DML was sufficient to suffice the requirement.

0 of 0 found this helpful.
Helpful?

What Relational Databases solution do you use?

Thanks for letting us know!
Teradata review by <span>Dipanwita R.</span>
Dipanwita R.
Validated Review
Verified Current User
Review Source
Validated Review
Verified Current User
What do you like best?

I have used lot many database softwares and Teradata is one of them. This product is also referred to as a "data warehouse system".

I like working with teradata as it provides strong technology solution towards industry data models,data mart consolidation, warehouse migration,hybrid cloud.. and many other features. So much diversified and fits for small and big corporation.

What do you dislike?

I so far enjoyed working with this system. I did not find much negative points but listing some here which I faced while working with it:

1. The names of Teradata columns cannot exceed 30 characters.

2. When writing to Teradata, the InfoSphere DataStage column definitions should not contain fields of the following types like:

BigInt (int64)

Unsigned integer of any size

String, fixed- or variable-length, longer than 32 KB

Raw, fixed- or variable-length, longer than 32 KB

vectors

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

Get a 360-degree view of customer characteristics, with discovery from multiple new sources: social media, sensors in products, web site,customer purchase and phone interaction data.

Used teradata for data analysis and reporting to. Currently using it to analysis company sales and demand report.

0 of 0 found this helpful.
Helpful?
Teradata review by <span>Haresh S.</span>
Haresh S.
Validated Review
Review Source

Query history database-tracking past data

Reviewed On
Validated Review
What do you like best?

The sql assistant in this web edition is absolutely classy and helps us to keep track of the historical queries and also modify the data at once without having to lookup the old ones and also give insights on data analytics ,transaction processing and hybrid cloud services at once

What do you dislike?

Some syntaxes are more different than normal and conventional SQL and need expertise as we cannot skew the database to industrial needs and correlations are quite outdated

Recommendations to others considering the product

Has unique feel and also new template features

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

As in the banking and automotive field we would prefer data analytics OLTP/OLAP data warehouse architecture oriented database and this solves the needs pretty much most of the times

0 of 0 found this helpful.
Helpful?
Teradata review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Review Source

Teradata - DataWarehouse

Reviewed On
Validated Reviewer
What do you like best?

Teradata is a very good product used for handling the huge volume of data and it used in our enterprise for EDW (Enterprise data warehouse) for storing all Claims/Member pieces of information. Teradata is used

to process the data and get the data at the same time which is nothing but parallel processing. As well we can get stored more than 1000TB at the same time. This is mostly used for enterprisewide applications to get the archival and data stored at all the times.

What do you dislike?

Since teradata is ued for Datawarehouses it cant be used for smaller application in size because the installation cost is more for initial level. As well this is having volatile concept of strig the intermediate data where normal SQL

developers cant write the code as such for query or data processing, This requires sort of coding langaugae to get the data retrieved.

As well parallel processing makes the system slower in level.

Recommendations to others considering the product

1. Datawarehouse 2. Archival Storage of Data 3. Big Data

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

1. Enterprise Data ware house data storage 2. Archival of Claims/Member information about 10 years in storage level. 3. Volatile level of handling the data.

0 of 0 found this helpful.
Helpful?
Teradata review by <span>Wendy G.</span>
Wendy G.
Validated Review
Review Source

Teradata Solid data base

Reviewed On
Validated Review
What do you like best?

I also like the query history b/c during data analysis, you run a ton of queries and don't yet know which ones are meaningful enough to actually save. I like the community support - when i can't remember syntax - google has the answer.

What do you dislike?

TD has a descent console.not as user friendly as SQL server but i don't have specifics off the top of my head.

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

i am a data visualization developer. Tools like terdata and SQL server are imperative to visualizing data. It's helpful to aggregate data for faster data loads. It's great for data analysis.

0 of 0 found this helpful.
Helpful?
Kate avatar
Kate from G2 Crowd

Learning about Teradata Database?

I can help.
* We monitor all Teradata Database reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.