Hi All,
I have a requirement to pull (not only new records every time) all the records from a database(static or whether it is updated with new records) and update that data into target application for every specified intervals.I have to get the all the records for every request.
Can I use the Inbound database adapter which should poll all the records(I don't know whether it is possible or not) and schedule to execute BPEL process which pulls the data from adapter for every x mins.
How do I achieve this? In order to have inbound adapter we can poll the new records(That I know) but not all the records.
How Can I have composite(which includes BPEL process) which pulls the data from a database and do the same for every x mins?
I want to have flow like this in SOA composite editor.
Database adapter (exposed services section) -------- BPEL process(components section) ------------ target application service(to which the data from db adapter should be transferred - reference section)
(or)
Is there any other way to achieve this requirement?