How to install Teradata 13.10 ODBC driver for BI 4.0 on the Linux.

(1)http://downloads.teradata.com/download/connectivity/cliv2/linux

download cliv2_LINUX_indep.13.10.00.15.tar.gz and unzip it.

(2)install suselinux and redhatlinux TeraGSS(i386 and X8664)

(3)install tdicu

(4)http://downloads.teradata.com/download/connectivity/odbc-driver/linux

Download tdodbc__linux_indep.13.10.00.11-1.tar.gz

(5)install ODBC driver.

Note:when downloading the cliv2 and odbc, need to down the “indep” version not “s390” version.

After that configure ODBC ini and BO userver profile.

  • odbc.ini sample:

[ODBC Data Sources]

testdsn=tdata.so

[testdsn]

Driver=/opt/teradata/client/ODBC_64/lib/tdata.so

Description=Teradata running Teradata V1R5.2

DBCName=127.0.0.1

LastUser=

Username=dbc

Password=dbc

Database=dbc

DefaultDatabase=dbc

CharacterSet=UTF8

IANAAppCodePage=106

odbc32.ini sample:

[ODBC Data Sources]

testdsn=tdata.so

[testdsn]

Driver=/opt/teradata/client/ODBC_32/lib/tdata.so

Description=Teradata running Teradata V1R5.2

DBCName=127.0.0.1

LastUser=

Username=dbc

Password=dbc

Database=dbc

DefaultDatabase=

CharacterSet=UTF8

IANAAppCodePage=106

.profile sample:

export ODBCINI=/home4/boeuser/bobje/sap_bobj/enterprise_xi40/odbc.ini

export ODBCINI32=/home4/boeuser/bobje/sap_bobj/enterprise_xi40/odbc32.ini

export BOE_USE_32BIT_ENV_FOR=ODBCINI

Regards

Randy

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply