Someone asked me about Correlation sets in BizTalk 2004 again today and I went back to my previous posting to notice that my import of my previous postings has left them in a bit of a mess - formatting is horrible on anything before January. I'll have to fix this at some point but in the meantime I thought I'd put up a (rough) sample of using correlation.
The sample's here - it was zipped up with WinZip 9.0 so take care.
What's in it? Essentially, an orchestration which receives an "expense" document, submits it to a web service (which logs it into SQL) and then waits for a response which it correlates back on the employee's first and last names.
To make it run. Deploy the web service. Hack the code in there to setup a connection to your DB and create a table in that DB called expenses which needs to have at least one column called expensereport of type vchar(2048) or similar. Any other columns need to be nullable or have defaults.
Having done that, deploy the BizTalk assembly and bind the orchestration. It's up to you what transports you use but files make it easier for pretty much everything. Note - you'll probably need to update the web references in the orchestration depending on how you deploy the web service.
Posted
Fri, Jan 23 2004 10:04 PM
by
mtaulty