Re: BizTalk 2006 RT2 > BizTalk Mapping

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Aug 19, 1:32 pm, "KaushaL" <kaushal.pa...@xxxxxxxxxxx> wrote:
is it possible that I can map multiple schemas (as source) to a single
schema (as destination) in a BizTalk application?
I have 15 .csv files which I suppose to import in commerce server. these
will be used as source schema.
I have a single commerce server (.xsd) schema file at destination.

Yes

Say the Commerce Server schema is called "CS.xsd" and you have an
internal message format for your application "Int.xsd", then do the
following:

-Create CS.xsd and Int.xsd
-Create the schemas for each of the .csv files (1.xsd, 2.xsd,
3.xsd...etc.)
-Create maps for each of the .csv schemas (1_to_Int.btm,
2_to_Int.btm... etc.)
-Create a map from the internal format to the commerce server format
"Int_to_CS.btm"
-Deploy the solution and bind the maps as follows:
-- All the .csv maps to the receive port.
-- The "Int_to_CS.btm" to the send port (Send to Commerce Server
Port).
-Filter the send port to receive all messages of type "Int"

You can also map directly from the .csv format to the commere server
format, but that makes it less SOA/loose coupled. Also it raises the
issue of where to bind the maps (receive or send)

Morten la Cour
.

Relevant Pages

  • Re: What is the logic of storing XML in a Database?
    ... Does that mean that CSV data with a header can't be validated? ... proprietary schema format for flatfiles and sell a proprietary tool ... for validating a CSV file that conforms to the flat file. ...
    (comp.databases.theory)
  • SED: Insert Token at specific points
    ... we Data (CSV) files with following schema ... And we want insert empty values at position 3 and 5 ... the pattern will be to big. ...
    (comp.unix.shell)
  • Re: Creating a Child Record with a different Namespace
    ... I took your schema, and changed the Person node to be ... three separate output documents as expected. ... instead of the one the <CSV> node is in. ... just change at the schema level the element form default ...
    (microsoft.public.biztalk.general)
  • Possible to Extract data from .dat files?
    ... ..dat files to a more common format so that I can re-use the data (Plain ... text, CSV, XML, anything?) ... I do have all the DB schema for all the ...
    (comp.databases.sybase)