Ranjith, The big ETL tool vendors (and Data Integration Brokers) do provide this capability you seek - but they are rather costly. Examples are Informatica and Embarcadero.
We had a similar situation with our client, and we opted to build a data transfer/integration tool based on Java/XML/XSLT.. it is pretty flexible and works quite well. I can send you more info on it if you wish. -Steve On Wed, 5 Feb 2003 11:01:52 +0600, Ranjith Kodikara wrote > 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]
