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 version of vmware.

prerequisites

since the vm is 64 bit, your cpu must support 64-bit.

installation steps for windows

step 1 − download the required vm version from the link, https://downloads.teradata.com/download/database/teradata-express-for-vmware-player

step 2 − extract the file and specify the target folder.

step 3 − download the vmware workstation player from the link, https://my.vmware.com/web/vmware/downloads. it is available for both windows and linux. download the vmware workstation player for windows.

step 4 − once the download is complete, install the software.

step 5 − after the installation is complete, run the vmware client.

step 6 − select 'open a virtual machine'. navigate through the extracted teradata vmware folder and select the file with extension .vmdk.

step 7 − teradata vmware is added to the vmware client. select the added teradata vmware and click ‘play virtual machine’.

step 8 − if you get a popup on software updates, you can select ‘remind me later’.

step 9 − enter the user name as root, press tab and enter password as root and again press enter.

step 10 − once the following screen appears on the desktop, double-click on ‘root’s home’. then double-click on ‘genome’s terminal’. this will open the shell.

step 11 − from the following shell, enter the command /etc/init.d/tpa start. this will start the teradata server.

starting bteq

bteq utility is used to submit sql queries interactively. following are the steps to start bteq utility.

step 1 − enter the command /sbin/ifconfig and note down the ip address of the vmware.

step 2 − run the command bteq. at the logon prompt, enter the command.

logon <ipaddress>/dbc,dbc; and enter at the password prompt, enter password as dbc;

you can log into teradata system using bteq and run any sql queries.