Teradata Express for VMware Player (TDE-V) is a free, fully operational Teradata Virtual Machine with up to one terabyte of storage. Imagine being able to install a fully operational Teradata database on your PC and be running queries in five minutes, easy as 1-2-3.
To help you load data, the new Teradata EZLoader utility is included in the VM.
Depending upon your needs and the resources available on your PC, two versions of Teradata Express14.10 are available at this time. Please note that the resources needed for Teradata Express are in addition to those needed by the operating system on your PC:
A 64-bit virtualization-capable PC is required. VMware provides a utility to check your system for 64 bit support at this link.
Please note that while the Teradata Express family of products is not officially supported, you can talk to other users and get help in the Cloud Computing forum. Note also that Japanese-language instructions for configuring TDE-V are available for download in PDF format.
The first task is to make sure you have a system capable of handling VMware and VM’s. There are plenty of details on the VMware site but here are some basic requirements that you should be aware of before getting started:
As soon as you determine your system supports the requirements you can proceed:
It's time to run VMware Player and start Teradata Express. From the VMware Player Welcome page, choose "Open a Virtual Machine" and click your way through your file directory to the Teradata Express folder, looking for the "TDExpress14.10_sles10.vmx" or "TDExpress14.10_sles11.vmx"file.
Figure 1. Loading the TD Express virtual machine in VMware Player
I MOVED IT!
This step is very important. As you click through the virtual image directories, VMware is looking for the .vmx file, in order to start the image. Once you find it, double-click or choose the 'Open' option. VMware will now present you with a dialog box asking if you copied or moved this image. Be sure to choose 'I MOVED IT'!
virtual-machines". After unzipping (7-zip) the file you will end up with something like “C:\virtual-machines\TD14..”.
TDExpress14.0_Sles10:~ # bteq
*** Logon successfully completed).
select * from dbcinfo;
*** Query completed. 3 rows found. 2 columns returned.
*** Total elapsed time was 1 second.
LANGUAGE SUPPORT MODE Standard
Figure 2. Testing Teradata using BTEQ
If you are running the SLES 11 image without Viewpoint, skip over this next section and go right to Loading Data.
You have the option of running Viewpoint on TD Express 14.10 with the 1TB, SLES 10 image only. To see all you can do with Viewpoint look here.
To login to Viewpoint follow the steps below.
On the Teradata version 14.0 VM’s the new EZloader utility is included for fast and easy data loads. Here's an example of loading some data from a comma-separated file (i.e.. a CSV). From BTEQ, run the following:
CREATE user vmtest AS password=vmtest perm=524288000 spool=524288000;
CREATE SET TABLE vmtest.test ,
NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT (
PRIMARY INDEX ( Test_field1 );
Create a file called
testwith contents that look something like this:
Run the load utility:
/opt/teradata/client/13.0/tbuild/bin/tdload -f test -u vmtest -p vmtest -t test
That is it, data loaded!
You can use the Teradata Studio Express to run queries against the database. You can learn more about Teradata Studio Express, and download Teradata Studio Express versions for various platforms. Finally...
Please note that while Teradata Express for VMware is a free, unsupported product, you can talk to other users and ask for help over in the Cloud Computing forum.