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)
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?
We do not certify with any open source ODBC driver.
The only ODBC driver with which we certify is DataDirect (now called Progress).
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.
TPT does not have any integration with JDBC. ODBC is the only solution for connecting to non-Teradata databases.
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.
Enter Data Source Name: oracledns
Enter UserID: rf_user
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
Did you happen to set the ODBCINI variable to the odbc.ini file you have the DSN settings in?
export ODBCINI=<your odbc.ini file full path>
Forgot to mention earlier, we tested the ODBC connectivity after setting both env variables