Sync Data from AS400 with other DB

[PulsaMatt]

I am hoping someone might have run into an issue like this before and/or might have some suggestions.

Short story is we need to build a web-based App that will use read-only data from the AS400 for part of the information on screen and dynamic data from a mySQL database for the other half.

The problem lies in trying to query the data ... I dont know of any way to write an SQL query that will run on two different platforms.

We have resigned to the fact that we are going to need to copy the data out of the 400 into duplicate fields in the mySQL database ... but we want to find away to sync them, if only once a night ... so that the data we are copying into the mySQL database is kept inline with any changes that are made (I an effort to avoid a relational nightmare).

So thats where we stand now ... the project has kind of stalled as we try to figure out the right way to do this ... so that we only have to do this project once, instead of putting a bandaid on it and planning on hitting it again later ... since we all know the bandaids usually wind up becoming permanent.

Matt Laski
Sysadmin, Pulsafeeder Inc.

 

[joedavis]

Hi Matt, you can use a tranformation product as supplied by Datamirror. Please see link below:

http://www.datamirror.com/products/tserver/features.aspx

Hope this was of use.

J.

 

[kalok]

Hi Matt

Ypu might want to consider using triggers on the As400 database to synchronise changes only. Depending on the size of the database and/or the location of you MySQL Database Server, an off the shelf ETL tool will probably suffice.