EDI Schema to SQL Schema in BizTalk ?

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › EDI Schema to SQL Schema in BizTalk ?

Viewing 2 reply threads
  • Author
    Posts
    • December 13, 2006 at 7:45 AM #16876
      community-content

        Hi,

        I want to store EDI document into database. The EDI file created by GENTRAN server, NOT bye BizTalk. Is it possible to create a map with EDI Schema to SQL Schema?

        I think there is another way to do is. EDI -> Flat File -> SQL . In this case I have to have 2 maps. My manager doesnt like that. He wants me to use only one map to store EDI into SQL DB.

        I want to learn about EDI Mapping in BizTalk. Is there any good document for that?

        Siva

      • December 14, 2006 at 2:29 AM #16899
        community-content

          If you process the EDI message with the biztalk EDI adapter, the adapter will parse the EDI document and return an XML file containing the EDI file info.

          You should be able to map this XML and insert it into your Db via the SQL adapter…

        • December 14, 2006 at 2:40 AM #16901
          community-content

            EDI -> Flat File -> SQL . In this case I have to have 2 maps.

            only 1 map in this solution also no?

            But if you have the FlatFile adapter you won't be able to verify the syntax rules of the EDI file…

        • Author
          Posts
        Viewing 2 reply threads
        • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.