Create a remote SDA with Teradata
This is steps to create a SDA connection To Teradata with HANA Studio .
First you have to install Teradata Driver.
You have to download driver from Teradata Site :
http://downloads.teradata.com/download/connectivity/odbc-driver/linux
I already Tried with version 13, 14 and 15 of Teradata Driver.
The Doc here will talk about version 15 of Teradata Driver as it’s supported now by SAP but it will be the same for Older Drivers.
to install the driver and all its dependencies please follow this steps :
1 Download :
tdodbc__linux_indep.15.00.00.03-1.tar.gz (ODBC Terada Driver)
(containing tdicu and TeraGSS required for Teradata to work properly)
2 login as root :
tar -xvf tdodbc__linux_indep.15.00.00.03-1.tar.gz
cd tdodbc
rpm -ivh tdodbc-15.00.00.03-1.noarch.rpm –nodeps
this will install Teradata Driver into /opt/teradata (without dependencies )
tar -xvf cliv2_LINUX_indep.15.00.00.04.tar.gz
cd TeraGSS/
rpm -ivh TeraGSS_linux_x64-15.00.02.01-1.noarch.rpm
cd tdicu/
rpm -ivh tdicu-15.00.00.00-1.noarch.rpm
now it’s done with the Teradata drivers and dependencies
(even if the Driver’s official documentation suppose that you don’t have to add the driver path to $LD_LIBRARAY_PATH, it’s recommended to add it manually to avoid any error message)
now we have to configure the .odbci.ini file in the <SID>adm /home :
Here how to the .odbci.ini file has to look like :
[ODBC]
InstallDir=/opt/teradata/client/15.00/odbc_64
Trace=0
TraceDll=/opt/teradata/client/15.00/odbc_64/lib/odbctrac.so
TraceFile=/usr/joe/odbcusr/trace.log
TraceAutoStop=0
[ODBC Data Sources]
testdsn=tdata.so
[testdsn]
Driver=/opt/teradata/client/15.00/odbc_64/lib/tdata.so
Description=Teradata database
DBCName=Teradata_server_ip
LastUser=Username
Username=Username
Password=password
Database=Teradata_database
DefaultDatabase=teradata_database
(Of course you have to change info with your own credentials ( teradata_server_ip, username, password, Teradata_database)
Now it’s time to make test our configuration from Console Command line
connecto to SSH with <SID>adm user
hdbsdautil -t tdodbc -S “dsn=testdsn” -U username -P password -info
if everything is working well so we just have to restart Hana (even if it’s not mentioned in the Hana Official Documentation )
HDB stop
HDB start
Now we have to create the SDA rempte connection in HANA Studio :
Open Hana Studio and login in the System with user <SID>adm
Go to ‘ Provisionning” > Remote Source > New Remote Source
Done
Thank you