|
|
||||||
|
#1
04-22-08, 09:03 AM
|
|
|
|
|
Hello,
I have to generate a quite complex message of information provided in a database in multiple tables. Do I have to read the whole data as one input message and then transform it to the target message, or is it possible, to add data to an existing message? (I mean, can I create the target message step by step?) How would you solve this? Schema can be downloaded here: [url down] Thanks very much in advance! Max |
|
|
|
#2
04-22-08, 11:02 AM
|
|
|
|
|
Max,
It is possible to add data 'as you go' using an orchestration, but bear in mind that messages in orchestrations are immutable, so once you've created it, it cannot be amended. I would probably recommend that you make one call to your database to retrieve the information you require and map to your output format either on the Send Port response or in an orchestration. Although this will push more complexity into your data-layer, it will make the BizTalk solution simpler and will reduce the overhead of multiple database calls. If you're concerned about doing complex FOR XML EXPLICIT to generate your message from multiple tables, I have a blog post which details how to use the PATH mode introduced in SQL Server 2005, much easier! See [url down] Hope this helps, Nick. On 22 Apr, 09:03, "Markus Eßmayr" <essmayr/at/racon-linz.at> wrote: [..] |
|
|
| Similar Threads | |
| Complex mapping Hi, I am fairly new into BizTalk and I would like some advise into how to design complex mapping. More requirements being added with time made that I had to review... |
|
| Complex mapping I have a question on how to map a certin set of data from one structure and a database lookup to an output structure. Below are the details 1. Receive inbound data that... |
|
| Mapping complex In Biztalk, source schema i have a sequece group (max ocrrur = *) and output schema is a record (max occur = *). How to map to get multiple looping recores. NOw I only get... |
|
| Complex mapping Hi All, How do I map many source records to single target record in mapping. I have input/source file schema which has multiple records of same type. I Need to transform it... |
|
| Complex Mapping What I'm looking forward to is a functoid which can deflatten my input XML. My requirement requires multiple input xml scanning to generate the output xml. Following example... |
|
|
All times are GMT. The time now is 03:44 AM. | Privacy Policy
|
[Mapping] Creating very complex messages