|
|
||||||
|
#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 http://www.modhul.com/2008/01/23/an-...-xml-explicit/ Hope this helps, Nick. On 22 Apr, 09:03, "Markus Eßmayr" <essmayr/at/racon-linz.at> wrote: [..] |
|
|
| Similar Threads | |
| Thread | Thread Starter |
| 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... |
Francois Malgreve |
| 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... |
JoelGBrown24 |
| 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... |
Micheal |
| 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... |
Btvn |
| XML 2 SQL without complex mapping Hello, I need a tool (preferable in PHP to run on every webserver or very easily accecable by PHP) which can convert data from XML to a relational DBS (MySQL). I donnot want... |
Leo Heber |
|
Privacy Policy | All times are GMT. The time now is 05:48 PM.
|
|
[Mapping] Creating very complex messages