I am a newbie to ES. So could you please help me on the below.
As per my requirement, I need to pull data from MYSQL to Elasticsearch for every minute. From ES I will be generating report by using BI reporting tool. My DB is very dynamic as it is the backkend for Online sales kind.
1 . What could i use to pull the data from DB to ES. (I just read somewhere river is depreceated, so please suggest me the right component/tool).
I might need to join many tables to get in my DB to get for each ES schema. Will it create any problem.
Also is it possible to make join among schemas in ES?
Also how do i can move the incremental data to ES for every minute. How can this be acheived?
Some of my queries could be very basic, but please help me to move forward.
Thank you for the great support.