Using the JDBC river
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.
Getting ready
You need a working ElasticSearch.
How to do it...
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
Tip
The JDBC river plugin...
