{"id":27504,"date":"2022-02-23T13:10:38","date_gmt":"2022-02-23T13:10:38","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=27504"},"modified":"2022-12-23T06:48:47","modified_gmt":"2022-12-23T06:48:47","slug":"how-to-configure-teradata-odbc-drive-to-connect-teradata-sql-assistant-to-teradata","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/how-to-configure-teradata-odbc-drive-to-connect-teradata-sql-assistant-to-teradata\/","title":{"rendered":"How to connect Teradata SQL Assistant to Teradata"},"content":{"rendered":"\n

In this Tutorial we will learn how to connect Teradata SQL Assistant to Teradata database using Teradata ODBC drive.<\/p>\n\n\n\n

If you want to install Teradata Database in your windows then Please please go through our Tutorial on Installation and Configuration Teradata Tools and Utilities<\/a><\/p>\n\n\n\n

<\/p>\n\n\n\n

Below are the steps to connect Teradata SQL Assistant to Teradata Database:<\/p>\n\n\n\n

1st Step:<\/strong><\/p>\n\n\n\n

 You can download latest Teradata Tools and Utilities package<\/a>  from the official Teradata Website which includes all the tools for Teradata including Teradata SQL Assistant and ODBC driver.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

2nd Step:<\/strong><\/p>\n\n\n\n

Once you downloaded the package, simply extract and install it like any other software in Windows and lunch Teradata SQL Assistant Software.<\/p>\n\n\n\n

3rd Step:<\/strong><\/p>\n\n\n\n

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.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

4th Step:<\/strong><\/p>\n\n\n\n

 In the next window of Select Data Source select Machine Data Source and and click on New.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

5th Step:<\/strong><\/p>\n\n\n\n

Click on Next and Select Teradata database ODBC driver from the Extreme last. Then Click and Finish.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

6th Step:<\/strong><\/p>\n\n\n\n

On the next window provide the below information and click Ok.<\/p>\n\n\n\n

Name<\/strong> \u2013 Teradata or any name you want.<\/p>\n\n\n\n

Description<\/strong> \u2013 Teradata or any description you want.<\/p>\n\n\n\n

Name or IP address<\/strong>\u00a0\u2013 Teradata server IP address or Name. In this case, I am using my local\u00a0Installation and Configuration Teradata Tools and Utilities<\/a><\/a><\/p>\n\n\n\n

Mechanism<\/strong> \u2013 TD2<\/p>\n\n\n\n

Username<\/strong> \u2013 dbc (default user came with after new Teradata Installation. We can create other users later.)<\/p>\n\n\n\n

Password<\/strong> \u2013 dbc (default password)<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

7th Step:<\/strong><\/p>\n\n\n\n

 On the next step once you click ok twice the ODBC driver will connect Teradata SQL Assistant to the Teradata System.<\/p>\n\n\n\n

Once you are connected to the Teradata System, you can check the version of the Teradata database using the following Query.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Sel<\/strong> * from<\/strong> dbc.dbcinfo\n\n\n<\/pre>\n\n\n\n
Teradata SQL Assistant Additional Setup:<\/h3>\n\n\n\n
You can change SQL Assistant additional setting:<\/p>\n\n\n\n
click on Tools –> Option –> will get below window<\/p>\n\n\n\n
<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
  1. To Get Separate Answers window for the query.<\/li><\/ol>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    <\/p>\n\n\n\n
    2. To stop Query execution if an SQL error occurs<\/p>\n\n\n\n
    and Submit only the selected query text, when highlighted<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    3. To get Setup Answer set<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
     Note: you can do same for other tab also.<\/p>\n\n\n\n
    4. Teradata SQL Assistant tabbed <\/p>\n\n\n\n
    Before without Tabbed:<\/strong> <\/p>\n\n\n\n
     Before without tabbed -query , history and answer set  in vertical way<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    After Tabbed<\/strong><\/p>\n\n\n\n
    click on window –> Tabbbed<\/p>\n\n\n\n
    By using below you can set query , history and answer set  in horizonal way<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    <\/p>\n\n\n\n
    <\/p>\n","protected":false},"excerpt":{"rendered":"
    In this Tutorial we will learn how to connect Teradata SQL Assistant to Teradata database using Teradata ODBC drive. If you want to install Teradata Database in… <\/p>\n","protected":false},"author":48,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[7338],"tags":[],"class_list":["post-27504","post","type-post","status-publish","format-standard","hentry","category-teradata"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/27504","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/48"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=27504"}],"version-history":[{"count":2,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/27504\/revisions"}],"predecessor-version":[{"id":27678,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/27504\/revisions\/27678"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=27504"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=27504"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=27504"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}