Using BizTalk for queing and database update

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Using BizTalk for queing and database update

Viewing 3 reply threads
  • Author
    Posts
    • March 19, 2008 at 5:09 PM #19089
      community-content

        I have configured a BizTalk receive port in my local environment to monitor a directory and pick up xml files from the directory and then the send port moves the xml files into another directory.

        What I am trying to do now is configure queing of these messages, process these messages and save the message contents to the database.

        Can someone give me some direction on how to do this?

         

         

      • March 21, 2008 at 2:59 PM #19102
        community-content

          You can have an orchestration subscribe to inbound messages on receive location, then update database either using SQL adapter or execute a component that wraps your db update logic. I didn’t understand your requirement to “queue” the messages…? I guess you don’t need it.

        • March 31, 2008 at 4:06 AM #19196
          community-content

            Hi,

             If your application cannot afford for the performance overhead introduced by activating the orchestration, you can also develop a very simple receive pipeline to wrap your database API (log the msg to DB) and use this pipeline wherever you want, ie: any receive location in your application.

             

          • March 31, 2008 at 5:31 AM #19197
            community-content

              To the original poster: have a look at the following links detailing usage of the BizTalk SQL Adapter:

              1. SQL Adapter Samples (Word Document)

              2. SQL Adapter (BizTalk Server Sample)

              3. Walkthrough: Using the SQL Adapter with a Stored Procedure in an Orchestration

              4. Using a SQL Adapter in BizTalk Server 2004

              Hope these links are of use.

              Cheers, Nick.

              • September 16, 2008 at 3:59 AM #20727
                community-content

                  How to update the CRM database using Biztalk?????????

                  • September 16, 2008 at 4:04 AM #20728
                    community-content

                      Anon, which CRM database do you mean – can you offer a little more information?

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