i have mssql database as source of truth, and people keep inserting or updating data into that, but i need to sync all that transaction by traction to elastic search, how can i do that.
i tried using CDC and kafka to get data to elastic search but i have many joins to get data from mssql to elastic search but cdc will only give me single table change.
what is the best way and tools available to do this