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 #

Thanks for this post Angelo - they were just the pointers I needed.

@Shannara: you select type "Other" and use com.ibm.as400.access.AS400JDBCDriver as the driver class. After you've created it you also need to set Properties to user=yourusername before you try to Activate (as the wizard seems to lose the username - that was from an OTN forum)

Posted by Simon Haslam on August 28, 2014 at 10:23 PM BST #

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
« August 2015
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