Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Send msg from Oracle to MSMQ via BizTalk in real-time

0 views
Skip to first unread message

RedHair

unread,
Aug 26, 2005, 12:22:12 PM8/26/05
to
Dear all,

I want to send msg to a MSMQ queue(Win2000) from HPUX+Oracle in real-time
while any data update occurs in Oracle db,
how to use BizTalk 2004 to implement this? thanks in advance!


steve

unread,
Aug 26, 2005, 1:39:26 PM8/26/05
to
That's a pretty common scenario with biztalk. You would need to setup
an adapter to poll the oracle database for updates. Microsoft just
announced the availability of an Oracle adapter. Once biztalk receives
the data from Oracle you can transform it, or just pass it through, and
spit it out to a queue using the MSMQ adapter.

RedHair

unread,
Aug 26, 2005, 10:26:19 PM8/26/05
to
Is there any configuration or programming works need to be done in HPUX +
Oracle side? or I only
implement everything on Windows side?
Btw, the Oracle adapter is free or not? Thanks.

"steve" <stev...@hotmail.com>
???????:1125077966.8...@g47g2000cwa.googlegroups.com...

steve

unread,
Aug 27, 2005, 4:10:48 AM8/27/05
to
you probably won't need to do anything on the Oracle server other then
setup a user account for biztalk to login with.

i spoke too soon about the oracle adater, it won't be released until
next year. your current options are to buy one from a thrid party
(iWay for example) or search for a free one a fellow developer has
written and is sharing.

Chris Holliday

unread,
Aug 27, 2005, 12:37:09 PM8/27/05
to
Another option would be to simply use the Enterprise Library or any data
access code .net objects to access Oracle directly. A pattern I use
repeatedly against our Oracle dbs is:

- Source system event tables write events to custom log tables (capture
message primary key values, time stamp, event flag, etc) using Oracle
Triggers
- Biztalk polls the table using a timer receive port [1] for any new
messages marking the retrieved messages as "retrieved"
- These messages are sent through a "messageBuilder" orchestration where the
key values are used to generate a message and output directly to the Biztalk
Messagebox
- A "<yourMessageType>Processor" orchestration then handles additional
filtering, application specific message building and routing

If you don't need to do much filtering or message building, you could use a
send port immediately after the timer receive port above. Simply send the
message to a MSMQ.

Hope that helps.

[1]
http://www.gotdotnet.com/Workspaces/Workspace.aspx?id=fd739ed2-f6f0-4ae6-a3d1-865c61f0bc7d

"steve" <stev...@hotmail.com> wrote in message
news:1125130248.6...@f14g2000cwb.googlegroups.com...

Jason Agostoni

unread,
Aug 27, 2005, 2:31:32 PM8/27/05
to
Just to deviate from the adapter idea you could, in theory, write a
Java procedure within Oracle to call a WebPort in BizTalk. In fact,
you could skip BizTalk altogether and just write a web serivce (in
ASP.Net, of course) that would post to an MSMQ and call that from
Oracle. BizTalk would certainly help abstract the solution but would
be costly if all you want to do is post to an MSMQ queue. If you
already own BizTalk then I would certiainly leverage that.

This way you would not have to poll the database and you would get
real-time results.

Jason Agostoni
Associate .Net Architect
CEI (www.ceiamerica.com)
http://jason.agostoni.net

RedHair

unread,
Aug 28, 2005, 5:18:00 AM8/28/05
to
Thank you!
Since this solution uses a timer, is it a real-time solution?
And I need the Oracle knowledge to create trigger or store procedure for the
temp log table?

But I think this solution is able to queue the data in the log table in case
the MSMQ server
is down or the network is broken. am I right?


"Chris Holliday" <crhol...@noSpamPlease-adventureology.com> 撰寫於郵件新聞:OCLzpUyq...@TK2MSFTNGP09.phx.gbl...

RedHair

unread,
Aug 28, 2005, 5:21:53 AM8/28/05
to
Since I'm not familiar with Oracle and HPUX side, where can I
find a sample about how to call web service from Oracle side.
Thanks in advance.


"Jason Agostoni" <jago...@gmail.com>
???????:1125167491.9...@g14g2000cwa.googlegroups.com...

Jason Agostoni

unread,
Aug 28, 2005, 10:25:14 AM8/28/05
to
Consuming a webservice via a Java stored proc (or maybe even plain
PL/SQL) does not look to bad. Here is a direct link to an article on
the subject:

http://technology.amis.nl/blog/index.php?p=348

Also, I just did a quick Google search and came up with the following:

http://www.google.com/search?q=oracle+consume+webservice

I would check on one of the Oracle newsgroups for better assitance on
that.

Chris Holliday

unread,
Aug 28, 2005, 11:44:16 AM8/28/05
to
You can loop the timer as fast or as slow as you like. It uses the .NET
Timer objects for establishing intervals. Most of my interfaces are set at
around 60 second loops.

You will need to know how to create the triggers/procedures, but this is
very easy to come by using google.

You are correct that the log table will store your values until completely
processed by your solution (and beyond if you need to archive). You can have
the final step in your interface make a call back to the database flagging
the transaction as complete.

I think the solution mentioned below on the other branch of this thread is
also a good one. Another option along those same lines is to simply consume
an Oracle A/Q (Advanced Queue) from a .NET listener or google how to push an
Oracle A/Q to an MSMQ queue. I bet there is something out there that would
do this.


C.

"RedHair" <red...@ms40.url.com.tw> wrote in message
news:eh$WkF7qF...@TK2MSFTNGP15.phx.gbl...

Very nice site! Good work. http://www.sessit.port5.com

unread,
Feb 28, 2007, 4:15:59 PM2/28/07
to

Very nice site! Good work. http://www.sessit.port5.com

BizTalk Utilities - Frustration free BizTalk Adapters
http://www.topxml.com/biztalkutilities

Nice design, good graphical content. I think I'll come back later again;) http://phentermines.forum-on.de

unread,
Mar 9, 2007, 11:55:55 AM3/9/07
to

Nice design, good graphical content. I think I'll come back later again;) http://phentermines.forum-on.de

mmm.. nice design, I must say.. http://www.paradistc.org/italia

unread,
Mar 12, 2007, 4:15:14 AM3/12/07
to

mmm.. nice design, I must say.. http://www.paradistc.org/italia

Du musst ein Fachmann sein - wirklich guter Aufstellungsort, den du hast! http://www.paradistc.org/liberi

unread,
Mar 14, 2007, 7:21:48 PM3/14/07
to

Du musst ein Fachmann sein - wirklich guter Aufstellungsort, den du hast! http://www.paradistc.org/liberi

i'am really impressed!! http://www.sanzkdni59.org/libera

unread,
Mar 16, 2007, 6:10:32 PM3/16/07
to

i'am really impressed!! http://www.sanzkdni59.org/libera

luogo grande:) nessun osservazioni! http://www.paradistc.org/sardinia

unread,
Mar 18, 2007, 9:34:20 AM3/18/07
to

luogo grande:) nessun osservazioni! http://www.paradistc.org/sardinia

Chi ha fatto questo? E un buon posto per trovare le informazioni importanti!:) http://www.sanzkdni59.org/formula-1

unread,
Mar 20, 2007, 12:34:33 AM3/20/07
to

Chi ha fatto questo? E un buon posto per trovare le informazioni importanti!:) http://www.sanzkdni59.org/formula-1

Lavoro eccellente! ..ringraziamenti per le informazioni..realmente lo apprezzo: D http://www.sanzkdni59.org/del-piero

unread,
Mar 20, 2007, 5:38:03 PM3/20/07
to

Lavoro eccellente! ..ringraziamenti per le informazioni..realmente lo apprezzo: D http://www.sanzkdni59.org/del-piero

Interessieren. SEHR interessant! ;) http://www.circumno3.org/sesso

unread,
Mar 30, 2007, 11:01:39 PM3/30/07
to

Interessieren. SEHR interessant! ;) http://www.circumno3.org/sesso

Du musst ein Fachmann sein - wirklich guter Aufstellungsort, den du hast! http://www.circumno3.org/guerra

unread,
Mar 31, 2007, 3:07:09 AM3/31/07
to

Du musst ein Fachmann sein - wirklich guter Aufstellungsort, den du hast! http://www.circumno3.org/guerra

L'information interessante que vous avez! I'am allant revenir bientot. http://www.qukeartiere90.org/valentino-rossi

unread,
Mar 31, 2007, 7:15:01 AM3/31/07
to

L'information interessante que vous avez! I'am allant revenir bientot. http://www.qukeartiere90.org/valentino-rossi

Ich erklare meinen Freunden uber diese Seite. Interessieren! http://www.qukeartiere90.org/erotismo

unread,
Mar 31, 2007, 11:13:08 AM3/31/07
to

Ich erklare meinen Freunden uber diese Seite. Interessieren! http://www.qukeartiere90.org/erotismo

Grande sito!! http://www.qukeartiere90.org/guerra-vida-wallpaper

unread,
Mar 31, 2007, 3:09:35 PM3/31/07
to

Grande sito!! http://www.qukeartiere90.org/guerra-vida-wallpaper

0 new messages