Re: Data replication from DB2 to Oracle

Vittorio Turchetti <vturchetti_at_infostrada.it> wrote:
>We have to load an Oracle 7.3 database with data coming from a DB2
>database.
>The Oracle database will be running in a Unix or NT box, while the DB2
>resides in a IBM mainframe.
>After the first load we want to refresh periodically our Oracle data
>from the DB2 source.
>We don't want to use Oracle Transparent Gateway and are looking for a
>cheaper solution.
>Have you any advice? What might be the best solution?

The best solution probably is Oracle's heterogenous replication product, which works in conjunction with IBM's Data Propagator for DB2. This might not meet your cost criteria, but you should at least take a look since it is a product designed specifically to do what you want and it integrates with Oracle's native replication services.

Your Oracle rep should be able to supply detailed information.

/b

--
Bill Manry - IBM Products Division - Oracle Corp. USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.
Remove the "." from "B.Manry" to email me.