Re: Is there a way to load iSeries data directly into Oracle on another machine?

Dave

<blantant vendor response>
Our RPG2SQL Integrator product will enable you in doing this. It uses a 
middleware server bit on a PC that is visible to both the iSeries and your 
Oracle server on the network. Read/write capability in real time, stored 
procedures in Oracle can be called, basically any SQL statement supported by 
the Oracle database using ODBC or OLE/DB. Check www.rjssoftware.com or call me 
at 952.898.3038 - you can download the manual at our site and see what it is 
like.
</blantant vendor response>

OTOH, Oracle itself has a DRDA something to do this - costs at least $25,000. 
Ours is much less expensive, albeit not DRDA. IBM also has their Websphere 
Information Integrator, which is also DRDA. Upwards of $30,000 I believe.
-------------- Original message -------------- 

> 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 
> -- 
> 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. 
>