i'm using elasticsearch to record a lot of messages. I want to create a ETL process with this ES data and create a DW in MySQL. How can i get data from ES, create a ETL process and insert it into MySQL DB? Any tool for that or is better use ,for example NodeJS or Python?

Sync Data from ES to MySQL

dadoonet (David Pilato) September 22, 2017, 9:35am 6

Do you think is better take small pieces and treat each one?

That's what scroll API is built for.
You scroll over x documents let say 200 by 200 docs.

Topic		Replies	Views
Data Transfer MySQL Elasticsearch	9	965	March 15, 2018
Pulling Data from DB(Mysql) to Elastic search for every minute Elasticsearch	3	13792	July 6, 2017
Integrate elastic search with MySQL Elasticsearch	3	484	January 16, 2019
Import Elastic Data into MySQL DB Elasticsearch	1	399	November 27, 2018
Sql server to Elasticsearch Elasticsearch	2	1185	March 9, 2017