Teradata Express 14 installation

Teradata Express for VMware player

http://downloads.teradata.com/download/database/teradata-express/vmware (you need to register)

Installing VMware player in Ubuntu

https://help.ubuntu.com/community/VMware/Player

Note: gksudo bash ./Downloads/VMware-Player-3.1.4-385536.i386.bundle didn't work for several reasons:

• Filename differs not just due to version but also the downloaded file has a txt-suffix
• You need to make file executable and then run gksudo ./downloads/VM...bundle.txt

Actual installation process

The user guide for Teradata installation: http://developer.teradata.com/database/articles/teradata-express-14-0-for-vmware-user-guide Note:

• I needed to add support for 64bit virtualization in my BIOS (Thinkpad T430).
• I rebooted my system after installation and I needed to install VMware modules into the kernel again, it didn't do this automatically but when I ran sudo vmware-modconfig --console --install-all everything worked.
• I first followed some official guide which didn't very clearly demonstrate how to access the database from the command line, the above link is a lot better

JDBC

Teradata JDBC needs to be downloaded by hand: http://downloads.teradata.com/download/connectivity/jdbc-driver I used Maven to locally install them (note you need to also install the config):

mvn install:install-file -Durl=file:repo -DgroupId=com.teradata -DartifactId=teradata-jdbc -Dversion=13.10.00.35 -Dpackaging=jar -Dfile=terajdbc4.jar
mvn install:install-file -Durl=file:repo -DgroupId=com.teradata -DartifactId=teradata-config -Dversion=13.10.00.35 -Dpackaging=jar -Dfile=tdgssconfig.jar

Here is some Clojure code demonstrating JDBC access:

(ns teradata
  (:require [clojure.java.jdbc :as j]
            [clojure.java.jdbc.sql :as s]))

(def teradata-db
  {:subprotocol "teradata"
   :classname "com.teradata.jdbc.TeraDriver"
   :subname "//172.16.56.128/dbc"
   :user "dbc"
   :password "dbc"})

(j/query teradata-db (s/select * :dbcinfo))

And the project.clj:

(defproject teradata "0.1.0-SNAPSHOT"
  :dependencies [[org.clojure/clojure "1.5.1"]
                 [org.clojure/java.jdbc "0.3.0-alpha4"]
                 [com.teradata/teradata-jdbc "13.10.00.35"]
                 [com.teradata/teradata-config "13.10.00.35"]])