Track changes in Oracle Database RRS feed

  • Question

  • I'm using BizTalk 2010 to integrate Dynamics CRM 2011 to a core banking application(Oracle Flexcube) which runs on Oracle 11g database. My problem is I want to track all the changes done in Oracle and upload them into CRM and this must be in real time. I'm stuck as I don't know how to go about it. Any help will be greatly appreciated.

    Good is not good enough when best is expected !!!

    Wednesday, May 29, 2013 3:01 PM


  • Couple ways to approach this.

    While the WCF OracleDb adapter supports change notifications, I've found this feature to be pretty fragile.

    Polling will work, but you may need to keep track of a few things on your own, like last update time, etc.  Real-time is a pretty heavy requirement.  Even a 10 min window will give you a lot more options.

    • Proposed as answer by Molly Chen_ Wednesday, June 5, 2013 3:26 AM
    • Marked as answer by Edgias Thursday, June 6, 2013 7:22 AM
    Thursday, May 30, 2013 2:54 PM