Teradata SQL Assistant

In this tutorial, you will learn how to download and install Teradata SQL Assistant. You will also learn to connect Teradata RDBMS using Teradata SQL Assistant.

Teradata SQL Assistant is a query tool by which you can perform various tasks like querying data from the Teradata database, inserting data into Teradata, Administrative works like creating objects, User management, roles, and profile management, and extracting reports in a formatted manner. Teradata SQL Assistant is referred to as Teradata Tools and Utility product.

Downloading and Installing Teradata SQL Assistant

Teradata SQL Assistant comes as a Teradata Tools and Utility (TTU) product. In order to download it, you need to download TTU package from the below link.


Once downloaded, navigate to the downloaded folder and double click on the setup file.

teradata tools and utilities installation - click on setup file

The below window will appear. Select Teradata SQL Assistant and proceed further.

select required tools and utilities

Or, you may directly navigate to the folder of Teradata SQL Assistant and run the setup file.

Navigation Path:


Install Teradata SQL Assistant

Defining Data Source and Connecting Teradata

Step 1: Once the installation is complete, open the Teradata SQL Assistant. You will find connect option in the extreme left corner just below the file option. Select the ODBC option and click on connect.

open odbc option

Step 2: In the next screen of Select Data Source, select Machine Data Source and click on New.

Teradata odbc new

Step 3: Click on Next and Select Teradata database ODBC driver from the Extreme last. Then Click and Finish.

Teradata Database ODBC Driver

Step 4: On the next window provide the below information and click Ok.

Name – Teradata ODBC or any name you want.
Description – Teradata ODBC or any description you want.
Name or IP address – Teradata server IP address or Name. In this case, I am using my local installed Teradata.
Mechanism – TD2
Username – dbc (default user came with after new Teradata Installation. We can create other users later.)
Password – dbc (default password)

Teradata odbc driver connecting dialog

Step 5: On the next step once you click ok twice the ODBC driver will connect Teradata SQL Assistant to the Teradata System.

Teradata SQL Assistant

Step 6: Once you are connected to the Teradata System, you can check the version of the Teradata database using the following Query.

select * from dbc.dbcinfo;

Teradata SQL Assistant Additional Setup

Below are some of the additional setup you may want to do with Teradata SQL Assistant,

1) Separate Answers window for the query

To set up a separate answer sheet window for each query, you can follow the below steps.

a) From the menu bar, click on Tools.
b) Next click on options. The options window will open.
c) Now click on the “General” tab.
d) Select Allow multiple queries per connection.
e) And for “Use a separate Window for” select “Each Query”.
f) Now click on the Query tab and uncheck the option “Close Answers windows before submitting a new query”.

Separate Answers window for the query

2) Teradata SQL Assistant tabbed answer sheet

a) Go to Window.
b) Now select Tabbed.

Teradata SQL Assistant tabbed answer sheet


Please get connected & share!