Teradata SQL Assistant - Teradata Database

Teradata SQL Assistant stores, retrieves, and manipulates data from Teradata Database (or any database that provides an ODBC interface). You can store the data on your desktop PC, and produce consolidated results or perform data analyses using tools such as Microsoft Excel. In addition to ODBC connectivity, Teradata SQL Assistant can connect to Teradata Database using .NET Data Provider for Teradata, which can be downloaded from the Teradata Corporation website.

Teradata SQL Assistant Java Edition can be used to attach to Teradata Database or any other database that provides a JDBC interface.

The following table contains information about key features of Teradata SQL Assistant.

This feature…	Allows you to…
Queries	Use SQL syntax examples to help compose your SQL statements. Send statements to any ODBC database or the same statement to many different databases. Limit data returned to prevent runaway execution of statements.
Reports	Create reports from any database that provides an ODBC interface. Use an imported file to create many similar reports (query results or answer sets); for example, display the DDL (SQL) that was used to create a list of tables.
Data manipulation	Export data from the database to a file on a PC. Import data from a PC file directly to the database. Create a historical record of the submitted SQL with timings and status information, such as success or failure. Use the Database Explorer Tree to easily view database objects.
Teradata Database stored procedures	Use a procedure builder that gives you a list of valid statements for building the logic of a stored procedure, using Teradata Database syntax.

Teradata SQL Assistant electronically records your SQL activities with data source identification, timings, row counts, and notes. Having this historical data allows you to build a script of the SQL that produced the data. The script is useful for data mining.