How to publish the Orchestration if we are using SQL Adapter

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › How to publish the Orchestration if we are using SQL Adapter

Viewing 1 reply thread
  • Author
    Posts
    • February 14, 2008 at 6:26 AM #18938
      community-content

        Hi Sir,

        Please help me out, because i am stuck.

         

        actually i have created on orchestration which having SQL Adapter calling the Stored procedure and i had publish that bizTalk orchestration as web services bu wen we are adding SQL adapter to the orchestration that time what ever schem file get created in that file we can not promot the response element and becuase of that i am not getting any thing as out. i am calling this business process from web application.

         

         

        can you tell me how to use SQL adpater orchestration as web services??

         

        thanks &regards

        Jaiswar Vipin Kumar R.

        India – 09869566849

      • February 17, 2008 at 5:37 PM #18948
        community-content

          I am not exactly sure that I follow you…but I will try.

          When you use the SQL Adapter, you are not using web services, but rather a native BizTalk Adapter that uses MSDTC to support transactions. So what you can do is expose your orchestration as a web service which would allow your web applicaton to “talk” to your orchestration.  Within your orchestration you would then create a Solicit Response Send Port.  Using this send port you send a “SQL Request” to SQL Server, in turn SQL Server will provide you with a “SQL Response”.

           In order to use the SQL Adapter in an orchestration you need to use the “Add Generated Items” Wizard -> “Add Adapter Metadata”.  This will allow you to provide a “sample” SQL statement and BizTalk will automagically create the Request and Response schemas in your orchestration.  Once you deploy your application you will then need to create a Send Port that connects to SQL Server.

          This document provides a detailed walk-through

          http://technet.microsoft.com/en-us/library/ms935658.aspx

          • January 9, 2009 at 5:40 AM #21492
            community-content

              Thanks Wearsy,

               

            • January 9, 2009 at 7:03 AM #21494
              community-content

                Even I am not sure, if I understood your question.  Let me add something more.

                I did not get your question “how to use SQL Adapter orchestration as web services”.  Note that you are publishing a logical port on the orchestration as web service.  If you already had SQL Adapter then now your orchestration logical port can get the same message either from SQL Adapter or web service

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