I do not know what you exactly want to do with the data and why J2EE plays any part in it at all. If you are moving data from one place to another the best solution is to use some replication technology that helps :
* data to be transformed
* partition data
* persist data into central dB
* publish the same data to other related database.
MS SQL Server 2000, PointBase, Oracle and many other databases have very nicely implemented replication that you could use off the shelf. The can also be scheduled as jobs (MS SQL server 2000) or set up for continuous replication.
I hope this help. Or you could give more details so we can discuss it.
Thank you for your help, the answer is obvious when you point it out. Oracle seems to be a good choice but is there any shareware about that could do this? I would prefer a low cost solution if it is possible.
If you are working with a number of distributed data sources it may be prudent to look at asynchronous messaging systems. This would be especially true if you use the internet as your transport medium.
JMS is the open standard for java messaging and JbossMQ is based on JMS. There are also a wide range of commercial middleware packages available with an equally wide range of price tags.
i'll be your design partner if you give me a hug. :p