TPT ODBC

Database
Enthusiast

TPT ODBC

Hi All -

I am facing issue when i try to run the TPT script which extracts the data from oracle and load in to teradata.Please find below is the error i am getting.

ODBC_Operator: TPT17122: Error: unable to connect to data source

ODBC_Operator: TPT17101: Fatal error received from ODBC driver:

STATE=IM002D, CODE=0,

MSG='[DataDirect][ODBC lib] System information file not found. Please check the ODBCINI environment variable.'

ODBC_Operator: disconnecting sessions

ODBC_Operator: TPT17124: Error: unable to disconnect from data source

ODBC_Operator: TPT17101: Fatal error received from ODBC driver:

STATE=53, CODE=0,

MSG='523 52'

Below is my script:

DEFINE JOB ODBC_LOAD

DESCRIPTION 'ODBC LOAD SUPL DEFINITION TABLE'

(

DEFINE SCHEMA Sanity_Test_ODBC_Schema

(

CTRY_CDE   VARCHAR(2),

CTRY_NAME  VARCHAR(100)

);

DEFINE OPERATOR DDL_Operator

TYPE DDL

ATTRIBUTES

(

VARCHAR PrivateLogName = 'ddl_log',

VARCHAR TdpId = 'TGT_SERVER',

VARCHAR UserName = 'USER',

VARCHAR UserPassword = 'PWD',

VARCHAR ARRAY ErrorList = ['3807','3803']

);

DEFINE OPERATOR ODBC_Operator

DESCRIPTION 'Teradata Parallel Transporter ODBC Operator'

TYPE ODBC

SCHEMA Sanity_Test_ODBC_Schema

ATTRIBUTES

(

VARCHAR PrivateLogName = 'odbc_log',

VARCHAR DSNName = 'SRC_IP',

VARCHAR UserName = 'SRC_USER',

VARCHAR UserPassword = 'PWD',

VARCHAR SelectStmt = 'Select CTRY_CDE,CTRY_NAME from KYC.CTRY where rownum < 6;'

);

DEFINE OPERATOR Load_Operator

TYPE LOAD

SCHEMA *

ATTRIBUTES

(

VARCHAR PrivateLogName = 'load_log',

VARCHAR TdpId = 'TGT_SERVER',

VARCHAR UserName = 'USER',

VARCHAR UserPassword = 'RMP2prod$',

VARCHAR TargetTable = 'DB.ORATEST',

VARCHAR LogTable = 'DB.ORATEST_log',

VARCHAR ErrorTable1 = 'DB.ORATEST_er1',

VARCHAR ErrorTable2 = 'DB.ORATEST_er2'

);

Step Setup_Into_Tables

(

APPLY

('drop table DB.ORATEST_er1;' ),

('drop table DB.ORATEST_er2;' ),

('drop table DB.ORATEST ;' ),

('create multiset table DB.ORATEST (

CTRY_CDE   VARCHAR(2),

CTRY_NAME  VARCHAR(100)

)

PRIMARY INDEX ( CTRY_CDE );'

)

TO OPERATOR (DDL_Operator);

);

Step Insert_Into_Tables

(

APPLY

'INSERT INTO DB.ORATEST

(

:CTRY_CDE,

:CTRY_NAME

);'

TO OPERATOR (Load_Operator)

Select *

FROM OPERATOR (ODBC_Operator);

);

);

I am able to connect to oracle from the same  unix server using sqlplus.

Can any one please help to run my script successfully.

Thanks

John

3 REPLIES
Junior Supporter

Re: TPT ODBC

Hi.

Connecting to Oracle through sqlplus (oracle client) doesn't mean anything. Sqlplus doesn't use ODBC. 

It seems your ODBC install is wrong somehow ("Fatal error received from ODBC driver" and "System information file not found. Please check the ODBCINI environment variable."). You should check the ODBC connection to Oracle with some tool/app and fix it.

HTH.

Cheers.

Carlos.

Enthusiast

Re: TPT ODBC

Hi Carlos-

We od not have any tool...May i know if there is a way that i can go an check manually in any of the path on UNIX server and if it not present can i create by my self or do i need to engage Admins for ODBC file set up ?

Thank you so much!!!

Junior Supporter

Re: TPT ODBC

Hi.

If you have the TTUs installed you should have "tdxodbc" which is a small app to test ODBC connections.

HTH.

Cheers.

Carlos.