Using SOA Suite 11g and want to connect to an AS/400?

im currently working with client in the automotive industry and one of the things they want to do is extract/poll for data from a IBM AS/400.. Now it sounds difficult but thankfully its quite easy, Oracles Database Adaptor certaintly supports AS/400 and the Db/2 database.

The only thing you need to provide is a JDBC driver for the AS/400 DB2 luckly IBM provide an opensource driver (jt400) which can be downloaded from http://sourceforge.net/projects/jt400.

Here are some doc links:

http://download.oracle.com/docs/cd/E15523_01/integration.1111/e10231/adptr_db.htm#CHDEDJDB

http://download.oracle.com/docs/cd/E15523_01/integration.1111/e10231/adptr_db.htm#CHDDDJAG

Comments:

For some reason, the current download of SOA Suit 11g removed ability for third party drivers.

Even this one, as we are in the same boat as you. Placed driver in proper location, added to class path. Shows in path on start up. However, the driver is not available in the drop down in the JDBC section of the admin website.

Posted by Shannara on December 13, 2012 at 05:45 PM GMT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Architect & Technology Evangelist - If its middleware,PaaS/SaaS integration then I'm interested

The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

Search

Archives
« July 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
  
       
Today