AS/400 to SQL integration (Real-time)

Has anyone been able to update a SQL table when running a batch job on the AS/400? I have created the link to the SQL server and can update it when running a OneWorld table conversion program locally, but when I submit it, it does not work.

Also, what alternatives do I have to try and create a seamless interface between the AS/400 and SQL server. (SQL2008). I can do this in SSIS, but it seems like I would have to kick off the job every 5 seconds to make it almost real time. The interface will update tables both ways.

Thanks,

Hi,

Mount a Windows Enterprise Server and run the job there,
you'll be able to read/write both SQL and AS400 tables
from there.

If you are using SSIS, you can schedule a job using the SQL Agent to kick off the job on a regular basis. I have done that with an interface before, though not as frequently as what you need.

IBM claims to have an answer - http://www-912.ibm.com/s_dir/slkbase.NSF/0/5a3856efecb7f19f8625672b006cee76?OpenDocument