Processing XML from database

CloverDX Platform
1

Hello! I’m trying to get data from Oracle which stored as XML in CLOB field. I was able to get a set of strings that contains XML. But I stuck with processing of these strings. I need to get some data from XML and load them into another database. I tried to use XMLExtract, XMLReader and XMLXPathReader, but all of them want URL file. Is it possible to pass XML not from file but from string?

2

Hi Volea,

Please take a look on http://doc.cloveretl.com/documentation/ … aders.html . In most readers you can read input from edge.

In your case “port:$0.FieldName:discrete” will work.

3

Thanks a lot! It works fine!