I have a SQL database in my program and I use to view data ElasticSearch and for updates the SQL (I know that in the new version 6.3 i can do queries like SQL), but the problem that I have is that I have update of information using stored procedures but the document of elasticSearch not have these changes.
Do you know any good practice to have updated?
I don't think I understand the question.
You said that you have data in a SQL database and you update that data using stored procedures. But the updates going into your SQL database are not reflected in the Elasticsearch documents?
How do you look at the data from your SQL database with Elasticsearch?
First of all, sorry for my explanation that is not good. The mainly question is if I can update with SQL directly the register of elasticSearch. Now the update of ElasticSearch is on-demand but i would like can update the data of ElasticSearch everyday using the same SQL or another way to do it.
I think most people use logstash or some other app to pull new data from there source system and push into elastic, on a schedule E.g. every 5 minutes. This is best when elastic does not need to be updated in realtime.
The other option is for your app to push to both elastic and the source database.
I would go with the first option if you can.
At the moment, ES SQL supports only reading the documents. Inserting/updating documents or using stored procedures is not supported.
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.