%3CLINGO-SUB%20id%3D%22lingo-sub-1445919%22%20slang%3D%22en-US%22%3EBizTalk%20Server%20Patterns%20%E2%80%93%20The%20Parallel%20Shape%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445919%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20parallel%20shape%20in%20BizTalk%20Server%20(from%20v2004)%20is%20widely%20misinterpreted%20to%20be%20multi-threaded.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CTABLE%20border%3D%221%22%20width%3D%22100%25%22%3E%0A%3CTBODY%3E%0A%3CTR%3E%0A%3CTD%20width%3D%2250%25%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22image1.png%22%20style%3D%22width%3A%20244px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197060iF0DA6A0D77CCABDB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image1.png%22%20alt%3D%22image1.png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FTD%3E%0A%3CTD%20width%3D%2250%25%22%3EWhat%20the%20parallel%20shape%20does%20well%20is%20that%20it%20ensures%20that%20all%20branches%20complete%20their%20execution%20before%20the%20next%20process%20takes%20place.%20The%20parallel%20shape%20does%20a%20context%20switch%20on%20a%20thread%20wait%20(busy%20waiting%2C%20such%20as%20waiting%20for%20a%20message%20to%20come%20in%20from%20a%20receive%20port)%20between%20branches.%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%3E%0A%3CTD%20width%3D%2250%25%22%3E%3CP%3EThe%20reason%20why%20the%20parallel%20shape%20is%20single-threaded%2C%20is%20because%20the%20orchestration%20workflow%20itself%2C%20is%20single-threaded.%20However%2C%20it%20is%20still%20possible%20to%20conduct%20%E2%80%9Cmulti-threaded%E2%80%9D%20execution%20within%20BizTalk%20Server.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22image2.png%22%20style%3D%22width%3A%20269px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197067iDE2D51CC71366452%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image2.png%22%20alt%3D%22image2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%2250%25%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image3.png%22%20style%3D%22width%3A%20143px%3B%22%3E-ERR%3AREF-NOT-FOUND-%3C%2FSPAN%3E%26nbsp%3BA%20common%20practice%20to%20%E2%80%9Cmulti-thread%E2%80%9D%20the%20parallel%20shape%20is%20to%20use%20the%20%E2%80%9CStart%20Orchestration%E2%80%9D%20shape%2C%20which%20will%20instantiate%20a%20separate%20orchestration%20workflow%2C%20with%20its%20own%20thread%2C%20and%20resources.%20Hence%2C%20all%20the%20logic%20would%20reside%20in%20the%20child%20orchestrations%20that%20would%20be%20called%20from%20the%20parent%20orchestration.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image4.png%22%20style%3D%22width%3A%20121px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197070i9EACD27886063C67%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image4.png%22%20alt%3D%22image4.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3C%2FTBODY%3E%0A%3C%2FTABLE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHowever%20%E2%80%93%20suppose%20that%20the%20number%20of%20branches%20of%20executions%20are%20not%20known%20at%20design%20time%2C%20then%20the%20parallel%20shape%20would%20not%20be%20suitable%20to%20use.%20A%20different%20approach%20will%20be%20required.%3CBR%20%2F%3EA%20classic%20example%20of%20parallel%20execution%20is%20de-batching%20a%20large%20message%20file%20into%20smaller%20files%2C%20and%20then%20aggregating%20all%20the%20results%20into%20a%20single%20large%20result.%20Each%20subset%20(small%20file)%20represents%20an%20independent%20unit%20of%20work%20that%20does%20not%20rely%20or%20relate%20to%20other%20subsets%2C%20except%20that%20it%20belongs%20to%20the%20same%20batch%20(large%20message).%20Eventually%20each%20child%20process%20(the%20independent%20unit%20of%20work)%20will%20return%20a%20result%20message%20that%20will%20be%20collected%20with%20other%20results%2C%20into%20a%20collated%20response%20message%20to%20be%20leveraged%20for%20further%20processing.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image5.png%22%20style%3D%22width%3A%20502px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197071i351AD549E0123095%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image5.png%22%20alt%3D%22image5.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CTABLE%20border%3D%221%22%20width%3D%22100%25%22%3E%0A%3CTBODY%3E%0A%3CTR%3E%0A%3CTD%20width%3D%2250%25%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image6.png%22%20style%3D%22width%3A%20241px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197072iB3D4E0AB8C753291%2Fimage-dimensions%2F241x371%3Fv%3D1.0%22%20width%3D%22241%22%20height%3D%22371%22%20title%3D%22image6.png%22%20alt%3D%22image6.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FTD%3E%0A%3CTD%20width%3D%2250%25%22%3E0.%20The%20initial%20step%20consists%20of%20de-batching%20the%20large%20message%20in%20the%20receive%20pipeline%20into%20smaller%20child%20messages.%3CBR%20%2F%3E1.%20The%20receive%20pipeline%20publishes%20the%20child%20messages%20to%20the%20message%20box%20database.%3CBR%20%2F%3E2.%20Child%20business%20process%20orchestrations%20(or%202-way%20send%20ports)%20subscribe%20against%20the%20child%20messages%20to%20accommodate%20business%20requirements.%20Note%20that%20individual%20business%20processing%20does%20not%20explicitly%20require%20orchestrations.%3CBR%20%2F%3E3.%20Responses%20from%20Line-of-Business%20(LOB)%20applications%20are%20submitted%20back%20to%20the%20child%20orchestrations%20(or%20to%202-way%20send%20ports).%3CBR%20%2F%3E4.%20These%20responses%20are%20aggregated%20back%20by%20an%20aggregator%20(can%20be%20accommodated%20by%20an%20orchestration%20as%20depicted%2C%20or%20by%20a%20SQL%20stored%20procedure).%3CBR%20%2F%3E5.%20The%20aggregator%20will%20submit%20the%20final%20aggregated%20result.%3CBR%20%2F%3E6.%20The%20next%20process%20(which%20may%20or%20may%20not%20use%20the%20final%20aggregated%20result)%20will%20proceed.%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3C%2FTBODY%3E%0A%3C%2FTABLE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDe-batching%20is%20conducted%20within%20the%20receive%20pipeline.%20To%20learn%20how%20to%20split%20a%20large%20file%20into%20smaller%20files%2C%20please%20refer%20to%20the%20BizTalk%20Server%202006%20samples%20%E2%80%93%20Split%20File%20Pipeline%20example.%20Even%20though%20the%20sample%20is%20based%20on%20BizTalk%20Server%202006%20(R1)%20%E2%80%93%20it%20remains%20relevant%20for%20all%20BizTalk%20Server%20versions%2C%20include%20v2020%3C%2FP%3E%0A%3CP%3E.%3CBR%20%2F%3E%E2%80%A2%20Note%3A%20There%20are%20several%20examples%20on%20how%20to%20de-batch%20messages%2C%20such%20as%20de-batching%20from%20SQL%20Server%2C%20as%20communicated%20by%20Rahul%20Garg%E2%80%99s%20blog%20on%20de-batching.%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3EThe%20next%20step%20is%20a%20bit%20trickier.%20The%20smaller%20messages%20need%20to%20be%20correlated%20somehow%2C%20so%20that%20their%20results%20can%20be%20aggregated%20into%20a%20singular%20large%20response%20message%20(for%20steps%204%20and%205%20to%20be%20successful).%20Correlation%20is%20typically%20done%20in%20orchestration%2C%20but%20the%20proposed%20method%20here%20avoids%20the%20use%20of%20orchestration%20altogether.%20In%20order%20to%20have%20correlation%20in%20messaging%2C%20please%20refer%20to%20Paolo%20Salvatori%E2%80%99s%20blog%20on%20Synchronous%20To%20Asynchronous%20Flows%20Without%20An%20Orchestration.%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3EIn%20it%2C%20he%20describes%20a%20method%20that%20requires%20a%202-way%20receive%20port%20(such%20as%20a%20web%20service)%20%2C%20because%20he%20leverages%20a%20couple%20of%20message%20context%20properties%20that%20are%20unique%20to%20a%202-way%20receive.%20These%20are%3CBR%20%2F%3E%E2%80%A2%20ReqRespTransmitPipelineID%3CBR%20%2F%3E%E2%80%A2%20IsRequestResponse%3CBR%20%2F%3EIn%20addition%20to%3CBR%20%2F%3E%E2%80%A2%20EpmRRCorrelationToken%3CBR%20%2F%3E%E2%80%A2%20Correlation%20Token%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3EIt%20is%20strongly%20suggested%20to%20learn%20how%20correlation%20can%20be%20achieved%20in%20messaging%20(without%20orchestration)%20as%20described%20by%20Paolo%20Salvatori%20before%20proceeding%20to%20the%20next%20step.%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3EOnce%20that%20method%20has%20been%20mastered%2C%20a%20slight%20adjustment%20is%20needed.%20Since%20the%20de-batching%20method%20is%20leveraged%20in%20the%20pipeline%2C%20correlation%20in%20messaging%20can%20be%20achieved%20with%20a%201-way%20receive%20port%20(such%20as%20picking%20up%20the%20large%20message%20from%20a%20file%20directory)%2C%20by%20using%20message%20context%20properties%20that%20are%20unique%20to%20the%20de-batch%20method.%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3EThese%20are%3CBR%20%2F%3E%E2%80%A2%20InterchangeID%3CBR%20%2F%3E%E2%80%A2%20InterchangeSequenceNumber%3CBR%20%2F%3E%E2%80%A2%20LastInterchangeMessage%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEach%20child%20message%20(which%20is%20now%20in%20the%20messagebox%20database)%20should%20instantiate%20a%20business%20process%20(either%20with%20an%20orchestration%20workflow%20or%20a%202-way%20send%20port)%20that%20will%20eventually%20receive%20a%20result%20message.%3CBR%20%2F%3EFinally%20an%20aggregator%20is%20required%20to%20collect%20and%20collate%20the%20results%20from%20the%20child%20business%20processes.%20This%20aggregator%20can%20be%20an%20orchestration%2C%20or%20the%20preferred%20way%20would%20be%20from%20a%20SQL%20stored%20procedure.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image7.png%22%20style%3D%22width%3A%20473px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197073i91C63E9E7CEA2A1D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image7.png%22%20alt%3D%22image7.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E*Image%20courtesy%20of%20Paolo%20Salvatori%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3E%E2%80%A2%20A%20message%20is%20received%20by%20a%20FILE%20Receive%20Port%3CBR%20%2F%3E%E2%80%A2%20The%20message%20is%20routed%20to%20a%20SQL%20Send%20Port%20where%20the%20original%20message%20is%20wrapped%20into%20a%20sort%20of%20envelope%20by%20a%20map%20which%20uses%20a%20custom%20XSLT.%20The%20outbound%20message%20is%20an%20Updategram%20which%20calls%20a%20stored%20procedure%20to%20insert%20the%20message%20into%20the%20table.%3CBR%20%2F%3E%E2%80%A2%20A%20SQL%20receive%20port%20calls%20a%20stored%20procedure%20to%20retrieve%20the%20records%20of%20a%20certain%20type%20from%20the%20custom%20table.%20This%20operation%20generates%20a%20single%20document.%3CBR%20%2F%3E%E2%80%A2%20This%20document%20is%20routed%20to%20a%20File%20Send%20Port%20where%20the%20message%20is%20eventually%20transformed%20into%20another%20format.%3CBR%20%2F%3EThis%20method%20was%20also%20communicated%20in%20-ERR%3AREF-NOT-FOUND-%3CA%20href%3D%22http%3A%2F%2Fgeekswithblogs.net%2Fasmith%2Farchive%2F2005%2F06%2F06%2F42281.aspx%26nbsp%3B%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fgeekswithblogs.net%2Fasmith%2Farchive%2F2005%2F06%2F06%2F42281.aspx%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3ENote%20that%20the%20XSLT%20can%20be%20eventually%20replaced%20by%20a%20custom%20pipeline%20component%20or%20directly%20by%20an%20envelope%20(in%20this%20case%20the%20send%20pipeline%20needs%20to%20contain%20the%20Xml%20Assembler%20component).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20more%20information%20concerning%20the%20parallel%20shape%2C%20see%20%E2%80%9CHow%20to%20Configure%20the%20Parallel%20Actions%20Shape%E2%80%9D%20topic%20in%20the%20BizTalk%20Server%20documentation.%3CBR%20%2F%3EHere%20is%20a%20related%20blog%20regarding%20the%20parallel%20shape%3A%3CBR%20%2F%3E%E2%80%A2%26nbsp%3B%26nbsp%3B-ERR%3AREF-NOT-FOUND-%3CA%20href%3D%22http%3A%2F%2Fwww.codeproject.com%2FKB%2Fbiztalk%2FBizTalkParallelBranching.aspx%26nbsp%3B%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.codeproject.com%2FKB%2Fbiztalk%2FBizTalkParallelBranching.aspx%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1445919%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20blog%20entry%20was%20originally%20post%20on%20October%2016th%2C%202009%20and%20can%20be%20found%20here%3A%20-ERR%3AREF-NOT-FOUND-%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Farchive%2Fblogs%2Fquocbui%2Fbiztalk-patterns-the-parallel-shape%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Farchive%2Fblogs%2Fquocbui%2Fbiztalk-patterns-the-parallel-shape%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20blog%20entry%20describes%20how%20to%20effectively%20benefit%20from%20parallel%20processing%20by%20using%20the%20BizTalk%20Server%20messaging%20engine.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1445919%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ebiztalk%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EBizTalk%20Server%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Emessaging%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1447118%22%20slang%3D%22en-US%22%3ERe%3A%20BizTalk%20Server%20Patterns%20%E2%80%93%20The%20Parallel%20Shape%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1447118%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F637136%22%20target%3D%22_blank%22%3E%40Quoc_Bui%3C%2FA%3E%26nbsp%3B%20for%20sharing%20the%20BizTalk%20Gems%20with%20the%20community%20here.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

The parallel shape in BizTalk Server (from v2004) is widely misinterpreted to be multi-threaded.

 

image1.png

What the parallel shape does well is that it ensures that all branches complete their execution before the next process takes place. The parallel shape does a context switch on a thread wait (busy waiting, such as waiting for a message to come in from a receive port) between branches.

The reason why the parallel shape is single-threaded, is because the orchestration workflow itself, is single-threaded. However, it is still possible to conduct “multi-threaded” execution within BizTalk Server.

image2.png

 

image3.png A common practice to “multi-thread” the parallel shape is to use the “Start Orchestration” shape, which will instantiate a separate orchestration workflow, with its own thread, and resources. Hence, all the logic would reside in the child orchestrations that would be called from the parent orchestration.

image4.png

 

However – suppose that the number of branches of executions are not known at design time, then the parallel shape would not be suitable to use. A different approach will be required.
A classic example of parallel execution is de-batching a large message file into smaller files, and then aggregating all the results into a single large result. Each subset (small file) represents an independent unit of work that does not rely or relate to other subsets, except that it belongs to the same batch (large message). Eventually each child process (the independent unit of work) will return a result message that will be collected with other results, into a collated response message to be leveraged for further processing.

 

image5.png

 

image6.png 0. The initial step consists of de-batching the large message in the receive pipeline into smaller child messages.
1. The receive pipeline publishes the child messages to the message box database.
2. Child business process orchestrations (or 2-way send ports) subscribe against the child messages to accommodate business requirements. Note that individual business processing does not explicitly require orchestrations.
3. Responses from Line-of-Business (LOB) applications are submitted back to the child orchestrations (or to 2-way send ports).
4. These responses are aggregated back by an aggregator (can be accommodated by an orchestration as depicted, or by a SQL stored procedure).
5. The aggregator will submit the final aggregated result.
6. The next process (which may or may not use the final aggregated result) will proceed.

 

De-batching is conducted within the receive pipeline. To learn how to split a large file into smaller files, please refer to the BizTalk Server 2006 samples – Split File Pipeline example. Even though the sample is based on BizTalk Server 2006 (R1) – it remains relevant for all BizTalk Server versions, include v2020

.
• Note: There are several examples on how to de-batch messages, such as de-batching from SQL Server, as communicated by Rahul Garg’s blog on de-batching.


The next step is a bit trickier. The smaller messages need to be correlated somehow, so that their results can be aggregated into a singular large response message (for steps 4 and 5 to be successful). Correlation is typically done in orchestration, but the proposed method here avoids the use of orchestration altogether. In order to have correlation in messaging, please refer to Paolo Salvatori’s blog on Synchronous To Asynchronous Flows Without An Orchestration.


In it, he describes a method that requires a 2-way receive port (such as a web service) , because he leverages a couple of message context properties that are unique to a 2-way receive. These are
• ReqRespTransmitPipelineID
• IsRequestResponse
In addition to
• EpmRRCorrelationToken
• Correlation Token


It is strongly suggested to learn how correlation can be achieved in messaging (without orchestration) as described by Paolo Salvatori before proceeding to the next step.


Once that method has been mastered, a slight adjustment is needed. Since the de-batching method is leveraged in the pipeline, correlation in messaging can be achieved with a 1-way receive port (such as picking up the large message from a file directory), by using message context properties that are unique to the de-batch method.


These are
• InterchangeID
• InterchangeSequenceNumber
• LastInterchangeMessage

 

Each child message (which is now in the messagebox database) should instantiate a business process (either with an orchestration workflow or a 2-way send port) that will eventually receive a result message.
Finally an aggregator is required to collect and collate the results from the child business processes. This aggregator can be an orchestration, or the preferred way would be from a SQL stored procedure.

 

image7.png

*Image courtesy of Paolo Salvatori


• A message is received by a FILE Receive Port
• The message is routed to a SQL Send Port where the original message is wrapped into a sort of envelope by a map which uses a custom XSLT. The outbound message is an Updategram which calls a stored procedure to insert the message into the table.
• A SQL receive port calls a stored procedure to retrieve the records of a certain type from the custom table. This operation generates a single document.
• This document is routed to a File Send Port where the message is eventually transformed into another format.
This method was also communicated in http://geekswithblogs.net/asmith/archive/2005/06/06/42281.aspx 


Note that the XSLT can be eventually replaced by a custom pipeline component or directly by an envelope (in this case the send pipeline needs to contain the Xml Assembler component).

 

For more information concerning the parallel shape, see “How to Configure the Parallel Actions Shape” topic in the BizTalk Server documentation.
Here is a related blog regarding the parallel shape:
•  http://www.codeproject.com/KB/biztalk/BizTalkParallelBranching.aspx 

 

 

 

1 Comment
Microsoft

Thank you @Quoc_Bui  for sharing the BizTalk Gems with the community here.