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:
-
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.
-
Is sending the entire document via Biztalk to a stored procedure that parses the document & interface with SQL the best design?
-
Should biztalk be used or is a XML web service the better option?
Please help!