Teradata SQL Assistant Features - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

SQL Assistant
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

Teradata SQL Assistant Features

Teradata SQL Assistant provides several key functions:

  • Creates reports from Teradata, Oracle or any Relational Database that provides an ODBC interface
  • Exports data from the database to a file on a PC
  • Imports data from a PC file directly to the database
  • Uses an import file to create many similar reports (query results or Answersets)
    For example, display the DDL (SQL) that was used to create a list of tables. For more information, see “Generating Multiple Reports From a Single Query” on page 102.
  • Sends queries to any supported database or send the same query to many different databases
  • Creates a historical record of the submitted SQL with timings and status information such as success or failure
  • Uses SQL syntax examples to tailor statements
  • Uses the Database Explorer Tree to easily view database objects
  • Uses a procedure builder that provides a list of valid statements for building the logic of a stored procedure
  • Limits data returned to prevent runaway queries
  • Creates charts from the returned data