RE: How can I read Oracle 9i table on Win2003 server from AS/400?

Dave,

There are three options:

1) Using JBDC in a Java app on the iSeries to read/write directly to Oracle.  
iSeries Network had a recent article about doing this with SQL server, it was 
no big deal to modify it to goto Oracle also/instead.  RPG apps wrote requests 
to a DTAQ, a never ending Java program would pick up the request, send it to 
the external DB and load the result back to another DTAQ.

2) Oracle's Access Manager for AS-400.  This is an OS/400 software application 
that translates OS/400 DRDA requests into Oracle's network protocol.  You use 
SQL on the 400 as if it was any other remote DRDA (aka DB2 UDB) database.

3) Third party middleware.  Such as RJS's product or IBM's.  These products sit 
on a PC (usually) and translate request from the 400 into ODBC, OLEDB, or even 
proprietary protocol requests to Oracle.


Note that #2 is packaged with the Oracle Transparent Gateway for DB2/400 and 
Oracle Transparent Gateway for DRDA products which allow the Oracle database to 
access DB2/400 as if it was another Oracle DB.  But the base(?) list cost is 
$35K.  The TG for DB2/400 is actually an AS/400 application as is the Access 
Manager for AS-400 product.  The TG for DRDA sits on a PC and will access any 
DRDA DB.

HTH,


Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Dave Murvin
> Sent: Sunday, February 13, 2005 10:10 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: How can I read Oracle 9i table on Win2003 server from AS/400?
> 
> 
> I would like to be able to read an Oracle 9i table that is on 
> a Windows 
> 2003 server from an AS/400 application.  We currently 
> exchange files though 
> the IFS, but this is a nightly batch job.  I would like to 
> read the table 
> on demand, hopefully without having to buy any more software.  I have 
> looked at the archives and the info center for ODBC, but didn't see 
> anything that seemed to fit.  Most of the articles I saw were about 
> connecting a PC to the AS/400 via ODBC, and the code examples 
> were for 
> Visual Basic or in C.  I would be coding the program in 
> ILERPG or CL.   I 
> know there is a Oracle Access Manager out there, but it seems 
> unlikely that 
> this is a free product.
> 
> Any suggestions or ideas?  Additional places to search?  
> Manuals to read (I 
> have looked and not seen anything so far)?
> 
> Thanks
> 
> Dave Murvin
> DRM Enterprises, Inc.
> 
> 
> -- 
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
>