Sync Elasticsearch with Microsoft SQL

Elastic Stack Elasticsearch
1

Hello,

Does it exits any service, plugin or something like that to sync Elasticsearch with MSSQL?
I've tried Logstash, but I don't think it's such a good fit since the database has alot of complicated relationship.

Thanks

2

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.

3

I forgot to mention that I don't control the transactions. I'm only building an API for the database that would be synced every minute or so.

4

So I guess that Logstash is the best way to handle that.

5

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.