Heterogenous Replication SQL 2k, OLEDB Db2/As400, HOW?

[Interwizard]

Hiya all. My business uses an AS/400 for all of it's data storage and for some terminal apps. I want to replicate data from the 400 to my SQL Server 2000 Database so that some of our PC and Web Apps can be exposed more tightly with the data for generating reports, viewing data, etc. I'd like the data on the SQL box to be as up to date as possible. It's a good chunk of data, ( over 2 gb) so, I really don't want to do a scheduled, batched snapshot of nightly data. I was hoping to use replication, because we also use replication to replicate to salesman and remote offices. The problem that I am running into is that I haven't seen any clear intructions or help material on setting up an SQL server to subscribe to a Heterogenous data source.. The subscription wizard only lists publications from registered SQL servers. I was curious if anyone could help me or point in the direction to setup this relationship between my SQL box and my Big Blue Box. I use MS OLE DB for DB2 provided by MS Host Data Integration Server 2000 for the connection to the /400..
Thanks in advance.

Bill Dodd
bill@interwizard.com

 

[sguslan]

I have the same need and have been replicating data off a DB2 running on a mainframe. You can use timestamps in the source tables to aid in replicating data as it gets updated/inserted... As for deletion, you can create triggers in the source AS400 to create a table that lists all the rows that are deleted in the source tables, then replicate that to the sql2000 server and apply it there.

Or if you have a lot of money look into IBM Data Propegator. It is supposed to automotae such processes ...