Raymond Raymond

Install Teradata Express 15.0.0.8 by Using VMware Player 6.0 in Windows

event 2014-06-29 visibility 18,189 comment 23 insights toc
more_vert
insights Stats

In this article, I am going to introduce how to install Teradata Express in virtual machines in Windows.

Download software

1) Download VMware Player for Windows 32-bit and 64-bit from the following link (version 6.0):

https://my.vmware.com/web/vmware/free#desktop_end_user_computing/vmware_player/6_0

This is a free software for personal use.

2) Download TDE 15.00.00.08 SLES 10 for VMware (40GB) viewpoint: http://downloads.teradata.com/download/database/teradata-express/vmware.

This is the latest version of Teradata Express edition.

Install software

1) Install VM Player 6.0. Please turn off Windows feature Hyper-V off in your PC (restart required); otherwise you cannot open VM in the VM Player.

2) Extract the file TDExpress15.0.0.8_Sles10_40GB_vp.7z to a folder.

3) Open VMware Player

image

4) Choose ‘Open a Virtual Machine’ and select the file ‘TDExpress15.0.0.8_Sles10.vmx’

image

And now the setup work is done. As you can see, the OS is SUSE Linux Enterprise 10 64-bit and version is Workstation 6.5-7.x virtual machine.

Run the Virtual Machine

Just click ‘Play virtual machine’ and you are entering the world of Teradata.

You can also download and update VMware Tools for Linux for latest version (version 9.6.2) as recommended.

image

After some setups, you will be able to see the login window:

image

Login: root, Password: root.

After login, you can see the desktop:

image

Teradata Studio Express is also included in this virtual machine.

Run ‘Viewpoint Start’ / 'Viewpoint Stop’ to start/stop all the Teradata services.

image

Using Teradata Express Studio

In the studio, connect to the local Teradata database:

Driver: Teradata embedded JDBC

Database Server Name: localhost

User Name/Domain: dbc

Password: dbc

Authentication Mechanism: PASSWORD_PROTECTED

image

After connection is established, run the query below:

 select * from DBC.Accounts;

The result will be similar to the following screenshot:

image

For more details, visit the following site about how to use this tool:

 http://developer.teradata.com/tools/articles/teradata-studio-express

More from Kontext
comment Comments
Raymond Raymond #152 access_time 6 years ago more_vert

@Raju

In which step you could not type password? In this tutorial, there are two places:

  • Logon to suse  (use Ctrl +Alt to release mouse cursor, for more details about VMware shortcuts, refer to this page)
  • Connect to Teradata database in Teradata Studio Express.
format_quote

person Raju access_time 6 years ago

i installed teradata in vmware player.but i am unable to type password. it is not taking input to password.please anyone help me.where am going wrong.

hide_source Anonymous #15 access_time 6 years ago more_vert

i installed teradata in vmware player.but i am unable to type password. it is not taking input to password.please anyone help me.where am going wrong.

hide_source Anonymous #158 access_time 7 years ago more_vert

@Matt

If you followed all the steps, in the UNIX virtual machine, Teradata Studio Express is already included. You can use that tool to connect to the Teradata server using dbc account and then create any database you like.

Alternatively, please follow the link below to setup client tools in your Windows (host machine for the Teradata VM), which will enable you to connect directly:

http://kosmisch.net/Blog/DataAndBusinessIntelligence/Archive/2015/5/18/connect-to-teradata-virtual-machine-guest-from-windows-host.html 

You can use Teradata Administrator client tool if you are not familiar with SQL.

hide_source Anonymous #157 access_time 7 years ago more_vert

@Matt I simply don't have the Create Data base in the Tools. I am very new to Teradata. 

hide_source Anonymous #156 access_time 7 years ago more_vert
@Raymond
Raymond Raymond #155 access_time 7 years ago more_vert

@Matt what is the error message you got when creating database?

Did you follow all the steps including logging with dbc user?

format_quote

person Matt access_time 7 years ago

Did all that. But still can't create a database. I need to create a database and them tables to load some data. So I can play with that? Could you please show us?

hide_source Anonymous #14 access_time 7 years ago more_vert

Did all that. But still can't create a database. I need to create a database and them tables to load some data. So I can play with that? Could you please show us?

hide_source Anonymous #13 access_time 7 years ago more_vert

Just a quick update:

The same installation steps are still applied to the latest version 16.10.00.03

TDExpress16.10.00.03_Sles11_40GB.7z

hide_source Anonymous #12 access_time 7 years ago more_vert
Very well explained. Thank you so much.
hide_source Anonymous #154 access_time 7 years ago more_vert
@srinivasarao vasa I am glad it can help.
format_quote

person srinivasarao vasa access_time 7 years ago

Awesome go through for installation and guidance. I have come across problem of datasource connection, but was able to success after see the instructions provided. Much appreciated.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts