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

I've used Hit Software and found it to be the easiest to use as well as
having very good performance to Oracle, SQL Server, etc.  You can
customize extensively if you want with scripting.

http://www.hitsw.com/products_services/dbmoto/dbmoto.html



David deLisi
Microsoft Corporation
 
  
 

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Don
Sent: Wednesday, October 19, 2005 4:24 PM
To: Midrange Systems Technical Discussion
Subject: Re: Is there a way to load iSeries data directly into Oracle on
another machine?


Dave,

Linoma has a product that will do this very nicely.

www.linoma.com

http://www.linomasoftware.com/products/transferanywhere/index.html is
the 
direct site url u'r
looking for...

Don in DC

--------------------------------------------------------------------

At 01:21 PM 10/19/2005 -0700, Dave Odom wrote:
>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.
>