All Forums Tools
gangadharan 6 posts Joined 08/11
06 Sep 2011
TPT Oracle JDBC connection

Hi,

I am not able to Connect an Oracle Database Using the JDBC connection from TPT. I am using others tools which uses JDBC connection without any problem.

Can any one suggest good documentation for migrating data from Oracle to Teradataa?.

If ODBC connection is the recommanded one, then please let me know which ODBC driver is the best one to use (apart from Data Direct ODBC Driver for Oracle)

gangadharan 6 posts Joined 08/11
06 Sep 2011

HI,

Is there any Open source ODBC driver supported by Teradata TPT.

gangadharan 6 posts Joined 08/11
07 Sep 2011

Whenevenn i tried to connect using JDBC connection, TPT throws exception that Oracle_home not configured properly. i have defined ORACLE_HOME in the environment variables but still it throws exception.

can any one help on this?

feinholz 1234 posts Joined 05/08
07 Sep 2011

We do not certify with any open source ODBC driver.

The only ODBC driver with which we certify is DataDirect (now called Progress).

 

--SteveF

TDThrottle 51 posts Joined 11/11
02 Dec 2015

Hi Steve,
Does Teradata TPT support connectivity to Oracle Database using JDBC in any of the recent releases. If no, ODBC is the only solution available to connect other Relational database from TPT and pull data.
Thanks
TDThrottle
 

feinholz 1234 posts Joined 05/08
02 Dec 2015

TPT does not have any integration with JDBC. ODBC is the only solution for connecting to non-Teradata databases.

--SteveF

TDThrottle 51 posts Joined 11/11
02 Dec 2015

Thanks for the clarification Steve

TDThrottle 51 posts Joined 11/11
02 Dec 2015

We tried using default ODBC driver from TD 15.10 to connect Oracle referencing below library files. Test case failed with following error.
I believe 15.10 ODBC driver is trying to refer DataDirect Library files which is an proprietary software. Can you please clarify, if DataDirect drivers is integrated with 15.10 with no additional licensing or we need to purchase separate license.
$ ./adhoc
Enter Data Source Name: oracledns
Enter UserID: rf_user
Enter Password:
Connecting with SQLConnect(DSN=oracledns,UID=rf_user,PWD=*)...
adhoc: (SQL Diagnostics) STATE=IM002, CODE=0, MSG=[DataDirect][ODBC lib] System information file not found. Please check the ODBCINI environment variable.
Library files referred
/opt/teradata/client/15.10/tbuild/odbc/lib64/_Tor827.so
 
Thanks
TDThrottle

VishnuVardhan 8 posts Joined 08/10
03 Dec 2015

Hi,
Did you happen to set the ODBCINI variable to the odbc.ini file you have the DSN settings in?
Try this:
export ODBCINI=<your odbc.ini file full path>
export LD_LIBRARY_PATH=/opt/teradata/client/15.10/tbuild/odbc/lib64:$LD_LIBRARY_PATH

-- Vishnu Vardhan --
 

TDThrottle 51 posts Joined 11/11
03 Dec 2015

Thanks Vishnu.
Forgot to mention earlier, we tested the ODBC connectivity after setting both env variables

export ODBCINI=/home/xxxxxx/odbc.ini

export LD_LIBRARY_PATH=/opt/teradata/client/15.10/tbuild/odbc/lib64:$LD_LIBRARY_PATH

 

Any inputs over:

 

I believe 15.10 ODBC driver is trying to refer DataDirect Library files which is an proprietary software. Can you please clarify, if DataDirect drivers is integrated with 15.10 with no additional licensing or we need to purchase separate license.

 

Thanks

TDThrottle

 
 

VishnuVardhan 8 posts Joined 08/10
03 Dec 2015

Yes, we do brand the DataDirect Drivers with TPT now and this requires a license to be requested from Teradata by your site team.
But the message you posted above does not have to do anything with the Branded drivers. This was due to not setting the ODBCINI env variable.
Did you happen to do this and pass this point and have some other error regarding the License?

-- Vishnu Vardhan --
 

feinholz 1234 posts Joined 05/08
03 Dec 2015

Could it be that the ODBCINI environment variable is pointing to a valid odbc.ini file, but the contents of the odbc.ini file are actually pointing to non-branded drivers?
 

--SteveF

VishnuVardhan 8 posts Joined 08/10
03 Dec 2015

Doesn't look to be the case as the below mentioned driver is the one we bundle with TPT and is used to connect to Oracle.
Library files referred
/opt/teradata/client/15.10/tbuild/odbc/lib64/_Tor827.so
Since he says he is setting the ENV variables as suggested, the only option is to see the content of the odbc.ini file now.
TDThrottle, are you using the odbc.ini file present in the /opt/teradata/client/15.10/tbuild/odbc/ folder?

-- Vishnu Vardhan --
 

feinholz 1234 posts Joined 05/08
04 Dec 2015

My post said:
 
Could it be that the ODBCINI environment variable is pointing to a valid odbc.ini file, but the contents of the odbc.ini file are actually pointing to non-branded drivers?
 
Which is saying the same thing. Since his error message says this:
 
MSG=[DataDirect][ODBC lib] System information file not found. Please check the ODBCINI environment variable.
 
It seemed to me that he was not indeed accessing the bundled drivers.
His job is accessing some other DataDirect drivers.
Thus, most likely an issue with the odbc.ini file.
 
 

--SteveF

TDThrottle 51 posts Joined 11/11
08 Dec 2015

Thanks Steve and Vishnu.
As you both pointed I was using wrong non-branded drivers. ODBC connectivity to Oracle works after repointing ODBC.ini dirver to 64bin "_Tora27.so"
Was referring to:

[Oracle]

Driver=/opt/teradata/client/15.10/tbuild/odbc/lib64/_Tor827.so

Description=Teradata 7.1 Oracle

 

Changed to:

[Oracle Wire Protocol]

Driver=/opt/teradata/client/15.10/tbuild/odbc/lib64/_Tora27.so

Description=Teradata 7.1 Oracle Wire Protocol

 

Thanks!

TDThrottle

feinholz 1234 posts Joined 05/08
09 Dec 2015

TDThrottle,
 
You posted a question on the DevX article thread:
"Use Teradata Parallel Transporter to Move Data Without Landing the Data to Disk"
 
I am assuming you do not need answers to your questions there, as they have been addressed here.
 
Thanks!

--SteveF

TDThrottle 51 posts Joined 11/11
09 Dec 2015

Thanks for the followup Steve.
 

You must sign in to leave a comment.