Can BizTalk monitor an Oracle table for new transactions?

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Can BizTalk monitor an Oracle table for new transactions?

Viewing 2 reply threads
  • Author
    Posts
    • #18941

      Hi All:

      New to the forum and to BizTalk. I am having a hard time finding information for my questions:

      Scenario:

      I have an Oracle db on a server 1 where user enters new transactions from a front end. This is my source db. I need Biztalk to somwhow monitor this transactions and take that updated/inserted record and update another Oracle db on another server 2. Basically the Oracle server 2 is a combination of all of the other db tables and needs real-time updating from these other databases.NOTE: I also need to do this for an AS400 and a FoxPro db into the Oracle db server 2Thanks!

    • #18980

       Hi,

      You can use ODBC to connect Oracle database for more
      information visit following links. And By the way you must engineer a form of read
      flag on your records to ensure that rows are not read again when the adapter
      polls for data again.

      http://msdn2.microsoft.com/en-us/library/aa561124.aspx

      http://msdn2.microsoft.com/en-us/library/aa559822.aspx

      • #19062

        Thanks for the reply:

        I think I may run into some issues as that I cannot create objects (including view,tables,SP, and triggers) in the source databases. I can only read from these sources and somehow poll the table for new transactions. Still searching and researching. What about TopXML adapters? Can these adapters do what I need?

        thanks!

        –scotta

        • #19193

          Scotta,

          I don’t have any experience with the TopXml adapters so can’t comment (but they steal my blog content and don’t provide adequate reference to me, so I’m not their no.1 fan…) You may be interested in this Technet article: Receiving Polling-based Data-changed Messages from Oracle by Using BizTalk Server

          However I think that you will need to have at least update access to the table to enable you to run a post poll statement, flagging the record as ‘read’. Alternatively, is it possible to have a second Oracle table containing updates ‘not yet read’, which you do have the necessary update/delete permissions on? This table could just store those records yet to be read by BizTalk rather than the entire source table dataset.

          With regards to AS400 and FoxPro, I don’t believe there are specific adapters for these products. However MS do have the Microsoft BizTalk Adapters for Host Systems which allow you to read AS400 flat-files, or alternatively place the changes onto an MQSeries queue which can be read by BizTalk. 

    • #19195

      Scott,

      Just came across this blog post – may be worth reading: The Adapter Diaries – Oracle Adapter

      Nick.

Viewing 2 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.