RE: Is there a way to load iSeries data directly into Oracle onanother machine?

Dave,

I'm in the same boat as you.

Oracle is being used for some new development instead of DB2 on the
iSeries.

Oracle has something built in called "Heterogeneous Services" that
allows Oracle to talk to other vendor's RDBMS.  You have two choices,
via Transparent Gateway product package which allows for two way
communication between Oracle and DB2 iSeries.  The Transparent Gateway
product package will set up back $35,000 however.

The other option is "Generic Connectivity".  You don't have to buy
anything else, just load an iSeries ODBC or OLEDB driver to your Oracle
machine and Oracle will be able to read/write tables on the iSeries.
Biggest limitations of generic connectivity are: no stored procedures
(or UDFs?) and  no two-phase commit.

This link should help:
http://www.oracle.com/technology/products/gateways/index.html


We use the Generic Connectivity through the iSeries OLEDB driver here.
Works quite well.

In fact, like you we originally were going to be copying data from the
iSeries to Oracle.  However, now for the most part the data is left on
the iSeries and Oracle just accesses it as needed.


It's too bad the Oracle (and MS SQL Server for that matter) aren't as
open as DB2.

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 Odom
Sent: Wednesday, October 19, 2005 4:21 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Is there a way to load iSeries data directly into Oracle
onanother machine?

I know I keep coming up with weird stuff but I'm in a weird environment;
well maybe not so weird.

In any event, there's this application being built in a Windoz
environment running Oracle. (Yes, I tried to convince them to talk to
DB2/400 vs Oracle since they need data from my iSeries anyway, but there
is a bigotry toward Oracle for any new application development).   This
application needs some of the data from my iSeries on a nightly basis.  
What I'd love to do is kick off a scheduled job on the iSeries that
extracts data from the iSeries using a program(s) that I write that call
SQL stored procedures and then load directly into some Oracle tables in
the Windoz environment.    This is kinda like... is there an iSeries to
Oracle DRDA or some such.

Anyone ever done something like that?  If so, how?   

Thanks to all of you for all your help,

Dave Odom
Arizona