JDBC importer for Elasticsearch 1.7.0

(Jörg Prante) #1


I have released a new version of JDBC importer which is compatible to Elasticsearch 1.7.0.

No functional changes in comparison to JDBC importer

As always, feedback/pull requests are more than welcome!



(Garrett Johnson) #2

Hi Jorg,

Sorry if this is the wrong place to reply:

I'm assuming this is the replacement for the jdbc river.

I'm running everything on Windows Server and would like the jdbc importer to run as a service. I can't run it as myself it has to be run as a very specific user.

Have you tried this, will it scale? Can I install on two or more machines and have it know which one is doing what?



(Jörg Prante) #3

Sorry, I do not use Windows and know nothing about Windows services, so my assistance is limited.

There are people who have prepared BAT scripts to start the JDBC importer, like this https://github.com/jprante/elasticsearch-jdbc/issues/447 and this https://github.com/jprante/elasticsearch-jdbc/issues/563 with cygwin. Maybe this helps.

Hopefully the community can step in and prepare more hints how to deal with Windows.

(Ritesh) #4


I was using your jdbc river till ES 1.5, now i have switched to logstash.
As i read somewhere it is deprecated.
Please let me know what is the major advantage over logstash jdbc input plugin.

So that if possible i can switch back to JDBC importer


(Jörg Prante) #5

River API has been deprecated, that is why I dropped river API and renamed the project to JDBC importer.

I don't know Logstash JDBC features, but it's great you can choose between JDBC importer and Logstash. It depends on your preferences and your requirements how to create Elasticsearch documents from tabular data.

(system) #6