elasticsearch - Elastic Search SQL Server -

elasticsearch - Elastic Search SQL Server -

we trying implement free text search using elastic search.

the plan utilize

ourapplication | nest | elastic search | ????????????? | sql server

the database sql server , create, update , delete operations on tables performed mutiple applications.

how can populate , refresh indexes in elastic search ?

i went through river jdbc route, people saying depreciated in farther releases ?

if utilize river jdbc how can refresh indexes when updates happen ?

in simple can when operation performed update, add together or delete phone call respective function of elastic search. when record updated phone call function updates record index , type in elastic data. same thing write , delete operation. used same thing auto suggestion , text free search in term project. regards

sql-server elasticsearch nest