SQL adapter

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › SQL adapter

Viewing 1 reply thread
  • Author
    Posts
    • March 16, 2010 at 6:37 PM #24395
      community-content

        I am consulting with a few companies on writing stored procedures with Biztalk.  Both companies are not pushing the SQL adapter, they are wanting to write their own code.  Is the SQL adapter that difficult to set up?

         

        We have 1 XML file that needs to be put into13 seperate tables in SQL.

      • March 16, 2010 at 9:24 PM #24396
        community-content

          Hi,

           

             You should take a look at the WCF-SQL Adapter, and here’s a blog detailing how to use it in BizTalk 2009:

          http://connectedthoughts.wordpress.com/2009/06/29/using-the-biztalk-wcf-sql-adapter-to-load-a-flat-file-into-a-sql-server-2008-table/

           

              Hope this helps,

           

              Daniel.

          • March 17, 2010 at 8:30 AM #24401
            community-content

              Daniel thanks for the information.  Would you be interested in doing this project? 

              • March 17, 2010 at 12:46 PM #24403
                community-content

                  Hi,

                   

                     It depends on the scope, timeframe and technology involved. Also, there are some logistics issues since I am working full-time.

                     Also, you can post a job requirement on this site, as there are sections for contract and full-time opportunities.

                  • March 17, 2010 at 2:38 PM #24405
                    community-content

                      I am looking at someone setting up the sql adapter to send a xml file that we have already have developed through Biztalk to SQL tables.  Do you mind me sending me your number or email address and I can call you when you have some time or I can send you mine and you can call me when you have time.

                      • March 17, 2010 at 2:52 PM #24406
                        community-content

                          Hi,

                           

                            I don’t have BizTalk 2009, only BizTalk 2006 R2, and don’t have access to the WCF-SQL adapter (licensing issue), so I don’t think I can help you with your request. You might want to try your luck with someone else…

                          • March 17, 2010 at 3:03 PM #24408
                            community-content

                              Sure your going to have to explain how to me how to create an avatar.   Do you have windows live messenger?

                            • March 17, 2010 at 3:30 PM #24409
                              community-content

                                Do you know someone that could help me?

                                • March 27, 2010 at 10:17 AM #24471
                                  community-content

                                     

                                    It’s not difficult to setup SQL adapter but depends on the business process.  You can call stored procedures via .net component through BizTalk orchestration.  Please note that  BizTalk 2006 does not support WCF adapter s. But you can use SQL adapter.

                                     

                                    • March 27, 2010 at 10:19 AM #24472
                                      community-content

                                        It’s not difficult to setup SQL adapter but depends on the business
                                        process.  You can call stored procedures via .net component through
                                        BizTalk orchestration.  Please note that  BizTalk 2006 does not support
                                        WCF adapter s. But you can use SQL adapter

                                        • March 28, 2010 at 8:26 PM #24477
                                          community-content

                                            Nandika we have 2009. Would you be interested in helping us get this put together?

                                            • April 19, 2010 at 3:30 AM #24570
                                              community-content

                                                sorry I haven’t seen your msg. How can I help you ? Tell me the issues that you are facing .

                                                 

                                              • April 19, 2010 at 3:31 AM #24571
                                                community-content

                                                  sorry I haven’t seen your msg. How can I help you ? Tell me the issues that you are facing .

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