Teradata ODBC Configuration on Linux

Summary
This article updates Teradata Client on Linux instructions from section 10.2 of the RevoScaleR Teradata Getting Started Guide to account for changes in the distribution and packaging of Teradata 14.10 ODBC client drivers since the publication of the guide.
More information
Ensure unixODBC has not been installed via rpm. If it has remove it prior to trying to install unixODBC 2.3.1.
# rpm -qa | grep unixODBC
 

This should return nothing; if any packages are listed, use yum to remove them:
# yum remove <package>
 

Install other prerequisite packages necessary for the successful build and installation of the drivers:
# yum install ksh

# yum install gcc

# yum install make

Create a link  to ksh so the tdodbc rpm will properly install:
# ln -s /bin/ksh /usr/bin/ksh

Build and install the unixODBC 2.3.1 driver manager:
# mkdir ~/downloads

# cd ~/downloads

# wget ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.1.tar.gz

# tar -zxf unixODBC-2.3.1.tar.gz

# cd unixODBC-2.3.1
 

By default configure will cause unixodbc to install under /usr/local/
# ./configure

# make

# make install
 

Install the Teradata ODBC drivers

Get the files:
# cd ~/downloads

# mkdir teradata_odbc

# cd teradata_odbc
 

Sign in to http://downloads.teradata.com/download/connectivity/odbc-driver/linux and download tdodbc__linux_indep.14.10.00.00-1.tar.gz to directory teradata_odbc.
# tar -zxf tdodbc__linux_indep.14.10.00.00-1.tar.gz

# tar -zxf tdicu__linux_indep.14.10.00.00-1.tar.gz 

# tar -zxf TeraGSS_linux_x64__linux_indep.14.10.00.06-1.tar.gz
Install RPMs:
# rpm -ihv tdicu/tdicu-14.10.00.00-1.noarch.rpm

# source /etc/profile

# rpm -ihv TeraGSS/TeraGSS_linux_x64-14.10.00.06-1.noarch.rpm 

# rpm -ihv tdodbc/tdodbc-14.10.00.00-1.noarch.rpm

Update ODBC ini files. To find the ini files enter:
# odbcinst -j

Edit odbcinst.ini (drivers) and add the following:
[Teradata]

Driver=/opt/teradata/client/14.10/odbc_64/lib/tdata.so

APILevel=CORE

ConnectFunctions=YYY

DriverODBCVer=3.51

SQLLevel=1

Edit odbc.ini (DSNs) and add the following.  Modify Username, Password and Database if desired otherwise leave blank:
[ODBC Data Sources]

TDDSN=tdata.so


[ODBC]

InstallDir=/opt/teradata/client/14.10/odbc_64

Trace=0

TraceDll=/opt/teradata/client/14.10/odbc_64/lib/odbctrac.so

TraceFile=/usr/joe/odbcusr/trace.log

TraceAutoStop=0


[TDDSN]

Driver=/opt/teradata/client/14.10/odbc_64/lib/tdata.so

Description=Teradata database

DBCName=<MachineName or ip>

LastUser=

Username=

Password=

Database=

Verify Teradata connection using isql:
# isql tddsn <username> <password>

+---------------------------------------+

| Connected!                            |

|                                       |

| sql-statement                         |

| help [tablename]                      |

| quit                                  |

|                                      |

+---------------------------------------+

SQL> select * from Database.Table;

SQL> quit; 

Modify LD_LIBRARY_PATH to so that Revolution R Enterprise can locate the driver:
# export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$(odbc_config --lib-prefix)

# echo $LD_LIBRARY_PATH

Example in Revolution R Enterprise (DSNless). Modify TeradataConnString parameters as needed:
TeradataConnString <- "DRIVER=Teradata;DBCNAME=machinename;DATABASE=databasename;UID=username;PWD=password;"

rxOdbcDS <- RxOdbcData(sqlQuery = "SELECT * FROM db.table", connectionString = TeradataConnString)

rxImport(rxOdbcDS)
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Propiedades

Id. de artículo: 3103282 - Última revisión: 10/26/2015 07:35:00 - Revisión: 1.0

Revolution Analytics

  • KB3103282
Comentarios