I want to create an ElasticSearch index with some content of my database. That's a relational database.
What I want to index is document that I have stored in my database in blob fields. I want to index it and perform full text search over them.
I have tryied with a single document using the ingest plugin and it works properly. What I want now is to automitize my process, but I don't know if I can't do it with logstash (with a connection to my database) or what solution to implement. And how about the index for that field?
Thanks in advance!