In this article, I am going to introduce how to install Teradata Express in virtual machines in Windows.
Download software
- 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.
- 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
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.
Extract the file TDExpress15.0.0.8_Sles10_40GB_vp.7z to a folder.
Open VMware Player
https://api.kontext.tech/resource/19220970-87e8-5de0-a575-2b49a5b4b2c5
- Choose ‘Open a Virtual Machine’ and select the file ‘TDExpress15.0.0.8_Sles10.vmx’
https://api.kontext.tech/resource/2700adbe-8659-51be-859d-a1493d21a4ae
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.
https://api.kontext.tech/resource/39c798c3-3bcc-514d-8a82-0bf87cfd0634
After some setups, you will be able to see the login window:
https://api.kontext.tech/resource/385f461c-e603-59e0-94b2-64c24952ff06
Login: root, Password: root.
After login, you can see the desktop:
https://api.kontext.tech/resource/3adc9948-41df-5094-932f-c6faef274b5d
Teradata Studio Express is also included in this virtual machine.
Run ‘Viewpoint Start’ / 'Viewpoint Stop’ to start/stop all the Teradata services.
https://api.kontext.tech/resource/aeb17979-236f-53d8-9c38-a39262ec154d
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
https://api.kontext.tech/resource/b5436381-3edd-51a2-a670-1e411c102769
After connection is established, run the query below:
select * from DBC.Accounts;
The result will be similar to the following screenshot:
https://api.kontext.tech/resource/611bb244-9e43-591e-a562-f2bc03f53507
For more details, visit the following site about how to use this tool:
http://developer.teradata.com/tools/articles/teradata-studio-express