JDBC importer 1.6.0.0 for Elasticsearch 1.6.0


(Jörg Prante) #1

Hi,

I released JDBC importer 1.6.0.0 (the project previously known as JDBC river or JDBC plugin) for Elasticsearch 1.6

For documentation, see the README at

I like to invite you to this version and try out the standalone JVM solution for importing data from JDBC into Elasticsearch.

Don't hesitate to give your feedback and bug reports if something does not work, also pull requests are most welcome.

Previous JDBC river version will only be supported for Elasticserach 1.4 and 1.5 and will not receive any new features from now on.

Best,

Jörg


(Vani Aravinda) #2

Hi @jprante,

I'm Using the JDBC importer for indexing data from SqlServer table with the below syntax. If I remove Where condition then it is working or else indexing is not working. Please let me know how can I include where condition in my query.

{
"type" : "jdbc",
"jdbc": {
"url":"jdbc:sqlserver://serverip;databaseName=dbname",
"user":"user",
"password":"password",
"sql":"SELECT id, name FROM employee where status = 'Y'",
"index" : "employee",
"type" : "employeetype"
}
}

Closing the query. Solved my issue.

Thanks,
Vani Aravinda


(system) #3