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, 3:02am 3

I think he wants to do that the other way.

Read from ES, write in MySQL.

We don't have yet a change API but for a one shot operation you can run a scroll query on elasticsearch to get all the docs. Then parse the JSON and write the SQL INSERT queries you need.

Topic		Replies	Views
Data Transfer MySQL Elasticsearch	9	938	March 15, 2018
Pulling Data from DB(Mysql) to Elastic search for every minute Elasticsearch	3	13776	July 6, 2017
Integrate elastic search with MySQL Elasticsearch	3	463	January 16, 2019
MySQL to Elasticsearch Logstash	26	8156	July 6, 2017
Import data from MySQL to Elasticsearch Logstash	2	2141	July 6, 2017

Sync Data from ES to MySQL

Related topics