3 Replies Latest reply on Oct 24, 2013 1:12 PM by PuneetRekhade

    Is Polling good option in SOA?


      Hi Experts


      I have a question related to Polling etc in SOA


      Scenario: I have a BPEL Composite, that integrate EBS and Siebel CRM DBs using DB Adapter, I am using Polling so that whenever any changes happens in EBS, my composite get invoke to send data to CRM. I have many composites like these and using polling for them separately.

      Q1) Is this a good way?

      Q2) Is so much polling not bad for DB?

      Q3) What could be the best way to do this, so whenever a new record inserted my SOA composite should run?

      Please help me in this regard



        • 1. Re: Is Polling good option in SOA?

          Hello Tipu,


          From my previous experience, Polling DB isn't a bad idea. You can try optimizing the polling interval to suit the application's need.

          And apart from DB polling the other option available is to use events to to accomplish the same task. A procedure can be designed in the database to trigger an event in case any new records are being inserted, the same events can be captured in the fusion layer.


          The only issue encountered with DB polling was related to using an XA enabled datasource, this caused it to throw remote exceptions caused by connection breaks.


          Hope this helps.





          1 person found this helpful
          • 2. Re: Is Polling good option in SOA?

            Thanks Fox for sharing your experience

            • 3. Re: Is Polling good option in SOA?

              Actually, it depends upon the number of tables your EBS is dependent upon. For example, EBS tables have plenty of dependency and several primary-foreign relationships. Check this link - here they have given a reference about a PO being created and being integrated with BPEL.

              You can proabably use something of this sort.. only thing to take care is, you should know what type of entity are you looking for ? Party, Purchase Order, Accounts etc etc..

              Hope it helps !