Biztalk server information

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Biztalk server information

Viewing 1 reply thread
  • Author
    Posts
    • January 19, 2007 at 8:44 AM #17318
      community-content

        Hi,

         I've just started using Biztalk server 2006 and I'm pretty green around the gills. I have a bunch of EDI files that I want processed. I was able to follow the MS tutorial for processing this and I was able to successfully generate xml documents. What I want to know is if there is a way to have Biztalk load a database with this data instead of putting it out into an xml document. If not is there another solution that can be proposed to this problem.
         

      • January 19, 2007 at 10:44 AM #17322
        community-content

          Sinkablehail,

          yes, use a SQL adapter and you can read & write information to a SQL Server database. 

          • January 19, 2007 at 11:03 AM #17324
            community-content

              [quote user="Henry M."]

              Sinkablehail,

              yes, use a SQL adapter and you can read & write information to a SQL Server database. 

              [/quote]

               

              Thanks for the tip Henry. Do you by any chance happen to have any links on creating a sql adapter in Biztalk?? 

              • January 19, 2007 at 11:52 AM #17327
                community-content

                  Sinkablehail,

                  there's a section in the BizTalk 2006 Recipes book that describes inserting a record into a SQL database, pages 337-358, and there's also a section for calling stored procedures.  I highly recommend the book, even though it is expensive at $60 retail.  The ISBN is 978-1-59059-711-8 and it was published in 2006.

                   Hope this helps.
                   

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