Storing messages in a database.

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Storing messages in a database.

Viewing 1 reply thread
  • Author
    Posts
    • October 23, 2006 at 1:57 PM #16151
      community-content

        Hi.

         Im quite new in using Biztalk, and have developed some easy orchestrations.

         
        But I dont understand howto store the messages in a database on the server.

         
        And then later on I want to compare incomming messages with messages that have arrived earlier.

         

        Thanks.
         

      • October 23, 2006 at 2:46 PM #16154
        community-content

          Well, you might be able to do this using a Convoy.  But BizTalk really wasn’t designed to store messages in its databases out of the box.

           

          I’m guessing your best bet would be to have a custom process to store your message to a SQL database.

           

          Hope this helps.

          • October 23, 2006 at 3:37 PM #16155
            community-content

              Ok, thanks..

               

              But, do BizTalk log and store the messages by it self in some log?

               And is it possible to get them out from there?
               

              • October 23, 2006 at 4:23 PM #16157
                community-content

                  Let me clarify my needs a little bit.

                  What i need is to compare an incoming message with earlier messages to check if it is recieved before. I might not need a database for this?

                   What is the easiest way to do this?

                   In advance, thank you.
                   

                  • October 23, 2006 at 4:58 PM #16158
                    community-content

                      BizTalk does store messages. Messages associated with active service instances (i.e. during processing) are stored in the MessageBox, but you can also enable tracking of full messages received and sent to be stored in the tracking databases.

                       However, it does not sound to me like this is what you really want. Comparing the entire message contents to check for duplicate messages would be, at the very least, extremely expensive and really unnecessary most of the time. If your messages have some kind of natural identifier (i.e. they contain a message-id field or something else that identifies the request uniquely) then what I'd do is just to store that ID in a DB (not necessarily the entire message content, just the ID) and then compare that during the receive (either in a pipeline component for maximum efficiency, or at the beginning of an orchestration).

                       

                      • October 23, 2006 at 5:24 PM #16159
                        community-content

                          Yes that is what I want..

                           But how do I store the ID in a database?

                           And how do I compare?

                           

                          Thank you
                           

                          • October 23, 2006 at 5:41 PM #16161
                            community-content

                              I found the tracking feature, but how do i specify that I only want to track an ID?

                               An how do again compare?
                               

                • Author
                  Posts
                Viewing 1 reply thread
                • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.