Teradata Database

4.2
(77)

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.

Teradata Database Reviews

Ask Teradata a Question
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
Ratings
Company Size
User Role
Industry
Showing 81 Teradata reviews
LinkedIn Connections
Teradata review by ABHISHEK K.
ABHISHEK K.
Validated Reviewer
Verified Current User
Review Source

"Database every oraganisation should have "

What do you like best?

this is highly scable and have vast pre-built functionality like JSON etc which make is super power database and you can easily do enterprise dataware housing model in this database which is key for it success and it is really good in terms of usage as you can generate different views per application for usage

What do you dislike?

cost is too hight compare to other RDBMS database which is key for any small organisation as big organisation can still afford it but small once cannot. Also migration is bit painful from Teradata to other RDBMS products currently in markey

Recommendations to others considering the product

This is inhouse enterprise dataware house for all the applications and backend utility to resolve all the problems frontend is dealing with as it captures all the backend information and data . this is highly scable and have vast pre-built functionality like JSON etc which make is super power database and you can easily do enterprise dataware housing model in this database which is key

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

This is inhouse enterprise dataware house for all the applications and backend utility to resolve all the problems frontend is dealing with as it captures all the backend information and data . this is highly scable and have vast pre-built functionality like JSON etc which make is super power database and you can easily do enterprise dataware housing model in this database which is key . Also for applications like middleware there is no place better than teradata to store the domain data which works really well with this product

Sign in to G2 Crowd to see what your connections have to say about Teradata Database
Teradata review by Victor C.
Victor C.
Validated Reviewer
Verified Current User
Review Source

"Data "Power" house"

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

What Relational Databases solution do you use?

Thanks for letting us know!
Teradata review by Sandeep T.
Sandeep T.
Validated Reviewer
Verified Current User
Review Source

"Easy use software!"

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.

Teradata review by Dipanwita R.
Dipanwita R.
Validated Reviewer
Verified Current User
Review Source

"Strong and powerful database for data analysis"

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.

Teradata review by Haresh S.
Haresh S.
Validated Reviewer
Review Source

"Query history database-tracking past data"

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

Teradata review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Review Source

"Teradata - DataWarehouse "

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.

Teradata review by Wendy G.
Wendy G.
Validated Reviewer
Review Source

"Teradata Solid data base"

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.

Teradata review by User in Internet
User in Internet
Validated Reviewer
Verified Current User
Review Source

"Big data simplified - Teradata"

What do you like best?

Teradata is the tool to use when you have very huge databases to query. We were handling the largest retail data in the world and were facing issues in querying from this data. With teradata, we could query in SQL and get tome to time reports.

One more important thing is the data is well indexed which makes querying much faster.

What do you dislike?

One major lacking is not being able to build complex models without having to query a lot. Most other systems started having this feature, Teradata needs to improve in this aspect. Also, small organisations cannot afford something like this - only those with deep pockets where querying TBs of data makes business impact, will have a positive impact.

Recommendations to others considering the product

Definitely a go for companies wanting to make sense out of their of big data,

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

We are a bit retailer, with multiple stores across various geographies. To track metrics for this kind of data could not have been possible if not for teradata.

Teradata review by Michelle G.
Michelle G.
Validated Reviewer
Verified Current User
Review Source

"Teradata GSK use"

What do you like best?

Teradata is useful for viewing large SAS datasets without opening SAS. It also has a better interface than SAS Universal Viewer.

What do you dislike?

Changing the windows in Teradata Studio is not as intuitive as it could be.

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

We are looking through real world databases like electronic medical records to find target populations for new drugs.

Teradata review by Jamie O.
Jamie O.
Validated Reviewer
Review Source

"Security is the number one priority"

What do you like best?

Great partner, and open to creative funding model. Security is the number one priority for Teradata IntelliCloud™ services, and that’s why they deliver across-the-board support for every facet of cloud security.

What do you dislike?

The system is very stable but is not very agile and can't provide the performance we need at the cost we desire in order to serve our goal of providing real-time analytics/BI against billions of rows of data.

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

The vendor has been extremely agile and involved in suggested improvements for performance and scalability.

Teradata review by Lemmon M.
Lemmon M.
Validated Reviewer
Review Source

"Easy to use Tool for querying large data from multiple databases"

What do you like best?

Connect to multiple databases and the answerset output

What do you dislike?

No SQL so not as fluent as Microsoft Sql

Recommendations to others considering the product

Great tool to use for Big Data. The Answerset is very helpful for formatting your data before exporting to excel or similar tool. However it take some time to get familiar with if you are used to other tools such as Sql Server Management Studio.

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

Just querying data and joining across multiple database makes it easier to get solid datasets

Teradata review by Greg A.
Greg A.
Validated Reviewer
Verified Current User
Review Source

"Teradata is a powerful database for high-volume processing"

What do you like best?

Teradata can manage large data sets with high efficiency and impressive speed, as long as the SQL is properly tuned (which is true of any DBMS tool)

What do you dislike?

The dependence on Java sometimes causes my Teradata Studio software to hang.

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

I process large data sets for Business Intelligence visualization.

Teradata review by User in Financial Services
User in Financial Services
Validated Reviewer
Review Source

"We use Teradata as our EDW for storing massive amounts of data and performing complex analytics. "

What do you like best?

The best feature about Teradata database is it’s massively parallel architecture, high scalability, high availability and high performance allowing the end users to store, retrieve and access data at any point of time with fault tolerance capability.

What do you dislike?

Teradata is not that efficient for OLTP based systems.Also I dislike the fact that it’s bit expensive for smaller customers and the price of a single Teradata node is on higher side as compared to other RDBMS’s available in the market.Lastly Teradata performs less marketing about it as compared to other databases and still needs to penetrate into the market.

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

We use Teradata for storage, building data marts and performing data analytics for driving better business decisions and improving our business.

Teradata review by User in Internet
User in Internet
Validated Reviewer
Verified Current User
Review Source

"Extremely slow and overpriced database"

What do you like best?

I don't think Teradata has any appealing feature. INstead every little thing about it makes me hate it.

What do you dislike?

The queries take too long. The client they offer - Teradata Studio Express - is extremely slow and unstable. Sometimes it works, sometimes it doesn't.

Recommendations to others considering the product

Do not use this product, you're better off using a better database.

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

I think our company started using Teradata to make database actions faster. But with time, it actually became slower than Oracle DB.

Teradata review by Grey P.
Grey P.
Validated Reviewer
Verified Current User
Review Source

"Teradata"

What do you like best?

Excellent as this IS Tools Specialized data storage and business analytics tools

What do you dislike?

all ok .. nothing I dislike this app because apart from all motor has a relational database oriented processing large volumes of data

Recommendations to others considering the product

100 % recommended to all my colleagues and friends who want a fast tool when managing their databases

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

many benefits as it helps me to process large catidad of information contained in the databases of my company

Teradata review by Anu B.
Anu B.
Validated Reviewer
Review Source

"Fastest analytic tool"

What do you like best?

It is high performance database management tool, quickly retrieve data for complex query and not expensive. On top of it, it has multiple other functionalities too like query builder support, in memory optimization and it can also work with various Etl tools.

What do you dislike?

There is nothing to dislike about this product.

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

I have used it with etl tool to extract data for my business It works in very secure, fast and efficient way.

Teradata review by User in Hospital & Health Care
User in Hospital & Health Care
Validated Reviewer
Verified Current User
Review Source

"Useful But Not for Amateur Users"

What do you like best?

The error messages give you obvious feedback on lines that need to be changed in order to make your query run.

What do you dislike?

This is a heavy manual use application. There are no wizards that walk you through selecting data elements from various tables. You have to know exactly what you need and where it is sourced from in order to write an efficient query.

Recommendations to others considering the product

I recommend purchasing a supplemental software that is more of a plug-and-play or wizard based application, as it may be more user friendly than working with Teradata directly.

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

It is helpful for pulling data quickly to do on-the-spot trending and pull dollar figures associated with certain criteria.

Teradata review by Administrator in Internet
Administrator in Internet
Validated Reviewer
Review Source

"Enterprise Datawarehouse Senior Database Administrator "

What do you like best?

The best feature about Teradata database is that it is massively parallel processing system with high scalability, high availability and high performance providing the businesses to perform complex analytics and analysis thereby allowing businesses to make better decisions and earning more revenue.

What do you dislike?

I dislike the fact that the cost of installation of a single Teradata node is very expensive as compared to other relational database management systems available in market.

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

We use Teradata to store our massive amount of data, building semantic data marts for serving our end users and for performing complex analytics to drive our business and earn large revenue.

Teradata review by Agency in Information Technology and Services
Agency in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"Teradata review "

What do you like best?

Teradata is very reliable software. It manages huge amount of data where line of business can access it and have more security over data

What do you dislike?

Performance compared to other databases Teradata is little bit slow. Many cloud based databases have arrived and beating the performance

Recommendations to others considering the product

It’s reliable

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

Data and information is classified and secured in better way

Teradata review by Brajesh T.
Brajesh T.
Validated Reviewer
Review Source

"Lightning speed database"

What do you like best?

Executing sql queries are way faster compare to oracle, amazing database for analytical queries

What do you dislike?

sometimes database executing plan is weird

Recommendations to others considering the product

Teradata is not cost friendly compared to oracle but with high data volume, scalability & speed, TD is way better than oracle

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

Teradata database works as enterprise datawarehousing for our enterprise, it's realible

Teradata review by Asim Kumar K.
Asim Kumar K.
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"I am working with Teradata since last 8 years. "

What do you like best?

We often say Teradata is costly, but the all the good things come with some price. When you have data in TB then no one can beat Teradata in performance. Now Haddop has come to world but still people like to have their MARTS build in Teradata. The utilities, the work load managements and are awesome. I have seen clients who can not believe the way Teradata has shown performance improvments.

What do you dislike?

Teradata has the capabilty to work with Hadoop with Aster. But they need to think and work more on that. They should find out why clients are not choosing Aster. And more thing I would like to high light is their performance team. These team come up with some guys work with some vendors for performance and to advise on best practice. But I have seen very dumb people in their team. They should not send representative who have very less knowledge on Teradata as a performance improvment team.

Recommendations to others considering the product

They should find out more way to compete with Hadoop. They should make their server more cheap.

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

In my life I have seen several POC against Teradata, like Oracle, Exadata, Haddop.

Trust me all of them have failed. Business reports how much complex it might be, Teradata can handle that.

Teradata review by Shraddha M.
Shraddha M.
Validated Reviewer
Verified Current User
Review Source

"Best Data Warehouse Database Management "

What do you like best?

Teradata is a very efficient MPP system which always outperforms its competition like Netezza , GreenPlum , IBM , Oracle.

It has been a leader in the DWH industry for 25 years.

The company is every growing with acquisitions to expand in the analytics space and Teradata Research comes up with new features every year to enhance their product based on customer feedback.

What do you dislike?

It is difficult to source good TD resources in the market and TD is expensive as a technology.

Recommendations to others considering the product

Great system!

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

I have worked on TD for the last years in various industries and have seen a lot of business value out of the system.

It is an amazing technology and I love working on it.

Teradata review by User in Mechanical or Industrial Engineering
User in Mechanical or Industrial Engineering
Validated Reviewer
Verified Current User
Review Source

"Best data warehouse system present"

What do you like best?

Terracotta helps store enormous amounts of data smoothly and access them remotely without much hassles. We can even choose which set of users need access to what amounts of data.

What do you dislike?

Not friendly for data deep diving and in-depth big data analytics. Alternatives like Hadoop are much cheaper.

Recommendations to others considering the product

Big data stored and read easily - go for it.

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

We were facing issues in smoothly reporting the enormous amount of data generated by our users on a day-to-day basis. With Teradata, we are able to maintain our dashboards up-to-date across various categories and functions.

Teradata review by Sandeep S.
Sandeep S.
Validated Reviewer
Review Source

"Teradata DBA"

What do you like best?

Teradata is a powerful Database which could process millions of records in seconds. The design is so simple compared to other conventional databases. One of the few databases which are using true parallelism for every process/request recieved.

What do you dislike?

Like any other massively parallel system which comes with a big price tag, Teradata is an expensive solution and hence used by very few and rich corporations compared to other conventional database systems.

Recommendations to others considering the product

If you are planning for an EDW system which should process a million records as well as one single record with no much difference in the processing time, Teradata is the system you should look into.

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

We use it for analytical processing, sales trend analysis, cost modeling on each customers. The system is also used by customer facing team to sell products comparing the sale history of the customers via tactical queries.

Teradata review by Paramasivan P.
Paramasivan P.
Validated Reviewer
Review Source

"Best RDBMS"

What do you like best?

Teradata Database is used widely many retail/banking organization. It serves as the data warehouse. It addresses many problems related to large amounts of data.

What do you dislike?

Its not recommended for OLAP operations. Update operations are costly in teradata.

Recommendations to others considering the product

Best RDBMS for any analytical solutions.

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

We are using for building many semantic tables for customer analysis.

Teradata review by David B.
David B.
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Teradata and the power of massive parallel processing"

What do you like best?

This database was the first in the world to effectively process table scan queries with lightening speed due to it's massively parallel, shared nothing architecture! This is what I like the best and it's still one of the fasted database architectures out there.

What do you dislike?

The only thing I wish Teradata would improve (and it's currently being done) is to improve it's own replication software. Until recently, effective replication was only accomplished through the third-party Oracle product called GoldenGate. Teradata Data Mover has it's delays and limitations and was not for "real-time" replication. Teradata's Unity product had it's limitations but they have improved it and I believe they will continue to do so.

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

Currently working on developing effecient, performant methods for row-level security. Investigating the TD 15 row-level security feature.

Teradata review by Apoorva S.
Apoorva S.
Validated Reviewer
Review Source

"Teradata Database Review"

What do you like best?

Ease of using this tool is the best thing.

What do you dislike?

The only thing that I disliked was the hierarchy to be followed to even view a single column.

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

Helping my clients to store, manage and maintain their huge data.

Teradata review by Consultant in Oil & Energy
Consultant in Oil & Energy
Validated Reviewer
Verified Current User
Review Source

"Highly Scalable with massive parallel processing"

What do you like best?

Teradata is highly scalable database with massive parallel processing capability. Teradata has shared nothing architecture providing high level data protection. Ad hoc requests are processed across multiple AMPS and well suited for datawarehousing applications.

What do you dislike?

Teradata database license and hardware is expensive. Not suitable for OLTP system. Partitioned columns has to be part of Primary Index.

Recommendations to others considering the product

Highly recommended for data warehousing application with big data volume.

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

Data warehousing solutions for big data volume.

Teradata review by Riccardo R.
Riccardo R.
Validated Reviewer
Review Source

"client side: to manage db linked with some projects"

What do you like best?

It very useful to use with huge datas. It's fast during execution with the appropriate cursor.

What do you dislike?

Some syntax constructs are hard to use with complex queries.

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

we set up some automatic batch operations, working during the night, to elaborate huge datas on several databases

Teradata review by Andrew R.
Andrew R.
Validated Reviewer
Review Source

"The Best Technology for Data Warehousing "

What do you like best?

Parallel processing, scalability and fault-tolerance is part of its DNA.

When correctly configured it is blindingly fast.

The strategic direction of the Teradata company is tightly focused on Data Analytics.

Teradata has been a key player in database technologies since the early eighties.

The latest advances in Intel chip technology quickly makes it way into the product line.

For such a scalable, flexible system many of its key performance features come as 'out of the box' functionality.

What do you dislike?

Training material is expensive and difficult to obtain - unlike Oracle database technologies.

Recommendations to others considering the product

Has a reputation for being expensive but this has changed since Teradata separated from its NCR parent company. The Market Leader in Data Analytics.

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

Fraud Detection

Tailored Marketing

Financial Decision Analytics

Teradata review by Divija K.
Divija K.
Validated Reviewer
Review Source

"Very competent "

What do you like best?

It was easy to administrator. From number of sessions running, long running queries, locks, it was easy to see this information. All the errors are perfectly logged in TD. The support is amazing, the have the expertise they're quick to respond

What do you dislike?

We had few issues with the data mover, but nothing that couldn't be fixed. Since ours was a production system any issue was a major issue.

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

Our was a data warehouse which housed more 10 yrs of history data. It was used for internal data analysis.

The speed of data processing is very quick in teradata, we had issues regarding reports getting delayed for other databases but with teradata mostly it was always smooth

Teradata review by Doug J.
Doug J.
Validated Reviewer
Review Source

"great software and user friendly"

What do you like best?

This software is great to use. It is very user friendly and easy to use. I have trained many of my colleagues on this platform.

What do you dislike?

I question its scalability. I am not sure it has the potential to scale up very easily.

Recommendations to others considering the product

great product

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

research and analytics

Teradata review by Ankit S.
Ankit S.
Validated Reviewer
Review Source

"Teradata Geek"

What do you like best?

It allows mass of structured data to be queried with great speed

What do you dislike?

Inability to connect with hadoop platform

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

Cross channel customer journey analytics. Allows me to include all data elements i need in order to come up with insights

Teradata review by Vaibhav R.
Vaibhav R.
Validated Reviewer
Review Source

"Smartness of teradata"

What do you like best?

Terdata 15 new query plan, collect stats and query grid to integrate with hadoop and hive is superb and nice

What do you dislike?

Query grid license cost and infrastructure cost in this big data era

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

Enterprise data ware house and reporting silutions

Teradata review by Administrator in Computer Networking
Administrator in Computer Networking
Validated Reviewer
Review Source

"Teradata and its facts"

What do you like best?

Teradata architecture in itself is very robust. With features like parallel processing and linear scalability, its ensures speed and provides efficiency. The parallel-aware optimizer is the best in the industry. It's a package which when managed well provides fastest turnout and doesn't take away the advantage of having a warehouse. It supports so many applications but is equally efficient as a standalone product. With basic knowledge of the technology you can explore lot of opportunities in the business.

What do you dislike?

The tuning of huge queries can be sometimes exhausting as you want to make the optimizer behave a certain way but you are not completely sure how to do that. also the upgrades to the software or hardware can run long.

Recommendations to others considering the product

It's definitely a great option if you want to build a warehouse that is not only big and processes data but is fast

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

Lot of analytics are based on this warehouse. It supports lot of ad-hoc reports and with its speed it not only processes data but also provides you with information that an end user would like to see in seconds. The fact that it can cater to any business is what keeps it going. Fast, robust, secured and efficient

Teradata review by Consultant in Banking
Consultant in Banking
Validated Reviewer
Review Source

"An easy to learn and Use database"

What do you like best?

Teradata is an easy to understand and use RDBMS. Clients won't have to worry about maintaining the database after an initial setup. A developer can very well maintain the database without much effort.

Excellent support provided by Teradata, System once setup just using it is just a replication of what has already been setup.

Customers/Business won't have to worry about how to manage the database system, It gives what the business wants in a much hassle free manner.

The best thing is indexing , other database systems are focused on the the referential integrity checks and treats the data warehouse as any other OLTP system, Teradata's point of view maintaining database makes the business life easier.

In a nutshell it is a Cost effective,efficient, easy to use, easy to maintain and meaningful database for the data warehouse systems.

What do you dislike?

People/Clients still have a feeling that learning and using/switching to teradata is difficult

Recommendations to others considering the product

It is like any other database, in fact better than any other database. Much easier to learn about the database than any other complex databases in the market.

Most of the management tasks are predefined and doesn't have to go through a big hassle of managing the system.

Configuration and setup is made easy by Teradata, very cost effective.

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

Business wanted to see near to real time data in the warehouse, The processing capacity of teradata enables faster data load parallelly from multiple sources into Warehouse.

Teradata review by Francisca H.
Francisca H.
Validated Reviewer
Review Source

"Teradata"

What do you like best?

Huge data can be processed from different system . Fetching data is very easy .

What do you dislike?

Connectivity to teradata system is not user friendly .

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

Used this to store huge data from different security systems

Teradata review by Chris E.
Chris E.
Validated Reviewer
Review Source

"Database Engineer"

What do you like best?

It could process and store massive data

What do you dislike?

Not very intuitive for a new Teradata DBA. I am a DBA of another database system and just find it difficult to do things in Teradata that I could do easily in another db system

Database connection is a bit complicated as it depends on what tool is used.

Scripting is a bit challenging.

Backup is also a bit of a challenge

Security was a bit of a challenge to setup also

Recommendations to others considering the product

Make better tools that is part of the software package and not as an add-on

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

Mainly used for reporting and data analysis.

Teradata review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"Fast data warehousing database"

What do you like best?

The fast response time for large volumes of data

What do you dislike?

There is no front end tool form the developer to access similar to sql developer

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

Enormous data processing and data analytics

Teradata review by Raj S.
Raj S.
Validated Reviewer
Verified Current User
Review Source

"Teradata is Multi Teradata Byte relation database, which is i think best suited for datawarehousing"

What do you like best?

It has almost self managed administration unlike other database. So you can focus on data and analytics. This is will give you opportunity to be on always on front line.

What do you dislike?

There are some features which can be enhanced in terms analytics and in case of Incident Teradata global support needs to optimized.

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

we use for analysis and marketing,

Teradata review by Jody B.
Jody B.
Validated Reviewer
Review Source

"Teradata - Great Database for Data Warehousing"

What do you like best?

It's speed , power and flexibility. Also, can added nodes very easily to the system.

What do you dislike?

The cost of the software/hardware is really expensive.

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

Teradata was used for the Enterprise Data warehouse.

Teradata review by Administrator
Administrator
Validated Reviewer
Review Source

"It was a very good experience and I liked the product very much"

What do you like best?

The scalability and ability to resolve complex database queries with no impact on performance are the best features

What do you dislike?

The UI of this tool can be improved a bit and even the admin console of this tool can have a better user interface

Recommendations to others considering the product

More forums to discuss issues and ideas on

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

Solved multiple complex queries and data storage issues with this tool

Teradata review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Review Source

"Teradata DW the best"

What do you like best?

The performance is really good. The response times are low without taking too much of CPU time

What do you dislike?

Sometimes the application that i use hangs. Not sure if its the application or the dbms.

Session level troubleshooting options could be better.

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

We generate sales and inventory reports for a retailer and taking business decisions on it. The data is always accurate with very low margin of error.

Teradata review by User in Hospitality
User in Hospitality
Validated Reviewer
Review Source

"Teradata helps me to access research data"

What do you like best?

Teradata helps me to store and access research data that is generated by a third party vendor. We can easily map this data back to our own customer database using a key field.

What do you dislike?

Difficult to explain to others in the marketing and research organziations, but this is a function of any relational database, not the fault of this product.

Recommendations to others considering the product

Suits my needs as a technical market research user.

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

Ability to take ownership and control of our data.

Teradata review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"World class data warehouse"

What do you like best?

Built in parallel architecture. Incredible compression. Clever virtual storage. Number cruncher. Good service offerings

What do you dislike?

When you get it wrong you get it horribly wrong. Some features are still lacking. Sql assistant is years behind, even the java one

Recommendations to others considering the product

You definitely need to budget for professional services to get it right the first time

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

Build enterprise leading edge warehouses

Teradata review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Review Source

"Great Performance"

What do you like best?

Advantages of teradata are Scalability, performance and adaptability.

What do you dislike?

Interface is outdated and needs expertise to best create tables so as to not 'skew' database

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

It's well suited to large organisations where multiple departments across large geographical regions need to access one centralised repository. It's not so well suited to small-medium sized organisations where databases are not so larg

Teradata review by Himavanth .
Himavanth .
Validated Reviewer
Review Source

"This is the Best"

What do you like best?

Only Teradata gives organizations the advantage to transform data across the organization into actionable insights empowering leaders to think boldly and act decisively for the best decisions possible. Teradata and its partners bring expert insight to your business through the highest performing technology available.

What do you dislike?

Partitioned table rows are each 2 or 8 bytes wider than the equivalent unpartitioned table row. Partitioned table rows are 4 bytes wider if multivalue compression is specified for the table.

Recommendations to others considering the product

N/A

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

We have using Teradata a lot and its very helpful

Teradata review by User
User
Validated Reviewer
Review Source

"Good Database"

What do you like best?

Teradata is a solid performance DB and it's easy to fetch and append the data in the DB. Addition of rows of data and importing from data sources is easy.

What do you dislike?

The cost of implementation can be higher at time as compared to other DBs in the market.

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

Great database with performance and ease of appending data

Teradata review by User
User
Validated Reviewer
Review Source

"Helpful storage database"

What do you like best?

It is great that it is easy to use and maintains all the data I need in one place and can be easily extracted with queries.

What do you dislike?

It is a large operating system so sometimes it will take a while to process my function.

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

It has helped my company store large data sets in one place without slowing down our servers.

Teradata review by Lakshmi V.
Lakshmi V.
Validated Reviewer
Review Source

"Analytics "

What do you like best?

The performance of this system is outstanding

What do you dislike?

Complexity of setting up this system is too much

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

Analytics

Teradata review by User in Internet
User in Internet
Validated Reviewer
Review Source

"Convenient and reliable"

What do you like best?

It is a very powerful relational database but still very convenient. Supports new SQL syntax. The editor has a lot of options. Can edit and process results right within the results window.

What do you dislike?

Setting up the database can be tricky and take up some time.

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

Used it for general database interface solution. Users reach database through the Teradata client. Easy to learn, strong performance.

Teradata review by Lillian H.
Lillian H.
Validated Reviewer
Review Source

"Powerful but need stats"

What do you like best?

Fast, efficient (if you know how to optimize it)

What do you dislike?

Constantly collecting stats. It became burdensome but necessary.

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

Healthcare Analytics.

Teradata review by Consultant in Higher Education
Consultant in Higher Education
Validated Reviewer
Review Source

"Better than oracle DB"

What do you like best?

Flexibility in writing the code as compared to other relational Database languages. Doesn’t require indentation and other complicated atuff

What do you dislike?

Teradata SWL is really very expensively to get. Only god if your employer is using it

Recommendations to others considering the product

NA

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

Saves cost to the company since querying is quick

Teradata review by Industry Analyst / Tech Writer in Financial Services
Industry Analyst / Tech Writer in Financial Services
Validated Reviewer
Review Source

"Good Product but less User Friendly"

What do you like best?

Ability to handle huge datasets in an efficient manner.

Fast in Retrieving results.

What do you dislike?

Do not like the look and feel of product. It is not intuitive and user friendly.

Recommendations to others considering the product

Effective in storing huge datasets but not user friendly

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

Analyzing financial products' account and transaction level data. Main benefit is to effectively multiple months of data in single table and effectively retrieve results

Teradata review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Review Source

"Fast database"

What do you like best?

Terada handles huge volume of data efficiently, the retrieval rate is faster and performance is very good.

What do you dislike?

Teradata does not have option to create materialized views

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

Teradata is used to store historical data in data warehouse and we build analytical reports and dashboards on top of it for management

Teradata review by User in Financial Services
User in Financial Services
Validated Reviewer
Review Source

"Slow database for large companies "

What do you like best?

Gets the job done, easy to run SQL commands

What do you dislike?

Extremely slow during the workday when everyone is trying to use it, runs out of spool space easily, user interface is not very intuitive

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

Allows me to pull data to develop and drive insights that guide the company

Teradata review by User in Marketing and Advertising
User in Marketing and Advertising
Validated Reviewer
Review Source

"Review of Teradata Software"

What do you like best?

Teradata is a comprehensive tool for server query analysis. The graphics are excellent and appealing.

What do you dislike?

The interface is not the most user-friendly. The command prompts are not easy to locate for a first-time user

Recommendations to others considering the product

You may need to have some text editors give flexibility in writing long queries.

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

Client Data Analysis

Teradata review by User in Financial Services
User in Financial Services
Validated Reviewer
Review Source

"Teradata Review"

What do you like best?

Teradata have designed a DW database for fast loading of huge data volumes and fast SQL querying.

What do you dislike?

It is not suitable for small transaction OLTP databases.

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

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

Teradata review by Consultant in Insurance
Consultant in Insurance
Validated Reviewer
Review Source

"Dev DBA "

What do you like best?

It is pretty fast executing complex queries and it ideal for a DWHprojects, We have implemented TD for our new DWH

We migrated from SQL server and SSIS to TD and informatica with microstrategy as reporting tool.

What do you dislike?

Used version 13 and GUI looked like legacy system

Does not have compatibility with SSIS we had to use third party connector to move data from SQL SERVER to Teradata

Recommendations to others considering the product

It is expensive but I would still recommend as it does what it says..

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

Long running queries timing out and reports would take forever.

Teradata review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Review Source

"Teradata SQL product review "

What do you like best?

A) explorer Tree

B) Query Builder

C) options available under “Tools”

What do you dislike?

String to date conversions can be improved in teradata

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

Number of rows in table with 8 billions rows in TD is done in just few seconds with low_profile and low_account rights.

Teradata review by User
User
Validated Reviewer
Review Source

"Teradata reliable"

What do you like best?

Can store trillions of data. Well defined amp structure to accomodate n number of users.

What do you dislike?

Expensive compared to the open source dbs available.

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

Required no indexing mostly and ease of use.can handle trillions of data sets. Performance is good.

Teradata review by User in Insurance
User in Insurance
Validated Reviewer
Review Source

"Teradata Database Review"

What do you like best?

The power of TD to group and query structured data.

What do you dislike?

I do not hate the standard interface but it might have

Recommendations to others considering the product

Learn the correct joins

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

Stores claim and policy information for insurance policies. Provides ability to segmebt data and apply actuarial assumptions.

Teradata review by User in Retail
User in Retail
Validated Reviewer
Review Source

"Good for data extraction"

What do you like best?

Language is very straightforward.

It's great for data storage and extraction.

What do you dislike?

Run time may get too long.

Sometimes there isn't enough spool space.

Recommendations to others considering the product

Learn the language first. Sometimes there are other ways to run it faster.

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

Getting data and manipulating with data.

Teradata review by User in Internet
User in Internet
Validated Reviewer
Review Source

"Teradata Database Review"

What do you like best?

The power behind the SQL queries. It has a great capability to ease os use ratio.

What do you dislike?

It is plain looking, but that is not important.

Recommendations to others considering the product

Make sure you know some basic SQL first.

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

Pull data from large datasets in order to turn it into useful information.

Teradata review by Industry Analyst / Tech Writer in Higher Education
Industry Analyst / Tech Writer in Higher Education
Validated Reviewer
Review Source

"Data warehousing engineer"

What do you like best?

Its fast and capable of handling heavy tables

What do you dislike?

The cost is very high for hardware, and the support takes long time, plus its little different than traditional SQL

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

Made reporting application backends on it, it is very reliable

Teradata review by Consultant in Investment Management
Consultant in Investment Management
Validated Reviewer
Review Source

"Teradata for analysis"

What do you like best?

Few best thing are Teradata integrates with multiple applications seamlessly and the sqls are much easier to understand.

What do you dislike?

speed of execution per increased volume.

Recommendations to others considering the product

Aster is a great tool from teradata as well

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

Analyze data and easy to integrate with Tableau

Teradata review by User
User
Validated Reviewer
Review Source

"Teradata at symc"

What do you like best?

Used for data / BI

Easy

Integrated

We use it for replicating data to ods and beyond

What do you dislike?

none.

I am not too exposed as a developer , my role is not hands on with teradata

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

BI reporting

Teradata review by Consultant
Consultant
Validated Reviewer
Review Source

"Great for huge transactional and ods"

What do you like best?

Powerful tool for daily transactional and data warehousing

What do you dislike?

Ease of access and complex while configuration with third party tools

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

For handling huge data and generate reports out of it

Teradata review by sathish p.
sathish p.
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Always competitive!!!!"

What do you like best?

Flexibility and robust nature. Scalable, advanced analytics.

What do you dislike?

Major draw back is less string functions.

Recommendations to others considering the product

performs well for traditional data warehouse.

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

Na

Teradata review by Consultant in Financial Services
Consultant in Financial Services
Validated Reviewer
Review Source

"Teradata "

What do you like best?

Efficiency Reliability Scalability Enhancements

What do you dislike?

Interface is not very user friendly. There is not a lot of training available from product company.

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

storing large amounts of data

Teradata review by Industry Analyst / Tech Writer in Internet
Industry Analyst / Tech Writer in Internet
Validated Reviewer
Review Source

"Teradata Review"

What do you like best?

Flexibility, adaptability, usability, compliments other technologies

What do you dislike?

Suffers from occasional crashes and doesn’t save automatically

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

Running analytics on millions of lines of code for reporting purposes

Teradata review by User in Non-Profit Organization Management
User in Non-Profit Organization Management
Validated Reviewer
Verified Current User
Review Source

"Easy to use"

What do you like best?

Straight forward and easy to understand product, makes completing of marketing requests a breeze

What do you dislike?

Would be great if final output was also captured in teradata

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

direct mail outreach to target population.

Teradata review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Used Teradata for 7+ years"

What do you like best?

If designed properly it can retrieve data very fast.

What do you dislike?

Maintenance cost is very expensive and it comes with a expensive support cost.

Recommendations to others considering the product

Use this to store data which can be utilized. Very expensive if used as storage.

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

Migrated from Oracle to Teradata with significant performance improvements.

Teradata review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Review Source

"Teradata"

What do you like best?

The amount of space and scalability available with this platform.

What do you dislike?

Teradata can, at times, be a little user non-friendly.

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

Internal data analysis and predictive analytics.

Teradata review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Review Source

"Great database"

What do you like best?

This is a great database for huge and big data and good support.

What do you dislike?

I think it should improve on parallellism.

Recommendations to others considering the product

Good software

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

Office work.

Teradata review by User in Retail
User in Retail
Validated Reviewer
Review Source

"Review"

What do you like best?

Accurate and intuitive when pulling the data I need

What do you dislike?

Can be pretty slow at times based on the size of the data

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

Ease of use

Teradata review by Administrator in Consumer Goods
Administrator in Consumer Goods
Validated Reviewer
Review Source

"Awesome product"

What do you like best?

A great software created for enterprise level applications

What do you dislike?

Too cumbersome to setup but once done rock solid

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

We have saved million of dollars

Teradata review by Administrator
Administrator
Validated Reviewer
Review Source

"software developer"

What do you like best?

Its very user friendly, i would highly recommend to use

What do you dislike?

Its little difficult if you dont have any db knowledge

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

storing customer data

Teradata review by Internal Consultant in Biotechnology
Internal Consultant in Biotechnology
Validated Reviewer
Review Source

"BA"

What do you like best?

This offers large space to store the data

What do you dislike?

Nothing really. It works absolutely fine

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

Solving the need to store all data sets.

Teradata review by Administrator in Computer Software
Administrator in Computer Software
Validated Reviewer
Review Source

"Working as dba "

What do you like best?

Its performance, fully scalable relational database management.

Parallel efficiency

What do you dislike?

None dislikes.. But expecting more advance features

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

Query optimisation, users daily issues. Back up recory operations,

Teradata review by Consultant
Consultant
Validated Reviewer
Review Source

"Great product"

What do you like best?

Best in handling large volume of data anywhere

What do you dislike?

nothing..............................................

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

Healthcare

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.