OBIEE connection error to Teradata

Connectivity

OBIEE connection error to Teradata

Hello!

I have a strange situation with connection OBIEE to Teradata.

I have installed OBIEE 11g on a linux red hat x64. TTU 14.00.

When I try to make select from Teradata through BI i receive error

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 16001] ODBC error state: IM003 code: 0 message: [DataDirect][ODBC lib] Specified driver could not be loaded. (HY000)

but all test connection through nqcmd, ssgodb or tdxodbc were completed successfully

/tdxodbc

Enter Data Source Name: test

Enter UserID: guest

Enter Password:

Connecting with SQLConnect(DSN=test,UID=guest,PWD=*)...

.....ODBC connection successful.

ODBC version        = -03.52.0000-

DBMS name           = -Teradata-

DBMS version        = -14.00.0501  14.00.05.01-

Driver name         = -tdata.so-

Driver version      = -14.00.00.03-

Driver ODBC version = -03.51-

(type quit to terminate adhoc)

Enter SQL string : quit

'quit' command detected

ODBC connection closed.

./nqcmd -d tera -u guest -p guest

-------------------------------------------------------------------------------

          Oracle BI ODBC Client

          Copyright (c) 1997-2013 Oracle Corporation, All rights reserved

-------------------------------------------------------------------------------

        [T]able info

        [C]olumn info

        [D]ata type info

        [F]oreign keys info

        [P]rimary key info

        [K]ey statistics info

        [S]pecial columns info

        [Q]uery statement

Select Option:

./ssgodbc.linux64 -d test -u guest -p guest -v

Connected

ODBC version        = -03.52.0000-

DBMS name           = -Teradata-

DBMS version        = -14.00.0501  14.00.05.01-

Driver name         = -tdata.so-

Driver version      = -14.00.00.03-

Driver ODBC version = -03.51-

Enter SQL string: quit;

ODBC connection closed.

2 REPLIES
Teradata Employee

Re: OBIEE connection error to Teradata

Was same odbc.ini file, DSN used between OBIEE and tdxodbc ?

Re: OBIEE connection error to Teradata

Hi Team,

I have upgraded RPD from OBIEE 11.1.1.6.0 to OBIEE 11.1.1.7.0. I have depolyed also.

My data source is teradara.

WHen I run the report, below error is getting:

"State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 16001] ODBC error state: IM002 code: 0 message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. (HY000)"

How to connect Teradata from OBIEE 11g.

Could you please look inti this. I am stucked here.

Thanks 

RJ