|How to retrieve Message Body from BizTalk Database||BASKAR BV||2/14/07 6:29 AM|
From which table to read the actual xml data sent to the messagebox
Appreciate your help!
|Re: How to retrieve Message Body from BizTalk Database||rene.r...@gmail.com||2/14/07 7:47 AM|
I faced the same question a while ago when I searched directly in the
database, I believe there is a field where the data is stored
(actually two) that are called imgBody and imgContext, but it is not
possible to query them and retrieve the actual xml document. In order
to retrieve the document, what I have done is
a. First option is to code an interface using the biztalk dlls
provided, but it is kind of tricky because you will have to know the
exact message identification. For example, I code a console
application in c# but to retrieve the message it demands the messageid
as a parameter.
b. WMI, sort of the same, but a lot more "user friendly".
I hope that using the biztalk interfaces could help you in your
|Re: How to retrieve Message Body from BizTalk Database||BASKAR BV||2/14/07 9:09 PM|
Thanks for the reply. can you send me the table name where the imgbody and
|Re: How to retrieve Message Body from BizTalk Database||Randal van Splunteren||2/15/07 5:52 AM|
Just curious, but why do you want to read the XML directly from the messagebox?
Randal van Splunteren
> Thanks for the reply. can you send me the table name where the imgbody
> "rene.r...@gmail.com" wrote:
|Re: How to retrieve Message Body from BizTalk Database||BASKAR BV||2/15/07 7:16 AM|
suppose i have a message which has "cost" as one of the field. i would like
to query all the transaction that happened in a day where cost is some number
or so.. or i would like to query how much messages comes in a day from a
particular vendor. I hope this could be possible thru BAM but wondering how
BAM gets such results?? Correct me if BAM cannot do such request.
|Re: How to retrieve Message Body from BizTalk Database||rene.r...@gmail.com||2/15/07 10:57 AM|
I see your scenario and is kind of different than it was for me. I was
Good luck !
On 14 feb, 23:09, BASKAR BV <BASKA...@discussions.microsoft.com>
|Re: How to retrieve Message Body from BizTalk Database||Sander Schutten||2/16/07 1:21 AM|
If you want to be able to search for messages in HAT:
If you want to collect message info with BAM:
Be careful with promoting too much properties as each will cost you
|RE: How to retrieve Message Body from BizTalk Database||Niriven||4/16/07 11:36 AM|
I will not get into the biztalk DB specifics, but:
In the biztalk message box DB, there are two tables:
MessageParts - High level message data (including message id, message type,
In parts, there is a field called imgPart. This is the message itself. This
Instructions to read imgPart in a plain text (readable) format:
1) Create a new managed project (some sort of .net project)
foreach (DataRow row in ds.Tables["MyImages"].Rows)
The important part here is the functionality,