Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Can BizTalk monitor an Oracle table for new transactions?
- This topic has 4 replies, 1 voice, and was last updated 9 years, 10 months ago by
community-content.
-
AuthorPosts
-
-
February 14, 2008 at 8:07 AM #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!
-
February 23, 2008 at 2:01 AM #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.-
March 13, 2008 at 8:08 AM #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
-
March 31, 2008 at 2:16 AM #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.
-
-
-
March 31, 2008 at 2:37 AM #19195
Scott,
Just came across this blog post – may be worth reading: The Adapter Diaries – Oracle Adapter
Nick.
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.