Processing XML from database

volea

• October 15, 2014 00:00

• Answered

Follow

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?

• 

  admin

  • October 15, 2014 14:45

  0

  Comment actions Permalink

  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.
• 

  volea

  • October 15, 2014 15:40

  0

  Comment actions Permalink

  Thanks a lot! It works fine!

Please sign in to leave a comment.