Using the JDBC river
Generally, application data is stored in a DBMS of some kind (Oracle, MySQL, PostgreSql, a Microsoft SQL server, and SQLite, among others). To power up a traditional application with the advanced search capabilities of ElasticSearch and Lucene, all this data must be imported to ElasticSearch. The JDBC river by Jörg Prante allows you to connect to the DBMS, executing queries and indexing the results.
This plugin can work both as a standard river or as a standalone feeder, so the ingestion part can be executed independently of ElasticSearch.
Getting ready
You will need a working ElasticSearch cluster.
How to do it...
In order to use the JDBC river, perform the following steps:
- First, you need to install the JDBC river plugin, which is available on GitHub (https://github.com/jprante/elasticsearch-river-jdbc). You can install the river plugin using the following code:
bin/plugin -url http://xbib.org/repository/org/xbib/elasticsearch/plugin/elasticsearch-river-jdbc/1.3.4.4...
