Method for nightly import from AS400 to MySQL on Linux
Posted on 2006-04-26
I need to do a nightly import of a few tables from our AS400 to a MySQL database on our Linux server. The Linux box has no GUI and should run unattended. For various reasons, any setup or changes to the AS400 should be minimal or zero if possible.
The best-sounding suggestions I've found so far involve writing a small Java program and running it on the Linux machine with a cron job to connect to the AS400, pull the recordsets, and then connect to the MySQL database and drop in the results. I'm willing to do this, but have no experience with Java. So if there's a more simple approach, I'd love to hear it.
Not looking for a full-walkthrough to implementation; points will be awarded for pointing me in the right direction-- which may just be the aforementioned Java solution. Of course, a point in the direction of a walkthrough would earn my undying gratitude.