On a daily basis we have to extract large amounts of data (on the order of 500MB) out of our iSeries box and export it out to an external co-located web server running mySQL. Right now we are using Data Transformation Services in MSSQL to export the data from the iSeries into a CSV file which is then FTP'ed up to the server and imported into mySQL ... while it works well, I would rather not have MSSQL installed as a go between. We have tried using the Data Transfer utility in IBM iSeries Access but found the utility buggy and it would frequently fail when run through automation scripts and lock-out the iSeries username that ran it. Does anyone have any ideas on a good way to do this? Any ideas are much appreciated.
Matt Laski
Web & Systems Support
Pulsafeeder Inc.
Matt Laski
Web & Systems Support
Pulsafeeder Inc.