The following table lists analytic tools that provide access to Vantage along with links to installation and user guides.
Analytic Tool | Description | References |
---|---|---|
AppCenter |
AppCenter is a web-based platform that allows you to create, share, and use custom apps and scripts to query data on Vantage ( Advanced SQL Engine and Machine Learning Engine) and Hive systems. You can also create helpful visualizations. AppCenter is useful to developers who build, share, and deploy analytical use cases and also non-technical users who run apps and scripts, study job results data, and share insights. |
|
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. |
|
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: https://teradata.github.io/jupyterextensions/. |
|
RStudio | RStudio is an IDE for R. In addition to a console and editor, RStudio includes tools for plotting, history, debugging, and workspace management. | |
Studio |
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. |
|
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. |