Split a XML file into several single XML files and map against DB schema

Home Page Forums BizTalk 2004 – BizTalk 2010 Split a XML file into several single XML files and map against DB schema

Viewing 1 reply thread
  • Author
    Posts
    • #25766

      I have a XML file which contains several “Estate” records. Every “Estate” record has several categories like <customer_information>, <estate_information>, <picture_information>, <map_information>, etc. which contain more detailed information. Every information tag then has to be mapped against a schema of a DB-table in the database “Estate”. We have a table “customer_information”, “estate_information”, “picture_information”, “map_information”, etc.

      My first idea is to split the big XML file into several autonomous “Estate” XML files. Then map all single “Estate” information tags against a schema of every db table. Is it possible to split the big XML file with several Estate records into several single Estate XML files with the pipeline? If so can I do the mapping inside the receive port immediately after the splitting inside the pipeline?

      After that I would like to send the mapped tag informations to the associated DB table.

      For a better understanding I have created a word document with a drawing of my idea.

      http://rapidshare.com/files/415410452/WorkToDo.doc

       

    • #25776

      If I were in your shoes, I would have invested more time in implementing a single map (using XSLT) to get this done once regardless the source and destination schema.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.