Analytics Software

I'm trying to use the jt400.jar driver from IBM (com.ibm.as400.access.AS400JDBCDriver) to connect ODI 11g with an AS/400 machine. I successfully installed the jar for our standalone agent (on AIX), but I can't get my ODI Studio (on Windows XP) to recognize the driver.

Steps to reproduce in ODI Studio:
1) Open the physical data store definition in ODI Studio (Physical Arch. > Tech. > IBM DB2/400 > [servername])
2) Click "Test Connection"
3a) [works] "Select a Physical Agent to test this Connection" > OracleDIAgent_sa001 (our standalone agent on AIX)
--> Successful Connection
3b) [broken] "Select a Physical Agent to test this Connection" > Local (No Agent)
--> Connection Failed -- oracle.odi.core.exception.OdiRuntimeException: java.lang.IllegalArgumentException: Could not load JDBC driver class [com.ibm.as400.access.AS400JDBCDriver]

I can generate this exception using a few different features in ODI Studio, but this is the simplest to reproduce.

In troubleshooting I have copied the jt400*.jar files into a variety of directories on my machine in an attempt to get this working, and have modified my CLASSPATH to point to one external directory that also contains the jt400*.jar files, but nothing seems to work. (I have also restarted my machine a few times in true Windows fashion)

- oracledi/agent/drivers/jt400.jar
- oracledi/client/ide/lib/jt400.jar
- oracledi/client/jdev/lib/jt400.jar
- oracledi/client/modules/jt400.jar
- oracledi/client/odi/bin/jt400.jar

Is it possible to use the jt400* driver this way or am I misunderstanding its role in this world?

Thanks,
Mike