Introduction to Teradata Express for VMware Player
Teradata Express for VMware (TDE-V) is a free, fully operational Teradata VM 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.
- Install the VM
- Start the VM and Teradata
- Use the Teradata SQL Assistant Java Edition to run queries
To help you load data, the new Teradata EZLoader utility is included in the VM. Also, you can go as far as having a Teradata 12 VM and a Teradata 13 VM running at the same time to easily compare release features and test queries in both environments.
Depending upon your needs and the resources available on your PC, four versions of TDE-V are available: One Terabyte versions of Teradata releases 12 and 13 which require 60 GB of disk space for installation and 40GB versions of Teradata releases 12 and 13 which require 10GB of disk space for installation. 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:
- Since the SLES10 VM’s are 64-bit, your CPU must support 64-bit operation.
- Your CPU must also support Virtualization. Generally there is a BIOS setting which enables this. Google the topic for your particular CPU for more information but most recent PC’s support both 64-bit and Virtualization.
As soon as you determine your system supports the requirements you can proceed:
Figure 1. VMware Server with VM's running
- VMware Player and VMware Server are both available for free download from the VMware site and both will work. This tutorial describes using VMware Server (hosted on a Windows system). If you have not already done so, make your choice and install VMware on your system.
- Disk space is a big consideration. Both 40GB and 1TB versions of TDE-V are available depending on your resources and need. Typically you don't actually need the full amount of available disk space (although this would be advisable) to install and get started. Also, isolating VM’s on their own physical disks (if available) can improve performance. Some additional information about disk space is provided below.
- Download the appropriate TDE-V image from the downloads section.
- Create a directory on your C:\ drive named "virtual-machines". After unzipping (Winzip) the file you will end up with something like “C:\virtual-machines\TD13..”.
- Now you need to add the VM to the VMware inventory. Using VMware Server (see Figure 1 above for reference):
- Click on the summary tab (in VMware Web interface)
- In the "Commands" window, click on the "Add Virtual machine To Inventory" link
- Drill down under inventory, highlight the folder (sles10_TD1300) and item in contents (sles10.vmx), OK
- The "Register Virtual Machine" should indicate "Success"
- The VM will show up under "Virtual Machines" tab and can be started and stopped
- Access new VM using the console
- VMWare Server Home Page
- Under Inventory, select the VM
- Click on the console Tab
- Install the console plugin (if necessary)
- Click in the window to open up the interface to the virtual machine
- VMWare Server Home Page
- Login into the SLES10 VM with username root and password root.
- Enter a cop entry in the linux hosts file (/etc/hosts accessible from the linux command line in the VMware console, ie. c:>vi /etc/hosts)
- Should be something like "192.168.186.128 hyperjcop1 dbccop1"
- Use "/sbin/ifconfig" command on linux vm to find the ipaddress
- Teradata is ready to come up (/etc/init.d/tpa start) (See Figure 2)
- The pdisks are defined, sysinit is complete, config has been run and the dip scripts are complete.
- Test with bteq (bteq is the standard Teradata command line query tool, it can be invoked from the Linux command line in the VMware console, ie. c:>bteq)
- bteq (commands)
- logon dbc/dbc
- select * from dbcinfo;
Figure 2. Starting Teradata
On the Teradata version 13 VM’s the new EZloader utility is included for fast and easy data loads. I tested this utility (I’m no sql expert) using a comma separated file and follows and I will mention the steps here to give you an idea:
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 ( Test_field1 INTEGER, Test_field2 INTEGER) PRIMARY INDEX ( Test_field1 );
Create a file called "test" with contents that look something like this:
1,1 2,2 3,3
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 SQL Assistant Java Edition (SQLA-JE) to run queries against the database. You can learn more about SQLA-JE, and download SQLA-JE versions for various platforms. It's also included in the VM, and can be invoked from the /teradatasqla directory.
Version space requirements
|Package name||Version||Download size||Initial file space required||Teradata capacity||Initial Teradata PDisk size|
|Teradata Express 12.0 for VMware (40 GB)||12.0.03.14||2.3 GB||10 GB||40 GB||1.2 GB|
|Teradata Express 12.0 for VMware (1 TB)||12.0.03.14||2.0 GB||60 GB||1 TB||56 GB|
|Teradata Express 13.0 for VMware (4 GB)||220.127.116.11||1.9 GB||10 GB||4 GB||320 MB|
|Teradata Express 13.0 for VMware (40 GB)||18.104.22.168||1.9 GB||10 GB||40 GB||2 GB|
|Teradata Express 13.0 for VMware (1 TB)||22.214.171.124||2.9 GB||64 GB||1 TB||55 GB|
|Teradata Express 13.0 for VMware (40 GB, Japanese)||126.96.36.199||1.9 GB||10 GB||40 GB||2 GB|
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.