Data Transfer with XML between two DB's- a Real world Case

[Ranjith Kodikara]

My customer has a requirement like this. There are several locations of that organization (my customer). They have an Oracle database in each of their locations. There is a central server. When daily transactions are processing, they update their location databases and at the end of the day, they have to transfer those data to the central server. Currently we are doing this with Oracle database links and due to so many reasons this is not 100% successful. Communication is through internet dialup connections (we can�t tell them to upgrade those lines) We are hoping to go for XML technologies in order to do this data transfer. I have knowledge on XML technologies, but not practical experience. But in this case there is no one in the central server to do any thing. People in locations should be able to transfer data of that particular day to the central server at the end of the day. There are 15 locations plus a central server. When location A finishes its works, it sends its data to the central location. (When it sends those data, it (A) updates a flag in the database records. It can identify unsent records by those flag.) Then the Oracle database in the central server should be updated with location A�s records.   At that time the database in the central server would have been updated with other locations data (for an example, location B�s data). Then at the same time those data should go to location A and location A�s database should be updated with those location B�s data that the central server already have. My question is how can I do this? What s the best technology to use? (Web Services etc.) Can you recommend a book or some of web resources?   There is no one in the central server to do this. I hope the location user to do this.   Still I am wondering which technology to use. I already experienced in JSP, Java and Servlets. I have done some works with Xerces, Xalan and WebServices.    If I am going to use Axis for this,       an I do this with Axis ?     Is it reliable Axis to do this? (Because this is a critical real world application)     I appreciate if some of you give me some guidance here.   I would greatly appreciate your response.   Thanks and best regards, Ranjith Kodikara [EMAIL PROTECTED]