Re: A tough one: Replication Oracle/NT ---> DB2/AS400

If you can justify the cost for a system that you are replacing in a couple of years, Datamirror would do the job for you. You would have to buy a node on the 400 and the NT box. Replication would be real time.

Another direct cost option would be Oracle's Transparent gateway if you wanted to push data or the Access Manager is you wanted to pull data from Oracle to DB2/400. Both products would require manually manipulating snapshot logs.

A totally home grown option might be to write an external java process that would access both databases. You could used snapshot logs on the Oracle side, and use them to refresh the data in DB2/400 on an interval controlled by your Java process. Both databases have Type 4 JDBC available. (Any combination of 3gl/ODBC/OCI would work here)

I was in a situation where the DB2/400 wasn't going away, so we could justify the Datamirror solution

Hope that helps.

Alan Hopkins wrote in message <80ccn1$7e8$1_at_autumn.news.rcn.net>...
>
>The scenario is a new intranet data collection application (ORACLE on NT)
>that will obsolete a respective application over a couple of years (DB2 on
>AS400)
>
>I need to allow data to be persisted in an ORACLE database and replicate
>the data into DB2 on a 400. This replication (thank goodness) is one-way,
>
>What would you do?
>I need to be able to queue the updates as the AS400 periodically goes
>offline, yet the new application hat 'feeds' it is up 24x7. The replication
>should occur at least 'near real time' (every 1/2 hour at least) and real
>time if possible.
>
>I know well how to create a snapshot.... but how best to write to the Db2
>database on the AS400 from NT?
>
>Thanks for any help you can give me on this one.
>
>
>
Received on Thu Nov 11 1999 - 00:55:54 CET