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.
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:
As soon as you determine your system supports the requirements you can proceed:
Figure 1. VMware Server with VM's running
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 (
PRIMARY INDEX ( Test_field1 );
Create a file called "test" with 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 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.
|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)||184.108.40.206||1.9 GB||10 GB||4 GB||320 MB|
|Teradata Express 13.0 for VMware (40 GB)||220.127.116.11||1.9 GB||10 GB||40 GB||2 GB|
|Teradata Express 13.0 for VMware (1 TB)||18.104.22.168||2.9 GB||64 GB||1 TB||55 GB|
|Teradata Express 13.0 for VMware (40 GB, Japanese)||22.214.171.124||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.