{"id":27460,"date":"2022-02-23T11:52:48","date_gmt":"2022-02-23T11:52:48","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=27460"},"modified":"2022-12-23T06:48:47","modified_gmt":"2022-12-23T06:48:47","slug":"installation-and-configuration-teradata-tools-and-utilities","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/installation-and-configuration-teradata-tools-and-utilities\/","title":{"rendered":"Installation and Configuration Teradata Tools and Utilities"},"content":{"rendered":"\n<p>If you want to learn and practice Teradata database Please find here the guidance how to Installation and Configuration Teradata Tools=and Utilities in your computer. <\/p>\n\n\n\n<p>The latest Teradata Tools and Utilities &#8211; Windows and Linux Installation Package is version 17.10<\/p>\n\n\n\n<p>Teradata provides Teradata express for VMWARE, which is a fully operational Teradata virtual machine. It provides up to 1 terabyte of storage. Teradata provides both 40GB and 1TB versions of VMware.<\/p>\n\n\n\n<p>Teradata releases pre-installed image for Teradata Express for VMware Workstation\/Player. By installing this, you can access Teradata from your local system using Teradata SQL Assistant, Teradata Studio or any other utilities like BTEQ, FASTLOAD, MLOAD, TPT etc. You can follow few simple steps as below:-<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"prerequisite\">Prerequisite:-<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>64 bit virtualization capable PC.<\/li><li>Minimum 3GB RAM.  4GB is recommended<\/li><li>VMware workstation\/Player.  <a href=\"https:\/\/customerconnect.vmware.com\/downloads\/details?downloadGroup=WKST-1622-WIN&amp;productId=1038\" target=\"_blank\" rel=\"noreferrer noopener\">Latest VMware workstation<\/a> is recommended<\/li><li>Teradata 15.00.01 or any other version.  <a href=\"https:\/\/downloads.teradata.com\/download\/database\/teradata-express-for-vmware-player\" target=\"_blank\" rel=\"noreferrer noopener\">Teradata Express for VMware Workstation\/Player<\/a><\/li><li>Teradata-TTU-17.10_Version_for_Windows.  <a href=\"https:\/\/downloads.teradata.com\/download\/tools\/teradata-tools-and-utilities-windows-installation-package\" target=\"_blank\" rel=\"noreferrer noopener\">Teradata tools and utilities<\/a><\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"installation-and-configuration-teradata-tools-and-utilities-for-window\">Installation and Configuration Teradata Tools and Utilities for WINDOW<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"to-install-the-teradata-workstation-on-windows-follows-below-steps\">To install the Teradata Workstation on windows follows below steps:<\/h3>\n\n\n\n<p><strong>1st Step:<\/strong><\/p>\n\n\n\n<p>Download Teradata Express and VMware workstation\u00a0 from <a href=\"https:\/\/downloads.teradata.com\/download\/database\/teradata-express-for-vmware-player\" target=\"_blank\" rel=\"noreferrer noopener\">Teradata Express for VMware Workstation\/Player<\/a> and\u00a0<a href=\"https:\/\/customerconnect.vmware.com\/downloads\/details?downloadGroup=WKST-1622-WIN&amp;productId=1038\" target=\"_blank\" rel=\"noreferrer noopener\">Latest VMware workstation<\/a> \u00a0respectively. <\/p>\n\n\n\n<p>It is available for both&nbsp;Windows and&nbsp;Linux Platform.<\/p>\n\n\n\n<p>we will Download the VMware workstation player for Windows.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-81-1024x405.png\" alt=\"\" class=\"wp-image-27482\" width=\"696\" height=\"275\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-81-1024x405.png 1024w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-81-300x119.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-81-768x304.png 768w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-81-1536x607.png 1536w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-81.png 1823w\" sizes=\"auto, (max-width: 696px) 100vw, 696px\" \/><\/figure>\n\n\n\n<p>Once downloaded, you can unzip Teradata Express into some folder. Suppose you have unzipped it in a folder name \u201cvirtual\u201d. You will end up with something like this- \u201d F:\\virtual\\TDExpressXX_Sles11_40GB \u201c. Than Install VMware workstation.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>2nd Step:<\/strong><\/p>\n\n\n\n<p>Open VMware Workstation Welcome page, choose \u201cOpen a Virtual Machine\u201d and navigate to Teradata express folder, looking for the \u201d TDExpress17.10.01_Sles11\u2033 file.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-82.png\" alt=\"\" class=\"wp-image-27484\" width=\"677\" height=\"465\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-82.png 981w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-82-300x206.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-82-768x528.png 768w\" sizes=\"auto, (max-width: 677px) 100vw, 677px\" \/><\/figure>\n\n\n\n<p><strong>3rd Step:<\/strong><\/p>\n\n\n\n<p>Once you find the image, open it by double clicking. Vmware will now ask you if you want to copy or move this image. Make sure to choose \u2018<em><strong>I MOVED IT<\/strong><\/em>\u2018!<\/p>\n\n\n\n<p><strong>4th Step:<\/strong><\/p>\n\n\n\n<p>Now click on \u201cPower on this virtual machine\u201d.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-83.png\" alt=\"\" class=\"wp-image-27485\" width=\"704\" height=\"491\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-83.png 969w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-83-300x209.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-83-768x536.png 768w\" sizes=\"auto, (max-width: 704px) 100vw, 704px\" \/><\/figure>\n\n\n\n<p>Download the required Teradata TTU latest  version from the following link:<\/p>\n\n\n\n<p><a href=\"https:\/\/downloads.teradata.com\/download\/tools\/teradata-tools-and-utilities-windows-installation-package\" target=\"_blank\" rel=\"noopener\">https:\/\/downloads.teradata.com\/download\/tools\/teradata-tools-and-utilities-windows-installation-package<\/a><\/p>\n\n\n\n<p><strong>5th Step:<\/strong><\/p>\n\n\n\n<p>Login into the SLES11 VM with username \u201croot\u201d and password \u201croot\u201d. Wait for sometimes, it will initialize the Teradata.<\/p>\n\n\n\n<p><strong>6th Step:<\/strong><\/p>\n\n\n\n<p>Once it is ready, open Gnome terminal and you can check the status of Teradata database server using below command-<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-84.png\" alt=\"\" class=\"wp-image-27493\" width=\"409\" height=\"92\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-84.png 845w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-84-300x68.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-84-768x175.png 768w\" sizes=\"auto, (max-width: 409px) 100vw, 409px\" \/><\/figure>\n\n\n\n<p>Now you can test the connectivity as well using bteq with username \u201cdbc\u201d and password \u201cdbc\u201d.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-86.png\" alt=\"\" class=\"wp-image-27495\" width=\"466\" height=\"413\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-86.png 664w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-86-300x266.png 300w\" sizes=\"auto, (max-width: 466px) 100vw, 466px\" \/><\/figure>\n\n\n\n<p>You have successfully completed the installation of fully functional Teradata server. If you want to access this Teradata database server from your local PC, few extra steps you may follow:-<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>7th Step:<\/strong><\/p>\n\n\n\n<p>Download <a href=\"https:\/\/downloads.teradata.com\/download\/tools\/teradata-tools-and-utilities-windows-installation-package\" target=\"_blank\" rel=\"noreferrer noopener\">Teradata tools and utilitie<\/a>\u00a0for windows. Generally .NET is always installed in computer , Please check for the same and If .NET not install in your computer than You need to install .NET framework prior to install Teradata Tools and Utilities(TTU).  Link Available to download <a href=\"https:\/\/dotnet.microsoft.com\/en-us\/download\/dotnet-framework\" target=\"_blank\" rel=\"noreferrer noopener\">.NET <\/a><\/p>\n\n\n\n<p>Download the required VMware version from the following link:<\/p>\n\n\n\n<p><a href=\"https:\/\/customerconnect.vmware.com\/downloads\/details?downloadGroup=WKST-1622-WIN&amp;productId=1038\" target=\"_blank\" rel=\"noopener\">https:\/\/customerconnect.vmware.com\/downloads\/details?downloadGroup=WKST-1622-WIN&amp;productId=1038<\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>8th Step:<\/strong><\/p>\n\n\n\n<p>Once installation of TTU is done, set up the IP for VM and SLES11 to access it from your local system using Teradata SQL Assistant or any other utilities.<\/p>\n\n\n\n<p>Open Virtual Network Editor from the EDIT menu of VM.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-87.png\" alt=\"\" class=\"wp-image-27496\" width=\"728\" height=\"332\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-87.png 920w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-87-300x137.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-87-768x351.png 768w\" sizes=\"auto, (max-width: 728px) 100vw, 728px\" \/><\/figure>\n\n\n\n<p>Select VMnet8 NAT setting and set up Gateway IP.<\/p>\n\n\n\n<p>Suppose your NAT subnet\u00a0 Address is 192.168.181.0, you may provide Gateway IP as 192.168.181.1. Click OK.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-88.png\" alt=\"\" class=\"wp-image-27498\" width=\"756\" height=\"379\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-88.png 959w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-88-300x150.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-88-768x385.png 768w\" sizes=\"auto, (max-width: 756px) 100vw, 756px\" \/><\/figure>\n\n\n\n<p>Now open Network Settings in SLES11 i.e. from the operating system within the VMware.<\/p>\n\n\n\n<p>Computer -> Control Center -> Network Settings -> Select Ethernet Network Card->Edit. Suppose Gateway IP is 192.168.181.1 in NAT setting, you have to enter 192.168.181.2 here as below-<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-89.png\" alt=\"\" class=\"wp-image-27499\" width=\"650\" height=\"470\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-89.png 931w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-89-300x217.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-89-768x555.png 768w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/figure>\n\n\n\n<p>Click Next.<\/p>\n\n\n\n<p>Now open command prompt in local system and ping this IP Address.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-90.png\" alt=\"\" class=\"wp-image-27500\" width=\"614\" height=\"280\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-90.png 785w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-90-300x137.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-90-768x350.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/figure>\n\n\n\n<p>All done. Now you can use this IP Address(192.168.181.2) from your\u00a0 local ODBC\u00a0 driver, Teradata SQL Assistant\u00a0 or BTEQ to access Teradata database server.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-91.png\" alt=\"\" class=\"wp-image-27501\" width=\"547\" height=\"291\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-91.png 820w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-91-300x160.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/02\/image-91-768x408.png 768w\" sizes=\"auto, (max-width: 547px) 100vw, 547px\" \/><\/figure>\n\n\n\n<p> Now You can Connect Teradata SQL  Assistance. (The Teradata SQL Assistance connection will be covered in next Tutorial)<\/p>\n\n\n\n<p><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><strong>Important Points:<\/strong><\/p><p><\/p><cite>The Teradata Administrator Tool is not available in version above than TTU 15.00. The Teradata Administrator Tool is available in TTU Vers15.00.  Also Teradata Studio the new version tool is available to connect Teradata (This topic will be covered in another tutorial).<\/cite><\/blockquote>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you want to learn and practice Teradata database Please find here the guidance how to Installation and Configuration Teradata Tools=and Utilities in your computer. The latest Teradata Tools and&#8230; <\/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-27460","post","type-post","status-publish","format-standard","hentry","category-teradata"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/27460","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=27460"}],"version-history":[{"count":1,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/27460\/revisions"}],"predecessor-version":[{"id":27503,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/27460\/revisions\/27503"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=27460"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=27460"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=27460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}