N. America: 800 876 3101 | World: 44 (0) 1753 218 930

Example: Using a BizTalk Server Process to Convert EDI to XML

Using XML Schema

To create our BizTalk process, we will build a BizTalk map that translates the purchase order into the order system flat file structure. In order to accomplish this, we need one XML Schema that describes the incoming purchase order and another that describes the outgoing order system flat file. We can use Stylus Studio XML Enterprise Suite to create both XML Schema.

Creating XML Schema from EDI

The Stylus Studio EDI to XSD document wizard lets you create XML Schema from numerous EDI dialects and message types:

Stylus Studio EDI to XML Wizard (Click to enlarge)
(click to enlarge)

To run this wizard, select File > Document Wizards from the Stylus Studio menu, and then select XML Editor > EDI to XSD.

Creating XML Schema from a Flat File

Stylus Studio XML Enterprise Suite also has tools that can help you create XML Schema from other file formats, like CSV (Comma-Separated Values).

To create an XML Schema from a flat file in Stylus Studio XML Enterprise Suite:

  1. Load an example of the order system flat file in Stylus Studio.
  2. Open it using Stylus Studio’s built-in CSV converter, which converts the sample CSV file to XML.
  3. Create an XML Schema based on the converted XML – select XML > Create Schema from XML Content from the Stylus Studio menu.
  4. Stylus Studio Creates XML Schema from Flat Files (Click to enlarge)
    (click to enlarge)

    Once we have XML Schema describing the format of both the purchase order and the order system document formats, we can create a BizTalk map to represent the conversion process, as shown in the following illustration:

    Creating a BizTalk Map (Click to enlarge)
    (click to enlarge)

    Summing Up

    DataDirect XML Converters make it easy to use data from numerous file types as XML. You can use DataDirect XML Converters in your Microsoft BizTalk Server applications to access data stored in almost any format as XML. Try it today!

New Webinar: HIPAA

Title: Quick and Easy HIPAA 5010 & ICD-10 Compliance

In this free webinar, you will learn how to convert:

  1. HIPAA 4010 and 5010 message structures
  2. ICD-9 to ICD-10 codes

Replay this compliance webinar today!

Try the DataDirect Data Integration Suite Free!

Our free trial lets you see for yourself how easy it is to build data integration applications that access relational, EDI, and other file formats as XML!