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 ...
Get ElasticSearch Cookbook - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
