How to use the SQL receive adpater to fetch the data from the database

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › How to use the SQL receive adpater to fetch the data from the database

Viewing 1 reply thread
  • Author
    Posts
    • July 13, 2010 at 5:30 AM #25215
      community-content

        Hi

        I want to use SQL receive adpater to fetch the data from the databaseusin stored procedure in Biztalk 2009.

        Please tell me which steps I have to follow.

      • July 13, 2010 at 1:21 PM #25226
        community-content

          Hi,

           

             I would suggest using the WCF SQL Adapter in BizTalk 2009 to call stored procedures from the database. Here’s a BizTalkGurus blog showing you how to use that:

           

          http://www.biztalkgurus.com/blogs/biztalksyn/archive/2009/03/02/using-the-wcf-sql-adapter-in-net-calling-stored-procedures.aspx

           

          • July 13, 2010 at 11:49 PM #25231
            community-content

              Thanks

              I don’t want to use WCF SQL adapter.

              Please tell me other solution.

               

              • July 14, 2010 at 8:11 AM #25236
                community-content

                  Hi,

                   

                     Since you are using BizTalk 2009, is there any reason why you don’t want to use WCF SQL adapter to fetch data from a database? Some other alternatives would be:

                   

                  1. Wrap your database call in a .NET assembly and call that assembly from a BizTalk orchestration.

                  2. Wrap your database call in a Web Service (SOAP or WCF) and call that service from a BizTalk orchestration.

                   

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