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.