All Forums Tools
bugmenot 8 posts Joined 03/11
26 Aug 2013
Installing the TTU 14.10 on windows

Dear All,
This is my first post on this forum. I have downloaded the teradata TTU 14.10 for windows. After having extracted the zip file i want to install the same. As per the instructions given here on the site it says i need to run the setup.exe to install it. But i dont find one single setup.exe which does this job,instead i find setup.exe in each and every folder such as BTEQ,FASTEXPORT,FASTLOAD. Do i need to install everything seperately. At the sametime there are 3 more exes such as TTU_Base.exe,TTU_DBM.exe and TTUListProducts.exe. Is there any order in which they need to be installed.Kindly let me know on this.
 
Cheers!!!

SuSeSi 51 posts Joined 10/08
04 Sep 2013

TTU_Base.exe is the program which can be used for all of the fastload/bteq/fastexport etc. You will be prompted with product to choose in a menu.
Note that when you install with TTU_Base.exe, you only will have one entry in add/remove program.
If you want to install individual packages separately then you can brawse and install.
 

-Sudhansu

bugmenot 8 posts Joined 03/11
14 Sep 2013

Dear Sudhansu,
Thanks a lot for the information. There is one more thing that i wanted to know.
When i install TTU_Base.exe, it will be installed on the windows OS.On the other hand the teradata express downloaded runs on SUSE linux and the whole thing is invoked using VMware Player. Now my question here is how will the TTU utilities running on windows interact with the database that is on SUSE linux. Your response is much appreciated.
 
Regards
Suresh

M.Saeed Khurram 457 posts Joined 09/12
15 Sep 2013

TTU_Base.exe is the main setup file that you need to run and then you will choose the products you want to install. 
TTU_DBM.exe will install the database administration utilties. if you need admin utilities as well then install these as well.
 

Khurram

bugmenot 8 posts Joined 03/11
15 Sep 2013

Hi Saeed,
Thanks for the response. But my question is , my teradata database is invoked using VMware player and my mload utility is installed on windows 7. In such a situation how can i load a file using mload utility. I am sorry if my question looks insensible as i am totally new to teradata.
Regards
Suresh

M.Saeed Khurram 457 posts Joined 09/12
15 Sep 2013

oops, I am sorry for the misunderstanding. Well, it is very simple. You need to add ODBC connection to connect the VM.
Perform the following steps and you can access the Teradata installed on VM.

  1. First of al check the IP of machine on VM, by issuing ifconfig command.
  2. once you know the IP of the VM machine, go back to your machine and ping that IP of (VM), make sure you can acces it from your machine.
  3. Open the SQL Assistant installed on your machine and the go to the Tools menue -> Define ODBC data source.
  4. On ODBC window, Click on Add, choose Teradata from the next window
  5. Enter name of your choice as the connection name, Enter the IP of VM in the Teradata server info.
  6. Enter user name and password, click ok, You are done with the connection.

Now in SQL Assistant on the top left click on the Connect button, and from machine data source tab, select your ODBC name you just added.
Click Ok, and you will get connected to the Teradata on VM. Now you can submit queries!
 

Khurram

bugmenot 8 posts Joined 03/11
16 Sep 2013

Dear Saeed,
Wow Wow !!! Thanks a ton Saeed it is working now. I was totally confused as to how to go about.
Well anyways my name is suresh rangadhamaiah and an australian resident. My email id is surileo@yahoo.com
Have a great time!!
 
Cheers!!!
Suresh

wolf75 1 post Joined 06/13
18 Sep 2013

Installation of SQLAssistant on Win 8 64x fails with message "Error 1606. Could not  access network location 0\Teradata\SQL Assistant".
:(
 
 

M.Saeed Khurram 457 posts Joined 09/12
18 Sep 2013

Hi,

The problem is potentially a result of an inconsistent/incorrect environmental variable (%AppData%).

 

Solution:

  1. Open the Registry editor
  2. Navigate to the following registry keys HKEY_USERS\.DEFAULT\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders
  3. The correct and default value for AppData should be: %USERPROFILE%\AppData\Roaming
  4. Close the Registry editor, and try again Windows Update again. (A reboot should not be required.)
  5. If the problem persists, repeat the steps 2 through 4 with the following registry keys:

 

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders\

HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders\

 

Hope this will work for you!

 

 

Khurram

You must sign in to leave a comment.