• Post Reply Bookmark Topic Watch Topic
  • New Topic

Data synchronization bet practice?  RSS feed

bilal haider
Ranch Hand
Posts: 47
Java Windows XP
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Data synchronization on multiple locations:

Application is deployed on different locations, I want to update master database at the end of day such that new sales orders of the day from all locations
should be inserted into master database.

At the time of insertion of a new sales order in the local database at a particular location,
application first ensure that this customer is new customer who is not in the local as well as master database.
If customer data is already present in the master database , then local database must be populated with essential details of a customer available in the master



CUST_ID sequence (PK)
Name varchar2
DOB DateTime
SSN DateTime


CUST_ID (FK) Refrences Customer,



At the end of day I want to update the master database, with all the details of new data that is inserted in the databases on different locations.

The approach which i want to follow is:

//select name, dob,ssn from customer where ssn=:ssn
set recordExistInMasterDatabase=true;

if (recordExistInMasterDatabase)
insert into location.Cutomer(name,dob,ssn) values(master.name,master,dob,master.ssn)
insert into location.Cutomer(name,dob,ssn) values('John','19-MAR-2012','1111-222222-8989888'}

Now at the end of day i want to update the master database with the new customers that are registered on different locations.

Please suggest me the articles, techniques, tutorial so that i can achive the above functionality. I want to start my work after deciding a particular technique.
Is there any tool to do this?
What about oracle data integrator?
Should I implement web service to communicate with the master database?

I want to implement this using pure java + oracle sql + jsf for web.
I have eclipse, oracle 11g.

Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!