XML stands for Extensible Markup Language and is used for many data integration purposes. The basics of XML are built from lines of code that contain a tag and data. A tag is something that identifies what the data is, like a label. <invoiceNumber> for example would be a tag identifying the data of an invoice number. Tags open and close, containing the data they are labelling. So in an XML invoice file, you might see:
<invoiceNumber>INV123</invoiceNumber>
<purchaseOrderNumber>4500012345</purchaseOrderNumber>
<invoiceDate>20160115</invoiceDate>
Each tag represents a field of data that can be used to communicate information.
Here’s what an XML document looks like. As you can see, complex files can be difficult to understand and look more like code than a readable file.
Because an XML tag can be anything, there is a lot of variety in XML files. A system can define whatever it wants as a tag to communicate information. In order to improve efficiency, many industries have adopted this standards. These are standards where users agree to use the same tag names for the same information. Example standards are cXML, UBL, PIDX, IDOC, etc. The syntax of these standards are the same, but the tags and the data they communicate are different.
XMLs can also have an XSD file associated with them. This is another file type similar to XML that defines the specifications of the files to use. It basically tells a system what the tags are, how they are structured, what data is allowed in each tag, and how often they will repeat. This allows for a much more robust validation of the XML files coming in and out of the system.
As you can see, Babelway takes the complicated XML code and represents it in a more visual and understandable way. Each data within a tag is represented in a node that can be used in the visual transformation tool. Babelway allows you to use all of a portion of the data, apply validations as needed, and manipulate it in any way possible. Since each XML may apply a different standard or maybe a unique file, Babelway gives you the flexibility to use the data however necessary.
Würth …
Create your incoming or outgoing XML structure from a sample or from an associated XSD file
Use simple drag & drop tools to map your XML message to any other format for easy import/export in/from your database
Connect your Babelway environment using any EDI or non-EDI communication protocols
Babelway is not only a great self-service platform but also a team of pros ready to help you succeed.
IT Department, Vandeputte