Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>It is probably possible to do what you want using a custom adapter, though I'd recommend against it. You can achieve what you require using orchestration.</p> <p>What you are looking for is likey a convoy, or at the least some use of correlation.</p> <p>In BizTalk a convoy is a messaging pattern (as opposed a BizTalk feature) that allows groups of messages to be processed by a single orchestration.</p> <p>You essentially use correlation on a receive port to group messages together in either a parallel (what you probably want) or sequential fashion.</p> <p>There is an article [here](<a href="http://msdn.microsoft.com/en-us/library/ms942189(BTS.10).aspx)" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/ms942189(BTS.10).aspx)</a> by Stephen W. Thomas about convoys (it is for BT 2004 but the concepts still hold) and there is a lot of additional information on the web and in books (Professional BizTalk server 2006 has a subsection on them)</p> <p>Without more details on your scenario it is hard to know exactly how the convoy would be built but below are two approaches to look at (also, I've not had a chance to properly use BT2009 so there may be extended support for correlation scenarios that help you out).</p> <p><strong>Flexible Correlation</strong></p> <p>If you don't know anything about the files listed in the context XML you will probably need a pattern like the one described by Charles Young in <a href="http://geekswithblogs.net/cyoung/articles/17364.aspx" rel="nofollow noreferrer">this</a> post. </p> <p><strong>Non-uniform sequential convoy</strong></p> <p>If you do have a little bit of info before hand one way might be as follows (basically a Non-uniform sequential convoy):</p> <p>This makes the assumption that there is some way of linking all the files together so you can correlate them.</p> <p>Create a single orchestration that subscribes to you inbound receive port (which contains the file receive location). </p> <p>This orchestration will have a single activation receive shape that is set up for your content file. </p> <p>Once the orchestration is started by a content file a second correlated receive shape starts picking up the messages that match that content file. (this second receive could possible be in a loop to allow for variable numbers of files)</p> <p>You then pack them all together into a single outbound file of your design and send them out once the full number of files has been received.</p>
    singulars
    1. This table or related slice is empty.
    1. POBizTalk custom adaptor
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USDavid Hall
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POBizTalk custom adaptor
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CODavid, Thank you for this information. Convoy looks interesting, yet I am not sure how it would work in this case. You see, the attachments are binary files, and know nothing about the content XML file. There's nothing to promote from those attachments. Maybe I am missing something, feel free to point that out. 10x Sean
      singulars
      1. PO
      1. USSean Feldman
    2. COThis is clearly the correct answer. Even if you don't know anything about the content of the XML file, surely you know its name and location. From this, you can use the flexible correlation like so:
      singulars
      1. PO
      1. USMaxime Labelle
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload