I want to send data from my DB Sql server to ES, the database is on another server, only the local host I received
You can connect to external servers with Logstash to ingest data. Not sure if that was your question.
I use jdbc to connect to sql server on windows machine and pull the data to ES
Not exactly the answer but I thought it'd be worth sharing.
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.
Have also a look at this "live coding" recording.
1 Like
I managed to ingest but I have a question that is if I can ingest the whole bank without having to make a query bringing all the tables I want
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.