Generally application data is stored in a DBMS of some kind (Oracle, MySQL, PostgreSql, Microsoft SQL Server, SQLite, and so on), to power up traditional application with advanced search capabilities of ElasticSearch and Lucene. All this data must be imported in ElasticSearch. The JDBC river by Jörg Prante allows to connect to these DBMSs, executes some queries and indexes the results.
For using the JDBC river, we need to perform the following steps:
Firstly, we need to install the JDBC river plugin, which is available on GitHub (https://github.com/jprante/elasticsearch-river-jdbc). We can install the river plugin in the following way:
bin/plugin -url http://bit.ly/145e9Ly -install river-jdbc
The result should be as follows:
-> Installing river-jdbc... Trying http://bit.ly/145e9Ly... Downloading … .....DONE Installed river-jdbc into …/elasticsearch/plugins/river-jdbc