TrustRadius
Teradata is a relational database and data warehouse.https://dudodiprj2sv7.cloudfront.net/product-logos/dE/QS/D49MLVI2TED7.jpegTeradata - Leader in DWWe use it for the whole organization. We use it for data warehousing. It handles huge volumes of data easily.,User interface is very easy. you can build the SQL very easily for beginners too It's very fast and had good performance, makes running huge volume queries easy It's easy to find and resolve the issues.,Unlike most of the other DB, the SQL scripting is difficult here, we need to learn for using any advance scripting More room for automation of deployments is needed.,9,Easy management of the databases; we don't have many administrators to handle the environment Developers easily able to develop the scripts for all kinds of requirements (with minimum resources)Teradata - one size fits all, really.Terdata is currently used as the main database application for a majority if not all departments across the organisation, containing both the enterprise data warehouse(s) and group data warehouse(s).,Scalability, where it's able to house magnitudes more data compared to a standard SQL database while still retaining good performance. Performance, able to quickly retrieve millions of rows with ease. Adaptability, able to connect to the likes of Tableau desktop to enable quick analysis.,Interface is outdated Some syntax slightly different to standard SQL Needs expertise to best create tables so as to not 'skew' database,8,Positive - allowing multiple departments to use and access fewer versions of the 'truth' which results in the least variance in data across the organisation,5000,20,Repository for entire organisation's data needs,Connect with tableau to directly initiate analysis,10,No,Product Features Product Usability Product Reputation Vendor Reputation,No change, as this is the standard application used in the banking industry in Australia.,Standard SQL style queries,Queries not sharing same syntax as SQL,No,7Teradata - worthy pro tool but not the easiest to start withTeradata Database is used across the whole organization. It serves as the data warehouse. It addresses many problems related to huge amounts of data and it's processing hundreds of users. Balancing data calculations in correlation with hardware capabilities seems to be the biggest challenge for DB administrators.,Data processing Parallelism Great diagnostic informations,Teradata client tools Unification of SQL language with most popular ones PL-SQL, T-SQL Tools installation process on Windows,5,Solution stability Lower hardware cost in proper implementation Needed many trainings before any implementation is started,Microsoft SQL Server and Oracle Database 12c,Microsoft SQL Server, Microsoft Silverlight, Visual Studio IDE, SAP BusinessObjects BI PlatformKilling a Fly with a Atom BombTeradata was used as a staging area for SAP financial information. It was set up as a enterprise wide data warehouse where anyone (with proper access) could come in a grab standardized financial information. As a user of the database our job was to pull information for reports and feeding our down stream applications. Using multiple SQL GUI interfaces we tried to pull our information, however the database could not handle some of the most basic Select statements. Now, one could say that the engineering and design was not up to par but I have seen other databases (Oracle) that have been setup incorrectly still be able to handle a simple select statement.,It is easy to navigate. Using the GUI you can build SQL if you don't know how. The interaction for Projects can be managed in the GUI.,Speed. Seems slow and clunky Make it user-friendly from the implementation side of the house. Improve the table mapping feature.,6,Negative impact is again the slowness that would be felt by developers and users. Negative impact is that there is a learning curve if they have been using any other type of SQL. Positive impact is that you can collaborate with other developers by using projects.,Oracle Data Warehouse,Oracle Data Integrator, Oracle Hyperion Enterprise Performance Management, Teradata Master Data Management, Informatica Master Data ManagementData quality and operations leadTeradata is used by most of the departments in business enterprise. It addresses the processing of large amounts of data with ease.,Is capable of running on single-nodes, as well as multi-nodes. Parallelism is built into the system. Teradata is basically an RDMS which is used to drive the Datamart, Datawarehouse, OLAP, OLTP, as well as DSS Appliances of the company.,Comparing Hadoop to a data warehouse is like comparing apples to oranges. The data warehouse is a concept and Hadoop is a technology. I really want to see Teradata evolve all the new technology on par with Hadoop,10,Very positive and very good returns on the investment.,,Hadoop, Tableau Online, Informatica Data Quality
Unspecified
Teradata Database
26 Ratings
Score 8.0 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

Teradata Database Reviews

Teradata Database
26 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.0 out of 101
Show Filters 
Hide Filters 
Filter 26 vetted Teradata Database reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role
Reviews (1-5 of 5)
  Vendors can't alter or remove reviews. Here's why.
No photo available
November 08, 2018

Teradata Database Review: "Teradata - Leader in DW"

Score 9 out of 10
Vetted Review
Verified User
Review Source
We use it for the whole organization. We use it for data warehousing. It handles huge volumes of data easily.
  • User interface is very easy. you can build the SQL very easily for beginners too
  • It's very fast and had good performance, makes running huge volume queries easy
  • It's easy to find and resolve the issues.
  • Unlike most of the other DB, the SQL scripting is difficult here, we need to learn for using any advance scripting
  • More room for automation of deployments is needed.
It doesn't need many hardcore developers or administrators, it's easy to maintain and keep everything in control.
Read this authenticated review
David Shi profile photo
June 08, 2017

Teradata Database Review: "Teradata - one size fits all, really."

Score 8 out of 10
Vetted Review
Verified User
Review Source
Terdata is currently used as the main database application for a majority if not all departments across the organisation, containing both the enterprise data warehouse(s) and group data warehouse(s).
  • Scalability, where it's able to house magnitudes more data compared to a standard SQL database while still retaining good performance.
  • Performance, able to quickly retrieve millions of rows with ease.
  • Adaptability, able to connect to the likes of Tableau desktop to enable quick analysis.
  • Interface is outdated
  • Some syntax slightly different to standard SQL
  • Needs expertise to best create tables so as to not 'skew' database
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 large.
Read David Shi's full review
Mateusz Michałek profile photo
April 19, 2017

Teradata Database Review: "Teradata - worthy pro tool but not the easiest to start with"

Score 5 out of 10
Vetted Review
Verified User
Review Source
Teradata Database is used across the whole organization. It serves as the data warehouse. It addresses many problems related to huge amounts of data and it's processing hundreds of users. Balancing data calculations in correlation with hardware capabilities seems to be the biggest challenge for DB administrators.
  • Data processing
  • Parallelism
  • Great diagnostic informations
  • Teradata client tools
  • Unification of SQL language with most popular ones PL-SQL, T-SQL
  • Tools installation process on Windows
Teradata solutions are really good for big data warehouses. Huge amounts of data, users and processing loads seem to be the perfect environment for Teradata's package. Also, its connectivity capabilities to other DB systems is a big plus. I would not recommend Teradata for beginners in the DB world as it requires much more experience and knowledge than other solutions.
Read Mateusz Michałek's full review
Brian Dandeneau profile photo
April 13, 2017

Teradata Database Review: "Killing a Fly with a Atom Bomb"

Score 6 out of 10
Vetted Review
Verified User
Review Source
Teradata was used as a staging area for SAP financial information. It was set up as a enterprise wide data warehouse where anyone (with proper access) could come in a grab standardized financial information. As a user of the database our job was to pull information for reports and feeding our down stream applications. Using multiple SQL GUI interfaces we tried to pull our information, however the database could not handle some of the most basic Select statements. Now, one could say that the engineering and design was not up to par but I have seen other databases (Oracle) that have been setup incorrectly still be able to handle a simple select statement.
  • It is easy to navigate.
  • Using the GUI you can build SQL if you don't know how.
  • The interaction for Projects can be managed in the GUI.
  • Speed. Seems slow and clunky
  • Make it user-friendly from the implementation side of the house.
  • Improve the table mapping feature.
Sometimes Teradata is like killing a fly with an atom bomb. you really have to scale it out. Please make sure that you have someone onsite that can properly install and setup this tool. Any data warehouse can be great with the right setup. Consider other tools before this one even if they are a little more expensive up front. It would cost you less at the end of the day.
Read Brian Dandeneau's full review
No photo available
April 17, 2017

Teradata Database Review: "Data quality and operations lead"

Score 10 out of 10
Vetted Review
Verified User
Review Source
Teradata is used by most of the departments in business enterprise. It addresses the processing of large amounts of data with ease.
  • Is capable of running on single-nodes, as well as multi-nodes.
  • Parallelism is built into the system.
  • Teradata is basically an RDMS which is used to drive the Datamart, Datawarehouse, OLAP, OLTP, as well as DSS Appliances of the company.
  • Comparing Hadoop to a data warehouse is like comparing apples to oranges. The data warehouse is a concept and Hadoop is a technology.
  • I really want to see Teradata evolve all the new technology on par with Hadoop
Teradata is best used for data processing after the data is loaded. It is less appropriate in handling real-time data.
Read this authenticated review

About Teradata Database

Teradata is a relational database and data warehouse.
Categories:  Relational Databases

Teradata Database Technical Details

Operating Systems: Unspecified
Mobile Application:No