Cloud Computing is a computing service provisioning and delivery model in which users get access to dynamically scalable computing capacity over the network in a pay-as-you-use payment scheme. While its attractiveness may differ depending on whom you've talked to, its service-oriented nature gives users two important benefits: ease of application deployment (someone else's hard works laying down the hardware and software foundation) and on-demand access anytime from anywhere. These characterstics make Cloud Computing ideally suited for developers who want to quickly try something out in an isolated "good" environment without the overhead of system setup or the capital expenses of paying for systems they no longer need after they are done. 

In the past Teradata provided developers a Teradata Express Edition that runs on top of Windows 32-bit platform. Like all programs with installers, it required that users first find a system, then go through the installation, deal with any unexpected setup problems, and finally uninstall and repurpose the system for something else. Now, Teradata Express 12 for Amazon EC2 is set to change the paradigm and makes developers' life simpler and better.

Teradata Express 12 for Amazon EC2 runs on top of Novell SLES10 and the industry-leading Amazon EC2 Cloud Computing platform. It has Teradata database 12.0 and client utilities pre-installed and sample databases included. The old Express Edition limitation with 4GB storage has now been expanded to 1TB, giving developers more freedom to experiment with larger datasets and with more real-life development and testing needs. If you are interested, this post will show you how to automatically setup Teradata Express 12 for Amazon EC2 using an automated script.  Note, this article assumes that you have some working knowledge of Amazon EC2 platform.

Please note that while this product is not officially supported, you can talk to other users and get help in the Cloud Computing forum.

Prerequisites

  1. Have your Amazon AWS account credential ready (if you don't yet have an account, sign up at http://aws.amazon.com/).
  2. Register with us for Teradata Express 12.0 for Amazon EC2.
  3. Once you receive a confirmation email from us, proceed to the next section.

How to Connect to Amazon AMI Instance(s)

There are two ways to connect to Amazon AMI instances.  You can use Amazon EC2 API Tools, which is a command line interface with Amazon AMI.  The installation procedures for it can be found here.  Or, you can use ElasticFox, which is an Amazon Firefox extension to manage Amazon AMI instances over the web.  The setup reference for it can be found here.

Launch a New Instance of Teradata Express 12 for Amazon EC2

Using either the Amazon EC2 API tools or the ElasticFox, the instructions to launch a new instance of Teradata Express 12 for Amazon EC2 is simple and straightforward.  We will demonstrate the steps using either tools.

Amazon EC2 API Tools

After you set up Amazon EC2 API Tools, you can launch an instance by running the following command "ec2-run-instances ami-id  -k gsg-keypair --instance-type m1.large --availability-zone us-east-1b". Replace ami-id with Teradata Express 12 for Amazon EC2 ami-id of ami-85d536ec  (Note: the ami ID may change in the future so check your confirmation email) instance-type ( m1.large or higher) and availability-zone can also be changed if desired.  

Once the instance is launched, you can check the status of the launched instance: "ec2-describe-instances instance-id" by giving the id of the instance we just launched.  So you can connect to the database you need to grant permission on port 1025 of the launched instance: "ec2-authorize default -p 1025 -s source_subnet" so that the database can be accessed from outside of the Amazon EC2 network.  To run the command, change source_subnet range to fit your network.  (Example: 205.192.0.0/16, or 0.0.0.0/0)

Finally, upload through SSH credential files (cert_xxxx.pem and pk_xxxx.pem) to a location under /mnt in the launched instance. (Example: scp –i rsa-key pair-file private-key-file certificate-file root@<instance-address>:/mnt/)

Note:
 

  • Regarding how to get your credential files, please log in http://aws-portal.amazon.com/gp/aws/developer/account/index.html?action=access-key, Click Create New in the "Your X.509 Certificate" section to create a new X.509 certificate.
  • Regarding how to set up Amazon EC2 API Tools, please refer to http://docs.amazonwebservices.com/AWSEC2/2008-08-08/GettingStartedGuide/index.html?setting-up-your-tools.html, "Setting up the Tools" section.
  • Regarding how to generate your key pair file (-i option specify), please refer to http://docs.amazonwebservices.com/AWSEC2/2008-08-08/GettingStartedGuide/index.html?setting-up-your-tools.html, "Running an Instance->Linux and UNIX->Running an Instance->Generating an SSH Key Pair" section.

ElasticFox

You can launch ElasticFox by clicking on “Tools” menu in Mozilla Firefox and selecting “ElasticFox”.  If this is the first time you use ElasticFox, you will be prompted to enter your AWS credentials.  You can later modify your credentials by clicking on the” Credentials” button in the top center of the ElasticFox window.  Your Access Key and Secret Key can be found under the “Your Account” menu at http://aws-portal.amazon.com/gp/aws/developer/account/index.html?action=access-key.  Click on Add button when credential information is entered and then click on Close button.

Once logged in, click on "Images" tab and type into the textbox right below the "Images" tab Teradata Express 12 for Amazon EC2 ami-id, which is ami-85d536ec (Note: ID may change in the future so check your confirmation email).  Then, right click on the AMI and select Launch Instance(s) of this AMI.

Subsequently, in the pop-up Launch new Instance(s) window, select Instance Type if desired.  Finally, click on Launch button at the bottom of the window.

Once your Teradata Express 12 for Amazon EC2 instance is launched,  grant permission on port 1025 so that the database can be accessed from outside of the Amazon EC2 environment.  To do so, go to the "Security Groups" tab and right click on the owner ID and select "Grant New Permissions".

Finally, attach EBS volumes to your instance.  To do so, click on the “Volumes and Snapshots” tab in ElasticFox, then press the green "+" symbol in the “Volumes” box and type in the size in gigabytes (GB) of the volume, between 1 and 1000. For the purposes of this demo, we type “16” to specify a 16 GB volume.  Please note that each Teradata database AMP will require minimum of 1 EBS volume (e.g. 2 AMP => need to add 2 volumes).  In addition, a volume must be in the same availability zone as the instance that it will be attached to.

After the volume is created, we can attach it to a running instance.  First, click on the “AMIs and Instances” tab.  Right click on the instance to associate the EBS volume with and select the “Attach an EBS volume” option. A dialog box will appear and it allows you to select the Amazon EBS volume that was created earlier from the drop down box and a device name need to be entered in order to attach the volume. 

After clicking on the Attach button, the EBS volume will be attached.  Repeat for each volume.

Run Automated Setup Script

You can use a SSH client (ssh, Putty, etc) to connect to the external IP address of the instance, make sure you specify your rsa key file with the connection attempt.  Setup scripts would automatically run at the first log-in.  First, you will be prompted to accept software license agreement.  Type y or simply press Enter.

Once you have accepted the Teradata Express 12 for Amazon EC2 license agreement, the automated setup script will prompt you to initialize the database.  Type y or simply press Enter.

The next step is to change to your own dbc password for better security.  Choose a new password for dbc and press Enter.

If you attach your EBS volume through ElasticFox, skip to next screen. Otherwise, if you had your credential file uploaded in API Tools section, the script will automatically add and attach EBS volumes to the database.  You will be prompted for a few setup parameters.  Go ahead and accept the default values and press Enter.

If you have chosen to attach the EBS volumes in ElasticFox, the script is going to give you a warning, and you will be prompted to select the available volumes to setup database on.  

Either way, the setup script will run for some time.  After the instance's database has successfully ran Sysinit and DIP, the script will prompt you to create the sample database.  Type y or press Enter.

After the sample database is created, the setup for a Teradata Express 12 for Amazon EC2 instance is complete and the AMI instance can be used.

Validate Teradata Express Database Setup using Client Utilities

You can use your favorite Teradata client utilities to log onto the new Teradata Express 12 for Amazon EC2 instance and run queries to validate the Teradata Express database setup.  In the example below we use bteq but you can using any other supported client utilities (SQL Assistant Java Edition, etc).  Execute a simple query "select * from dbc.dbcinfo;"

The query returned successfully and your Teradata Express 12 for Amazon EC2 instance database setup is now validated.

Done

You now have a fully functioning version of Teradata 12 running in the Amazon cloud. Have fun! And don't forget to terminate your instance if you are done with it. If you leave it running you will incur usage charges! Note: If you terminate your instance you will have to go through the setup again, and you will lose all your data.  Make sure you backup your data and any needed Teradata configuration files in /etc/opt/teradata/tdconfig.

Also, 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.

Discussion
ronwarshawsky 1 comment Joined 11/09
08 Nov 2009

ami-85d536ec is not showing up

ChinaGuy 1 comment Joined 09/09
08 Nov 2009

Have you registered through the sign-up page? If you have done that already, please send an email to us with your Amazon account name and we will look into it.

mercutio 1 comment Joined 02/10
19 Feb 2010

Hey Guys,

Has anyone successfully registered and given access to the Teradata Express 12 for Amazon EC2? I've registered twice and gotten the following delivered to my email twice.... with no further followup from Teradata and no teradata ami visible in my AWS...

Mercutio
===================
Thank you for your interest in Teradata Express 12 on Amazon EC2.

An Amazon EC2 account is required to use this software. If you have not already done so please send us your Amazon account reference number so we can activate your account. This process will take approximately 24 hours. Please expect to hear from us by the end of the next business day.

Other tools, utilities and support forums are available at our Developer Exchange – http://developer.teradata. com

Regards,

djleon2001 1 comment Joined 09/10
03 Sep 2010

i cannot login to the instance using SSH , it is asking me for a password , even when I am providing my rsa key.

ssh -i keypair.pem root@ec2-xx-xx-xx-xx.compute-1.amazonaws.com

Any idea why is asking for a password ?

Message :
Permission denied (publickey,keyboard-interactive).

ulrich 51 comments Joined 09/09
02 Nov 2010

Hi, same problem. I am registered. Instance is running. Key exists. ssh with key still requires a password.
Did anybody ever was able to start a Amazon Teradata instance?
Ulrich

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

vykhand 1 comment Joined 08/10
27 Nov 2010

I had the same problem when it was asking for a passphrase, solved it by removing Everyone group from .pem file's permissions on Windows.

the root initial password is root.

wanted to test whether it is working on microinstance, which is free since Nov 1st, but unfortunately it couldn't pass the initialization phase.

Andrey.

kw 4 comments Joined 05/09
18 Mar 2011

I now have a micro instance running, but it is showing as Teradata 13.0 :

select * from dbc.dbcinfo;

*** Query completed. 3 rows found. 2 columns returned.
*** Total elapsed time was 1 second.

InfoKey InfoData
------------------------------ --------------------------------------------
RELEASE 13.00.00.19
VERSION 13.00.00.19
LANGUAGE SUPPORT MODE Standard

jean.mango 1 comment Joined 06/11
05 Jun 2011

I've registered twice and gotten the following delivered to my email twice.... with no further followup from Teradata and no teradata ami visible in my AWS...

Thank you for your interest in Teradata Express 13.10 on Amazon EC2.

An Amazon EC2 account is required to use this software. If you have not already done so please send us your Amazon account reference number so we can activate your account. This process will take approximately 24 hours. Please expect to hear from us by the end of the next business day.

Other tools, utilities and support forums are available at our Developer Exchange – http://developer.teradata.com/node/416

Regards,

Teradata Fulfillment Center

What next ?

RW255006 3 comments Joined 12/10
16 Jun 2011

..This process will take approximately 24 hours...

In my case it's more then 48 hrs, can somebody activate my account for TD13.10 ?

My Amazon id is ending with: ... 2229

Thanks,
R.

Diyotta 1 comment Joined 08/11
04 Nov 2011

hi , I have registered couple of times with Amazon account number , but i never got access.. Please help

Thanks
Ravindra

clindroth 1 comment Joined 10/11
15 Nov 2011

Ravindra,

Send info directly to me at cliff.lindroth@teradata.com.

I'll check on the hold up.

ChayakiranS 1 comment Joined 01/12
13 Jan 2012

I did register for the download, but did not get any email confirmation.

And i do not see 'ami-85d536ec' in my amazon account. Please help.

Thanks,
Chayakiran

DaveWellman 5 comments Joined 01/06
16 Jan 2012

Hi,
I'm trying to get a TD13.10 instance running and am having problems.

I've worked through the above 'translating' from TD12 to 13.10 where necessary and get to the stage where I login to my instance and run the TD 'initialization' scripts.

I get asked to set the DBC password (which I set to 'DBC').

There are no disks to add but I think that's ok because I've added them (as "/dev/???") as EBS using ElasticFox.

When I click the 'go' button I get a few lines of output, very quickly but then nothing else happens. The Putty window is non-responsive. I have left it for @2 hours now and it is still not responding to key storkes or mouse button clicks.

The output in the putty window is:

LEFT-HAND side
|Configuring Teradata│
│EC2: │
│ │
│Instance-type: │
│m1.large │
│Availability Zone: │
│us-east-1c │
│System Type: SMP │
│Disk Devices: /dev/ │
│Total Capacity: 0 G │
│Sample Database: Y │
│ │
│ │
│This process may │
│take 20-60 minutes │
│ │
│ │

RIGHT-HAND side
┌──────────────────────────────────────────────┐
│Mon Jan 16 03:15:12 PST 2012 Starting Teradata│
│initialization ... │
│ │
│ * [X] Done generating configuration files. │
│ * [X] Done distributing configuration files │
│ to all the nodes. │
│ * => Starting to set the swap space ... │
│ * [X] Done setting the swap space. │
│ * => Starting to initialize the PDISKs ... │
│ * [X] Mon Jan 16 03:15:17 PST 2012 Done │
│ initializing the PDISKs. │
│ * => Mon Jan 16 03:15:17 PST 2012 Starting │
│ to run 'sysinit' ... │
│ * Done configuring SMP (PDE part). │

I've just noticed that in the 'summary' info on the left it says "capacity 0G" which probably means that I've got no disks attached / defined. Where did I go wrong ? Any ideas ?

Cheers,
Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com

You must sign in to leave a comment.