3 Replies Latest reply: Oct 24, 2013 8:12 AM by PuneetRekhade RSS

    Is Polling good option in SOA?

    User129

      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


      Regards


      Tipu

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

          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.

           

           

          Thanks!

          Fox

          • 2. Re: Is Polling good option in SOA?
            User129

            Thanks Fox for sharing your experience

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

              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 !