Sample Nova Mode Work Area to Release Area XML Output Formats
This section has some samples for XML output formats.
Data row as element: Data Object
<?xml version="1.0" encoding="UTF-8"?>
<distribution>
<header>
<job><![CDATA[Real-time Message Distribution]]></job>
<extract_date><![CDATA[2010-10-06 15:08:18]]></extract_date>
<onedata_version><![CDATA[6.1]]></onedata_version>
<repository><![CDATA[DEV]]></repository>
</header>
<data>
<datarow transaction_type="INSERT" table="BRANDTYPE_TEST">
<column name="TYP_ID"><![CDATA[1]]></column>
<column name="TYP_NM"><![CDATA[Raymond]]></column>
</datarow>
</data>
</distribution>
Data row as attribute: Data Object
<?xml version="1.0" encoding="UTF-8"?>
<distribution>
<header>
<job><![CDATA[Real-time Message Distribution]]></job>
<extract_date><![CDATA[2010-10-06 15:20:12]]></extract_date>
<onedata_version><![CDATA[6.1]]></onedata_version>
<repository><![CDATA[DEV]]></repository>
</header>
<data>
<datarow transaction_type="INSERT" table="BRANDTYPE_TEST" TYP_ID="2"
TYP_NM="Vimal"/>
</data>
</distribution>
Table-column as element: Data Object
<?xml version="1.0" encoding="UTF-8"?>
<distribution>
<header>
<job><![CDATA[Real-time Message Distribution]]></job>
<extract_date><![CDATA[2010-10-06 15:24:12]]></extract_date>
<onedata_version><![CDATA[6.1]]></onedata_version>
<repository><![CDATA[DEV]]></repository>
</header>
<data>
<BRANDTYPE_TEST transaction_type="INSERT">
<TYP_ID><![CDATA[3]]></TYP_ID>
<TYP_NM><![CDATA[Type3]]></TYP_NM>
</BRANDTYPE_TEST> </data></distribution>
Table-column as attribute: Data Object
<?xml version="1.0" encoding="UTF-8"?>
<distribution>
<header>
<job><![CDATA[Real-time Message Distribution]]></job>
<extract_date><![CDATA[2010-10-06 15:30:21]]></extract_date>
<onedata_version><![CDATA[6.1]]></onedata_version>
<repository><![CDATA[DEV]]></repository>
</header>
<data>
<BRANDTYPE_TEST transaction_type="UPDATE" TYP_ID="2" TYP_NM="Type2" />
</data>
</distribution>
Data row as element: Conceptual Object
<?xml version="1.0" encoding="UTF-8"?>
<distribution>
<header>
<job><![CDATA[Real-time Message Distribution]]></job>
<extract_date><![CDATA[2010-10-06 15:33:38]]></extract_date>
<onedata_version><![CDATA[6.1]]></onedata_version>
<repository><![CDATA[DEV]]></repository>
</header>
<data>
<datarow transaction_type="INSERT" table="BRAND_TEST_">
<column name="BR_ID"><![CDATA[22]]></column>
<column name="BR_NM"><![CDATA[Brand2]]></column>
<column name="BR_TYP_ID"><![CDATA[2]]></column>
</datarow>
</data>
</distribution>