Teradata ODBC

[octogun]

Hi -

I am stumped at creating connection to Teradata.

import - table definitions - connector import wizard
allows ODBC connection and/or Teradata Connector

using ODBC Connector - attempt to create connection to Teradata.
get a error
Driver could not be loaded.

We have installed all packages of v12.
Please help I can provide more information.

thanks

[octogun]

connection failed
An exception occurred while trying to receive the response from the handler: An exception was received from the handler:ODBC function{0} reported : SQLSTATE = IM003: Native Error Code = 0: Msg =[DataDirect][ODBC lib] Specified driver could not be loaded

i am not quite clear where the issue is:
i have to manually edit a file or DataStage is looking for a file and its missing.


env is setup
LD_LIBRARY_PATH modifed to include TWB_ROOT
dsenv modified to include TWB_ROOT
Can you guru's please shed some light on the right procedure to connect to Teradata.
much appreciated if anyone can spread some magix

Hi -

I am stumped at creating connection to Teradata.

import - table definitions - connector import wizard
allows ODBC connection and/or Teradata Connector

using ODBC Connector - attempt to create connection to Teradata.
get a error
Driver could not be loaded.

We have installed all packages of v12.
Please help I can provide more information.

thanks

[octogun]

Q: Does /usr/ODBC/lib be put in LD_LIBRARY_PATH on in the env settings

[octogun]

The issue is this :
Teradata ODBC made it work but Teradata Connector to import metadata doesn't.
For Teradata ODBC > Configure .odbc.ini file in $DSHOME to use Teradata drivers.

The Resolution for Teradata Connector is:

DataStage is 32Bit which can run on 32bit or 64bit RHEL OS.
Our OS is 64bit.
When we installed Teradata client it detected 64bit OS and installed 64bit Teradata Client lib files.

We followed documentation but still DataStage was not able to locate Teradata lib file libtelapi.so.
most likely it was looking for a 32bit file but only found 64 bit file.

that's the reason we got error libcctera.so can't find libtelapi.so.

# ldd <path where libcctera.so is located>/libcctera.so
generates shared objects required. this tells us libtelapi.so is missing.

We will install 32bit Teradata client library and that should resolve Teradata Connector Error.

cheers