My company has migrated from a inhouse software system to a webbased software for rental property management. The GL data they are creating from the transactions is in XML format. I need to get that XML data into GL entries which is still on the AS400. What is the best way to do that, with the least cost regarding software. My idea is to have standalone PC talking to this web program that will export data on a given time. A transfer would then happen, transferring the data from the PC to the AS400. An XML translator would then kick off translating the data into an AS400 Physical file. A call would then occur to create the GL.
Any better, more efficient ideas? Regarding the XML translator, any recommendations?