I am trying to move XML data that is stored in an Oracle 11 database as type XMLTYPE to anything else. I would be fine with simply being able to export into a delimited text file. The problem being I do not see where or how to allow Talend to loop thru the XML document as an XML document.
I have ran into a wall trying to process an XMLTYPE Oracle document from Oracle. I can not find anywhere that shows how to parse thru the stored XML document.
I found one post that was directed towards creating the XMLTYPE but nothing about pulling data out.
This is the Oracle schema / DDL
ouput_row.XML_DOCUMENT = new String(input_row.XML_DOCUMENT)
output_row.GO_XML = new String(input_row.GO_XML);
extractvalue(XML_DOCUMENT, '/cds-mistint/tt_cds-mistint/store-nbr/text()') as STORE_NBR,
extractvalue(XML_DOCUMENT, '/cds-mistint/tt_cds-mistint/control-nbr/text()') as CONTROL_NBR,
extractvalue(XML_DOCUMENT, '/cds-mistint/tt_cds-mistint/line-nbr/text()') as LINE_NBR,
extractvalue(XML_DOCUMENT, '/cds-mistint/tt_cds-mistint/sales-nbr/text()') as SALES_NBR
where GUID = 'PRIMARY_KEY'
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Practical steps to developing your data integration strategy.