I have a web service data source in Denodo 7 and one of its operations returns a single column text result which contains an xml document embedded in an XML CDATA section.
I would like to be able to flatten / parse the xml doc in denodo but at the moment i cannot get it to recognize it is xml format. I have tried to create a view with a new column using:
replace(replace('response', '<![CDATA[', ''),']]>','')
but this does not help. I have also tried to create a 'flattened array' view on top of the above mentioned view but it still does not recognize any of the xml nodes.
Any assistance would be appreciated!