I have JSON stored in an Oracle database as a CLOB (serialised JSON string). I'd like to get this into Elasticsearch as a JSON object.
I have the input specified as jdbc (with the oracle connection string etc) and the output as elasticsearch. The problem is that the JSON is being stored in ES as one big string. I assume I need to do some kind of filter, I'm just not sure where to start?
Any help is greatly appreciated.