17.00 - 17.05 - Software Components - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

This figure illustrates the software components in workstation-attached clients that play important roles in getting and executing requests to and from Vantage.



The following table describes these software components.

Component Description References
Client application Either:
  • Written by a developer in your company
  • Written under contract to you by Teradata
  • One of the Vantage-provided utilities

Users use these applications to submit SQL statements, maintain files, and generate reports.

Teradata® Preprocessor2 for Embedded SQL Programmer Guide, B035-2446
Teradata CLI A low-level interface to Vantage, CLI consists of routines that perform functions similar to CLI system calls on mainframe-attached clients, including:
  • Logging sessions on and off
  • Submitting SQL queries
  • Receiving responses with the answer set
Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems, B035-2418
Database connectivity drivers A variety of drivers for open connectivity products, such as ODBC and JDBC. Teradata JDBC Driver Reference, available at https://teradata-docs.s3.amazonaws.com/doc/connectivity/jdbc/reference/current/frameset.html

ODBC Driver for Teradata® User Guide, B035-2526