How to export data from jdbc to Amazon ES or Elastic "Found"

jprante / elasticsearch-jdbc

JDBC importer for Elasticsearch

Apache License 2.0

2.84k stars 710 forks source link

How to export data from jdbc to Amazon ES or Elastic "Found" #732

Open vikram-gupta opened 8 years ago

vikram-gupta commented 8 years ago

Hi Guys,

I would like to know if it is possible to export data from JDBC (mysql) to Elastic Search hosted as a service by Amazon (https://aws.amazon.com/elasticsearch-service/?nc2=h_l3_al) or by Elastic (https://www.elastic.co/found) using the current plugin.

If yes, please point me to useful resources. If not possible, please help me understand the main blockers.

I have used the plugin successfully with Amazon EC2 instances in past.

Thanks

jprante commented 8 years ago

AWS does not support Elasticsearch transport client. There is no way to work around that. Please wait for HTTP client in JDBC importer, this is totally different implementation.

antoineberthelin commented 8 years ago

Thanks Jörg, So, elasticsearch-jdbc will work with "HTTP client in JDBC importer" on aws elasticsearch and found ? When do you think "HTTP client in JDBC importer" will be available ? I will switch on aws instance if it is not available quickly.

Thanks,

Antoine

thomasdziedzic commented 8 years ago

just encountered this limitation in elasticsearch-jdbc, would really love amazon es support