Teradata Vantage Advanced SQL Engine (Teradata Database)
Teradata Vantage Advanced SQL Engine (Teradata Database)
Overview
Recent Reviews
Video Reviews
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Teradata Vantage Advanced SQL Engine (Teradata Database), and make your voice heard!
Pricing
View all pricingEntry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
Would you like us to let the vendor know that you want pricing?
1 person want pricing too
Alternatives Pricing
Features Scorecard
No scorecards have been submitted for this product yet.Start a Scorecard.
Product Details
What is Teradata Vantage Advanced SQL Engine (Teradata Database)?
Teradata Database has evolved to become the Teradata Vantage Advanced SQL Engine. The vendor describes the solution as a flexible analytic engine, in the most scalable and manageable database.
Teradata offers four service tiers based on workload profiles. Each is bundled with database features, subscription-based licensing, and license portability from on-premises to cloud options.
Teradata Vantage Advanced SQL Engine (Teradata Database) Technical Details
Operating Systems | Unspecified |
---|---|
Mobile Application | No |
Comparisons
View all alternativesCompare with
Reviews and Ratings
 (36)
Reviews
(1-7 of 7)- Popular Filters
Companies can't remove reviews or game the system. Here's why
May 12, 2021
Best analytical database
Teradata is being used by the entire company with more than 1200 active users on a weekly basis. Teradata is our enterprise data warehouse. It was heavily used for handling massive volume of data to support our business with reports and raw data. It was used for analyzing web logs data.
- Teradata is a MPP system and its capabilities allow [us] to process a huge amount of data with great performance since it works by the concept of nodes (amps), being scalable and offering great reliability about data recovering, massive processing managing, data backup, etc.
- Teradata Vantage integrates Python, R and other tools that allow [us] to work and develop complex Data Science wise processes.
- Teradata is extremely efficient and it has lot of utilities to support extraction from different source systems.
- Support for geospatial data could be better.
- Quite expensive compared to other products out there on the market.
August 06, 2019
Powerhouse for Data Warehousing and Analysis
We have been using Teradata database in our project for a long time now and I am very happy with that decision of implementing it because it has far exceeded our expectations. So, the Teradata database is basically a Relational Database Management System which is highly Scalable, Available, Stable and Robust. It is mostly used by large organizations to develop enterprise Dataware housing model. Teradata is a good fit for you only if you are dealing with huge volumes of data otherwise it may not be cost-effective for you. This enables running massive volume queries swift and easy and the response time is outstanding as well.
- Teradata database is based on Massively Parallel Processing (MPP) architecture. Because of this architecture, Teradata is able to share the workload evenly across all the system. It splits the work equally to its processes and each process runs in parallel to achieve the result in quickest possible time.
- The underlying work is done by Teradata nodes, Access Module Processors (AMPs) and the disks associated with AMPs. The beauty is that none of them share any resources which means they all work independently and achieve actual parallel processing with the fastest results. The each AMP shares the same amount of work so that no resource stays idle and the output can be quicker.
- Another excellent feature of Teradata is the Connectivity portion. It can so easily connect to almost all the major systems like Mainframes, Oracle DB or IBM DB2. The import of loads is super fast and efficient.
- It is also really helpful when you have to troubleshoot an error because it provides great diagnostic information and therefore saves you a lot of time and effort by not having to go through all the logs manually and find the error and cause for it.
- Teradata is an excellent option but only for a massive amount of data warehousing or analysis. If your data is not that big then it could be a misfit for your company and cost you a lot. The cost associated is quite extensive as compared to some other alternative RDBMS systems available in the market.
- Migration of data from Teradata to some other RDBMS systems is quite painful as the transition is not that smooth and you need to follow many steps and even if one of them fails. You need to start from the beginning almost.
- Last but not least the UI is pretty outdated and needs a revamp. Though it is simple, it needs to be presented in a much better way and more advanced options need to bee presented on the front page itself.
November 08, 2018
Teradata - Leader in DW
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.
June 08, 2017
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
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
April 17, 2017
Data quality and operations lead
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.
- I really want to see Teradata evolve all the new technology on par with Hadoop
April 13, 2017
Killing a Fly with a Atom Bomb
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.