Analytic Tools for Vantage | Teradata Vantage - 2.2 - Applications and Analytic Tools - Teradata Vantage

Configuring Teradata Vantageā„¢ After Installation

Teradata Vantage
Release Number
Release Date
January 2021
Content Type
Publication ID
English (United States)
Analytic Tool Description References
BTEQ Basic Teradata Query (BTEQ) is a general-purpose, command-based program that enables users on a workstation to communicate with one or more Vantage systems, and to format reports for both print and screen output. Use BTEQ to submit SQL queries to Vantage. BTEQ formats the results and returns them to the screen, a file, or to a designated printer.
Database Window Teradata DBW allows database administrators, system operators, and support personnel to control the operation of Advanced SQL Engine.

DBW is also the primary vehicle for starting and controlling the operation of Advanced SQL Engine utilities.

Teradata Database Window
Jupyter Jupyter is an open source set of standards for interactive computing across dozens of programming languages. Jupyter Notebooks is an open-source web application that allows you to create and share documents that contain live code, equations, visualizations, and narrative text. Teradata provides a set of Jupyter extensions that facilitates using Jupyter with Teradata Vantage. This set of extensions must be installed on your Jupyter instance.

Sample SQL and Python notebooks and additional information about using the SQL extension for Jupyter can be found at:

Teradata Vantageā„¢ Modules for Jupyter Installation Guide, B700-4010
RStudio RStudio is an IDE for R. In addition to a console and editor, RStudio includes tools for plotting, history, debugging, and workspace management.

Teradata Studio is a client-based graphical interface for performing database administration, query development, and management tasks on Vantage (Advanced SQL Engine, Machine Learning Engine) and Hadoop systems.

Teradata Studio is built on the Eclipse Rich Client Platform (RCP) framework to build and deploy native GUI applications. It extends the Eclipse Data Tools Platform (DTP) to provide enhancements for accessing objects and data stored in Teradata-supported databases.

Teradata Studio supports the Teradata Unified Data Architecture (UDA) by integrating administration, data management and transfer, and SQL query development across the Vantage and Hadoop platforms.

TPT Teradata Parallel Transporter (TPT) is an object-oriented client application that provides scalable, high-speed, parallel data for extraction, loading, and updating data. These functions can be extended with customizations or with third-party products.

TPT uses and expands on the functionality of the traditional Teradata extract and load utilities such as FastLoad, MultiLoad, FastExport, and TPump, collectively referred to as standalone utilities.

Teradata Parallel Transporter (TPT) User Guide
Vantage Analyst Vantage Analyst allows Business Analysts and Data Scientists to:
  • Create, train, and score predictive models without coding complex machine-learning algorithms
  • Simulate the agile, iterative data science process by drilling down to expose hidden data patterns using interactive visualizations
  • Perform complex, high volume, rules-based calculations and analytic workflows
Vantage Analyst User Guide
Vantage Analytics Library Vantage Analytics Library provides the Data Scientist with over fifty advanced analytic functions built directly in the Advanced SQL Engine. These functions support the entire data science process, including exploratory data analysis, data preparation and feature engineering, hypothesis testing, as well as statistical and machine learning model building and scoring.

You can download the Vantage Analytics Library from

Vantage Analytics Library User Guide
Viewpoint The Viewpoint portal is a framework where web-based applications, known as portlets, are displayed. IT professionals and business users can customize their portlets to manage and monitor their Teradata systems using a web browser.

Portlets enable users across an enterprise to customize tasks and display options to their specific business needs. You can view current data, run queries, and make timely business decisions, reducing the database administrator workload by allowing you to manage your work independently. Portlets are added to a portal page using the Add Content screen. The Viewpoint administrator configures access to portlets based on your role.