Re: help, xml file created from unrelational database

Greetings MJ,
You can do this using the mapping utility in BizTalk 2004. I think you
will find some siliarities in the following examples. You may find that
you will need to devise a custom schema that your company will
initially transform all related inbound messages to in order to
standardize/reuse the various business processes/orchestrations that
are related to this type of data (Common Business Object)

The Looping functoid combines multiple records or fields in the source
schema into a single record in the destination schema.The following
link shows a Looping functoid used in a map to combine addresses
collected from two different surveys into a single master address list.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sdk/htm/ebiz_prog_map_nvsc.asp

This section briefly describes a map using the Table Looping and Table
Extractor functoids
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sdk/htm/ebiz_prog_map_xami.asp

.

Relevant Pages

  • Re: Mapping problem (newbie)
    ... map trying different things, I don't think I have an up to date version. ... I used a table looping functoid but was getting the error below. ... My destination schema has the three ... fields that could be listed in the "ReferenceInformation" node. ...
    (microsoft.public.biztalk.general)
  • Re: BizTalk 2004 :: Table looping functoid :: dont laugh
    ... looping functoid mappings are unmanagable so a broken down mapping in the ... > send port. ... > xml schema using a map on the receive port. ... the is one of the most complex mappings I have ever ...
    (microsoft.public.biztalk.general)
  • Re: Looping Functoid
    ... your schemas, map, and an input instance file. ... >>I have a schema that has row and column data ripped from cells in an excel ... >>is connected to a looping functoid ...
    (microsoft.public.biztalk.general)
  • RE: Table Looping Functoid ==> error btm1023: System.OutOfMemoryExcept
    ... try it through messaging and see if it changes the results. ... > I created a map using a Table Looping Functoid. ... When I validate the map I ... > While working with a few input parameters it worked fine, ...
    (microsoft.public.biztalk.general)
  • 2k4 edi to database
    ... Some of the line data seems to be missing after using the looping functoid, ... When I map the QTY to the output, it only maps the first QTY ... seems to be an issue with multiple REF loops being mapped to a flat ...
    (microsoft.public.biztalk.general)
Loading