AS400 OneWorld read Oracle database

tech_smith

Member
Hi List,

We have been successful in creating an OneWorld datasource that points to
an Oracle
database from our AS400 based installation and to have table conversion
processes
swap data between OneWorld and the 3rd party Oracle based system. This is
OK on a
FAT client that has the relevant Oracle SQLNet client and ODBC driver
installed etc - but
if we wanted to run this TC job in batch on teh AS400 what would we need on
the AS400
to enable it to connect to this Oracle based OneWorld database data source
?

Thanks,

Andy Smith
 
There are two methods for doing this.

1. Use the Oracle Gateway. This is an Oracle based box that allows access to the AS/400 through Oracle - however, I am not sure how this would work the other way around

2. Use JDBNet. This would require an application server be configured that talks to the Oracle instance. Then the AS/400 can "see" the Oracle data by passing its RDB statements to the OneWorld application server to handle. This is the "official" method of having an AS/400 see Oracle data.

The application server only needs to be a beefed-up workstation in this instance - but should have a relatively fast network connection between the AS/400 and the Oracle Database Instance.
 
Back
Top