{"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 your windows then Please please go through our Tutorial on Installation and Configuration Teradata Tools and Utilities Below are the steps to connect Teradata SQL Assistant to Teradata…<\/p>\n","protected":false},"author":48,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","_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}]}}