cancel
Showing results for 
Search instead for 
Did you mean: 

Create JDBC connection to Teradata in IDT

Former Member
0 Kudos

I'm trying to create a relational connection from IDT to Teradata through JDBC, but I have this error when I test the connection:
See attached


System: SAP BI 4.0 SP02 Patch 21.
I've downloaded the drivers terajdbc4.jar and tdgssconfig.jar, both were located in path "<SAP BI 4.0 Installation folder>\dataAccess\connectionServer\drivers\java"

I've edited "teradata.sbo" file in "<SAP BI 4.0 Installation folder>\dataAccess\connectionServer\jdbc" and I added the claspath for the jar files:
   <ClassPath>
                <Path>$ROOT$/drivers/java/dbd_jdbcwrapper.jar</Path>
              <Path>$ROOT$/drivers/java/terajdbc4.jar</Path>
              <Path>$ROOT$/drivers/java/tdgssconfig.jar</Path>
   </ClassPath>

I configured the Teradata ODBC Driver and in this way I got to build the connection successfully, but I need to do it with JDBC as well.

Any idea about what is happening?

Regards.

S. Gordon.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Sergio,

I hope the below link will help you in checking if anything is missing:

https://scn.sap.com/thread/2049046

Regards,

Yuvraj

Former Member
0 Kudos

Hi,

Curently I have Solman 7.1, ERP 6 and SCM 2007. Customer dont want to use BW and already Teradata is available with data.

Can teradata be used without SAP BW in picture. If yes, how do i connect SAP to Teradata?

Please help asap.

Regards