OneData 10.7 | Managing Master Data with webMethods OneData | Implementing webMethods OneData | Exporting Data from OneData Objects | Export Jobs | Export Formats
 
Export Formats
OneData export jobs export data directly to a destination database untransformed, extracted into a messaging object, or written to a file in XML format.
Data that is written to a file or a messaging object is converted into XML format. You can set how data is transformed into an XML element and within the element hierarchy as one of the following:
*Data row as element. Converts each record into a <datarow> element, and each column of the record into a child element of <datarow>. For conceptual objects, the XML shows the hierarchy of the parent object.
*Data row as attribute. Converts each record into a <datarow> element and each column of a record into an attribute.
*Table-Column as element. Converts the column heading into a parent element and each column in a record as a child element.
*Table-Column as attribute. Converts the column heading into a parent element each column in a record as an attribute.
You can determine how OneData treats empty columns in the XML with the Output for columns with zero-length values setting. The options are:
*Output as “null”. Creates an element tag for empty columns and populates them with the word null as the element value.
*Output as empty element/attribute. Creates an element tag for empty columns and leaves the element value blank.
*Hide the column. Omits the element tag for empty columns.