How to import oracle Clob data in a Index of Elastic

Elastic Stack Logstash
1

We have big tables with data stored as XML clob in Oracle. Now we need to import this data in Elastic and sure we can't import and store it as XML in elastic. instead want to store it as different field values of a document in elastic.

Has anybody done it ?

2

You should be able to use Logstash's jdbc input and its xml filter.

3

Thanks for the response. Do you have any code sample?

Salil

4

The jdbc input documentation contains a few examples. Start there and verify that you can pull data correctly, then continue with the xml filter.