New to elasticsearch : Context : Oracle database contain records with JSON and different datastruct, Using command line i need to connect the database and combine datastruct and JSON and create a output as JSON file to post on elasticsearch index

Elastic Stack Elasticsearch
1

New to elastic search: Context: Oracle database contains records with JSON and different data struct, Using command line I need to connect the database and combine data struct and JSON and create an output as JSON file to post on the elastic search index.

2

Welcome!

I shared most of my thoughts there: http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/

Basically, I'd recommend modifying the application layer if possible and send data to elasticsearch in the same "transaction" as you are sending your data to the database.