1.0 - Analytic Languages - Teradata Vantage

Teradata® Vantage User Guide

Product
Teradata Vantage
Release Number
1.0
Published
January 2019
Language
English (United States)
Last Update
2020-03-11
dita:mapPath
hfp1506029122470.ditamap
dita:ditavalPath
hfp1506029122470.ditaval

SQL

Teradata Vantage provides JDBC, ODBC, .NET Data Provider, and BTEQ interfaces for executing SQL commands against Teradata Vantage.

Python

Python is a popular language used by data scientists. Teradata provides a SQL Driver for Python and an Analytic Library for Python that can be loaded into the Client Python environment. These packages allow you to develop Python scripts that access data in the Teradata Vantage system and run Teradata Vantage analytic functions. Teradata Vantage also allows execution of Python scripts on the server, through SCRIPT table Operator.

R

R is a widely used software environment for data manipulation, calculation, and analytics execution. It is an established analytic language with a large collection of libraries. Teradata provides an ODBC driver and an analytic library for R that can be loaded into the Client R environment. These packages allow you to develop R scripts that access data in the Teradata Vantage system and run Teradata Vantage analytic functions. Teradata Vantage also allows execution of R scripts on the server, through ExecR and SCRIPT table Operator.