mail me! sindicaci;ón

Oracle Data Integrator and Teradata JDBC Driver

June 17, 2011 at 11:25 pm · Filed under Database, Oracle

I’ve been getting to grips with ODI 11g over the past few days, specifically using it for moving data from an Oracle DB to a Teradata data-warehouse.

Despite Oracle’s (/Sun’s) excellent documentation, I struggled trying to find where/how I should install the Teradata JDBC driver JARs, and was receiving the following error when trying to setup the agent/data-server where the agent couldn’t locate the driver:

Could not load JDBC driver class [com.teradata.jdbc.TeraDriver]

The two JARs, terajdbc4.jar and tdgssconfig.jar, should be placed in the following location:

C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\agent\drivers

Your agent (local in my case) should now be able to successfully connect.

You’ll need to restart the agent using agentstop.bat in the bin directory for the classes to be loaded, you should see confirmation when starting the agent that they have been

You’ll probably then move on to reverse-engineering a model for the DB, and will again run into a similar error regarding ODI being unable to load the necessary TeraDriver class. The same two JARs also need to be placed in:

C:\Documents and Settings\\Application Data\odi\oracledi\userlib

Restart ODI Studio for the classes to be loaded

Et voila, you should now be able to move on to reverse engineering the Teradata database. :)

I’ve got ODI installed on an XP development VM, so your absolute paths will no doubt be different – hopefully the relative paths are identical!

Venkat said,

July 22, 2011 @ 7:57 am

Hi,

I have been facing a timeout error on some of my jobs while running a batch process. (ODI 10.1.3.5.6).
The Error in the operator says :
7000:null:com.sunopsis.sql.l: Oracle Data Integrator Timeout: connection with URL jdbc:teradata://ocs and user FRE1.
com.sunopsis.sql.l: Oracle Data Integrator Timeout: connection with URL jdbc:teradata://ocs and user FRE1.
at com.sunopsis.sql.SnpsConnection.a(SnpsConnection.java)
at com.sunopsis.sql.SnpsConnection.u(SnpsConnection.java)

When looked into the Agent log for this execution based on the Session ID . I could see the below information :
11/21/2010 12:41:34 PM(DwgCmdExecutionThread:AGT_AIX_CTX_P1_C2:18327): DwgCmdNetworkCall : Exception during command preparation
11/21/2010 12:41:42 PM(DwgCmdExecutionThread:AGT_AIX_CTX_P1_C2:18328): DwgCmdNetworkCall : Exception during command preparation
11/21/2010 12:42:27 PM(DwgCmdExecutionThread:AGT_AIX_CTX_P1_C2:18303): Session : 238765444 finished with return code : 7000

We have tried all the posible cases of increasing the Timeout on ODI (User Parameters and userpref.xml) and timeout on Teradata also.
All the Network and DB side seems to be fine during that time.

Any pointers to suggest.

Thanks ,
Venkat.

RSS feed for comments on this post · TrackBack URI

Leave a Comment