XML was designed to transport and store data. Extensible Markup Language (XML) is a markup language that defines a set of rules for encoding documents in a human and machine readable format. XML Schema, on the other hand is an abstract collection of metadat, which consists of a set of components, usually termed as element and attribute declarations and complex and simple type definitions. While working with XML and XSD Schemas, Businessworks provides one with XML Palette for parsing XML Strings into schemas and rendering schemas into XML Strings.
XML Palette provides following activities:
Parse XML: Parse XML helps one create a XML Schema from a binary XML file or a XML String, post processing it based on XSD or DTD Defined. BusinessWorks suggests one uses Read File activity to set binary mode to read an XML file and then pass the binary contents which are the Output of Read File activity. While reading Date and DateTime strings, one needs to keep in mind that BW reads the same according to ISO-8601 standards. For example, the value:
is 35 minutes, 31 seconds, and 101 milliseconds after 2PM on 20th Feb, 2012 in a time zone that is 5 hours, 30 minutes ahead UTC (IST timings)
In case where no time zone is present, then it considers the time zone of the machine on which process is running. This may give misleading results, hence BW suggests one uses time zones when working with Date and DateTime.
Render XML: Render XML does the reverse of Parse XML. It takes XML Schema as an input and gives out stream of bytes representing XML or an XML String. One may use Write File for writing binary contents to disk by mapping the binary stream to input of Write File . Same way as for Parse XML, BW suggests a way to handle Date and DateTime for Render XML too. BW always uses UTC time for generating Date and DateTime strings. For example, the value:
is 25 minutes, 18 seconds, and 102 milliseconds after 2PM on 20th Feb, 2012
Transform XML: Transform XML helps one transform an XML document into output as defined by the mapped XSLT File. This is helpful in cases when the data needs to be formatted in some particular format as defined by XSLT.