In this tutorial, we will guide you on how to connect Teradata SQL Assistant to the Teradata Database using Teradata ODBC Driver and other methods. If you want to install Teradata Database in Windows, you can check out our tutorial on Teradata Installation Guide.
Below are the steps to connect Teradata SQL Assistant to Teradata RDBMS:
Step 1: You can download Teradata Tools and Utilities package from the official Teradata Website which includes all the tools for Teradata including Teradata SQL Assistant and ODBC driver.
Alternatively, you can also download Teradata SQL Assistant and Teradata ODBC driver individually from the Teradata official download page.
Step 2: Once you downloaded the package, simply extract and install it like any other software in Windows and lunch Teradata SQL Assistant Software.
Step 3: Once you 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.
Step 4: In the next window of Select Data Source select Machine Data Source and and click on New.
Step 5: Click on Next and Select Teradata database ODBC driver from the Extreme last. Then Click and Finish.
Step 6: 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)
Step 7: On the next step once you click ok twice the ODBC driver will connect Teradata SQL Assistant to the Teradata System.
Step 8: 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 can do in Teradata SQL Assistant.
1. Separate Answers window for the query.
In order to set up a separate answer sheet window for each query, you can follow the below steps.
a) Click on Tools.
b) Click on options.
c) 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”
2. Teradata SQL Assistant tabbed answer sheet.
a) Go to Window.
b) Now select Tabbed.
I hope, you have successfully connected to the Teradata Database using SQL Assistant using the following guide. Great! now check the nos of AMPs, PEs in your Teradata system by referring to our article Know your Teradata System Configuration.
If you still find any issues, you may contact us using the contact form.