In this article, I am going to introduce how to install Teradata Express in virtual machines in Windows.
1) Download VMware Player for Windows 32-bit and 64-bit from the following link (version 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.
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 TDExpress22.214.171.124_Sles10_40GB_vp.7z to a folder.
3) Open VMware Player
4) Choose ‘Open a Virtual Machine’ and select the file ‘TDExpress126.96.36.199_Sles10.vmx’
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.
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.
After some setups, you will be able to see the login window:
Login: root, Password: root.
After login, you can see the desktop:
Teradata Studio Express is also included in this virtual machine.
Run ‘Viewpoint Start’ / 'Viewpoint Stop’ to start/stop all the Teradata services.
In the studio, connect to the local Teradata database:
Driver: Teradata embedded JDBC
Database Server Name: localhost
User Name/Domain: dbc
Authentication Mechanism: PASSWORD_PROTECTED
After connection is established, run the query below:
select * from DBC.Accounts;
The result will be similar to the following screenshot:
For more details, visit the following site about how to use this tool:
Very good instructions, I followed step by step, all the screen shots listed in your page I can reproduce it(ignorable difference). Now, do you have any online materials that I can practice? Say practice sql in teradata step by step? How many local database with teradata express? Thanks for your help!
@mark I am glad that this post helped you. I was planning to write some more materials for Teradata but I have not got time yet. I will update you once they are ready. The official website potentially provides some useful tutorials. http://developer.teradata.com/ P.S. I am also starting to learn Teradata. We can share tips with each other.
Thanks for the update! I noticed that teradata sudio express also included in teradata express, one of function for teradata studio express is loading data, I was wondered that where can I find specification for data loading? The reason I ask this question is that my old job, data loading need be done in graveyard, data amount was too big, it will take several hours, now, in teradata studio case, how to figure out what kind data I can or cannot load, so that I will not be waiting too long, because if table too big, screen will be freeze. the point is to find out limitation of teradata studio express, thanks
@sajid khan As you can see from the screenshot, the viewpoint is built in the image. You can start the view point by clicking the desktop icon. The following command can be used to verify the status in Linux/Unix: /etc/init.d/viewpoint status Viewpoint uses default 80 port number which means you can directly type your VM's IP address in your browser. You can search Teradata official documentation to find out more information: Viewpoint Configuration Guide
@Nik Once you logon with dbc, you can create your own account using the following SQL: CREATE USER user_name FROM database_name AS PASSWORD = user_password PERM = 10000000 SPOOL = 1000000 PERM: permanent space SPOOL: spool space BTW, in Teradata user is same as database except a user has a password associated. Please refer to manual for more details: http://www.info.teradata.com/do_redirect.cfm?itemid=102320036