Updating/Retrieving SQL Data From XML Document

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Updating/Retrieving SQL Data From XML Document

Viewing 0 reply threads
  • Author
    Posts
    • #18493

      I am a novice BT developer developing creating a service that takes a huge XML document and updates a SQL database or retrieves data from the same SQL database and updates the XML document.  On the surface it seems simple enough but the XML document is a very large document that was transformed by BT into a 40-page schema biztalk schema.

      There are multiple issues I have to consider so I’m asking the help from experience biztalk gurus, for example:

      1. Embedded into the XML document are multiple nodes referencing multiple SQL tables so one submission of the document will result in update, insert or retrieval of multiple SQL tables.
      2. Is sending the entire document via Biztalk to a stored procedure that parses the document & interface with SQL the best design?
      3. Should biztalk be used or is a XML web service the better option?

      Please help!

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