84 Teradata Data Warehouse

To install the Teradata packages (which come as rpm packages) on Debian amd64, we need a mix of manual install and use of the alien command. alien works fine for amd64 but we need the 32 bit libraries for some of the functionality.

The script below automatically install the packages assuming the sourced .tar.gz files are in a folder called tar. The tar files are downloaded from Teradata. This then allows 32 bit bteq to work just fine, as well as 32 bit SAS version 9.1. For the 64 bit side, SAS 9.2 and ODBC with R and isql work just fine.

#!/bin/sh 
# 
# Copyright (c) 2010 Graham.Williams@ato.gov.au 
# 
# Install TD12 from tar files in the tar folder. 
# Convert where possible to Debian packages. 
# Install both 32 bit (for bteq and sas_9.1) and 64 bit (for sas, odbc) 
# Use Debian's alien to convert to Debian packages then install. 
# For 32 bit use alien to extract all files, and then manually install. 
# 
######################################################################## 
# Ensure directories are setup appropriately.

if [ ! -d /opt/teradata ]; then sudo mkdir /opt/teradata; fi

TGZ=".tar.gz"

# 
######################################################################## 
# Install 32 bit - can't create deb pacakges because of different arch

ARCH="__linux_i386." 
RPM=".i386.rpm" 
BIT=""

# 32 bit tdicu

PKG="tdicu" 
DIS="" 
VER="12.00.00.02" 
REL="-1"

tar xvf tar/${PKG}${DIS}${ARCH}${VER}${REL}${TGZ} 
fakeroot alien -dcs ${PKG}/${PKG}${DIS}${BIT}-${VER}${REL}${RPM} 
sudo cp -R ${PKG}${DIS}${BIT}-${VER}/opt/teradata /opt/ 
sudo cp -R ${PKG}${DIS}${BIT}-${VER}/usr/lib/* /usr/lib32/ 
sudo sh ${PKG}${DIS}${BIT}-${VER}/debian/postinst 
rm -rf ${PKG} ${PKG}${DIS}${BIT}-${VER}

# 32 bit TeraGSS

PKG="TeraGSS" 
DIS="_redhatlinux-i386" 
VER="12.00.03.09" 
REL="-1"

tar xvf tar/${PKG}${DIS}${ARCH}${VER}${REL}${TGZ} 
fakeroot alien -dcs ${PKG}/${PKG}${DIS}${BIT}-${VER}${REL}${RPM} 
sudo cp -R ${PKG}${DIS}${BIT}-${VER}/opt/teradata /opt/ 
sudo cp -R ${PKG}${DIS}${BIT}-${VER}/usr/teragss /usr/ 
# The postinst script finally aborts, but does set other things up 
# first. It aborts at the end with run_tdgssconfig. This should create 
# the .bin file, but does not. So copy a previous .bin file across. 
sudo sh ${PKG}${DIS}${BIT}-${VER}/debian/postinst 
sudo install tdgssconfig.bin /opt/teradata/teragss/redhatlinux-i386/${VER}/etc/ 
rm -rf ${PKG} ${PKG}${DIS}${BIT}-${VER}

# 32 bit piom

PKG="piom" 
DIS="" 
VER="12.00.00.04" 
REL="-1"

tar xvf tar/${PKG}${DIS}${ARCH}${VER}${REL}${TGZ} 
fakeroot alien -dcs ${PKG}/${PKG}${DIS}-${VER}${REL}${RPM} 
sudo cp -R ${PKG}${DIS}${BIT}-${VER}/opt/teradata /opt/ 
sudo cp -R ${PKG}${DIS}${BIT}-${VER}/usr/lib/* /usr/lib32/ 
sudo cp -R ${PKG}${DIS}${BIT}-${VER}/usr/include /usr/ 
sudo sh ${PKG}${DIS}${BIT}-${VER}/debian/postinst 
rm -rf ${PKG} ${PKG}${DIS}${BIT}-${VER}

# 32 bit cliv2

PKG="cliv2" 
DIS="" 
VER="12.00.00.06" 
REL="-1"

tar xvf tar/${PKG}${DIS}${ARCH}${VER}${REL}${TGZ} 
fakeroot alien -dcs ${PKG}/${PKG}${DIS}${BIT}-${VER}${REL}${RPM} 
sudo cp -R ${PKG}${DIS}${BIT}-${VER}/opt/teradata /opt/ 
sudo cp -R ${PKG}${DIS}${BIT}-${VER}/usr/lib/* /usr/lib32/ 
sudo cp -R ${PKG}${DIS}${BIT}-${VER}/usr/include /usr/ 
sudo sh ${PKG}${DIS}${BIT}-${VER}/debian/postinst 
rm -rf ${PKG} ${PKG}${DIS}${BIT}-${VER}

# 32 bit bteq

PKG="bteq" 
DIS="" 
VER="12.00.00.04" 
REL="-1"

tar xvf tar/${PKG}${DIS}${ARCH}${VER}${REL}${TGZ} 
fakeroot alien -dcs ${PKG}/${PKG}${DIS}${BIT}-${VER}${REL}${RPM} 
sudo cp -R ${PKG}${DIS}${BIT}-${VER}/opt/teradata /opt/ 
sudo cp -R ${PKG}${DIS}${BIT}-${VER}/usr/bin /usr/ 
sudo cp -R ${PKG}${DIS}${BIT}-${VER}/usr/include /usr/ 
sudo sh ${PKG}${DIS}${BIT}-${VER}/debian/postinst 
rm -rf ${PKG} ${PKG}${DIS}${BIT}-${VER}

# 
######################################################################## 
# 64 bit

ARCH="__linux_x8664." 
RPM=".x86_64.rpm"

# 64 bit cliv2

PKG="cliv2" 
pkg=$(echo ${PKG} | tr [:upper:] [:lower:]) 
DIS="" 
BIT="_64" 
VER="12.00.00.07" 
REL="-1"

tar xvf tar/${PKG}${DIS}${ARCH}${VER}${REL}${TGZ} 
fakeroot alien -dck ${PKG}/${PKG}${DIS}${BIT}-${VER}${REL}${RPM} 
wajig install ${pkg}${DIS}-64_${VER}${REL}_amd64.deb 
rm -rf ${PKG} ${PKG}${DIS}-64_${VER}${REL}_amd64.deb

# 64 bit TeraGSS

PKG="TeraGSS" 
pkg=$(echo ${PKG} | tr [:upper:] [:lower:]) 
DIS="_suselinux-x8664" 
dis=$(echo ${DIS} | tr _ -) 
BIT="" 
VER="12.00.02.13" 
REL="-1"

tar xvf tar/${PKG}${DIS}${ARCH}${VER}${REL}${TGZ} 
fakeroot alien -dck ${PKG}/${PKG}${DIS}${BIT}-${VER}${REL}${RPM} 
wajig install ${pkg}${dis}_${VER}${REL}_amd64.deb 
rm -rf ${PKG} ${pkg}${dis}_${VER}${REL}_amd64.deb

# 64 bit tdicu

PKG="tdicu" 
pkg=$(echo ${PKG} | tr [:upper:] [:lower:]) 
DIS="" 
dis=$(echo ${DIS} | tr _ -) 
BIT="_64" 
VER="12.00.00.02" 
REL="-1"

tar xvf tar/${PKG}${DIS}${ARCH}${VER}${REL}${TGZ} 
fakeroot alien -dck ${PKG}/${PKG}${DIS}${BIT}-${VER}${REL}${RPM} 
wajig install ${pkg}${dis}-64_${VER}${REL}_amd64.deb 
rm -rf ${PKG} ${PKG}${DIs}-64_${VER}${REL}_amd64.deb

# 64 bit ODBC

PKG="tdodbc" 
pkg=$(echo ${PKG} | tr [:upper:] [:lower:]) 
DIS="" 
dis=$(echo ${DIS} | tr _ -) 
BIT="" 
VER="12.00.00.05" 
REL="-1"

tar xvf tar/${PKG}${DIS}${ARCH}${VER}${REL}${TGZ} 
fakeroot alien -dck ${PKG}/${PKG}${DIS}${BIT}-${VER}${REL}${RPM} 
wajig install ${pkg}${dis}_${VER}${REL}_amd64.deb 
rm -rf ${PKG} ${PKG}${DIs}_${VER}${REL}_amd64.deb

# All Done 
########################################################################


Your donation will support ongoing availability and give you access to the PDF version of this book. Desktop Survival Guides include Data Science, GNU/Linux, and MLHub. Books available on Amazon include Data Mining with Rattle and Essentials of Data Science. Popular open source software includes rattle, wajig, and mlhub. Hosted by Togaware, a pioneer of free and open source software since 1984. Copyright © 1995-2022 Graham.Williams@togaware.com Creative Commons Attribution-ShareAlike 4.0