Strategies

The JDBC river plugin can be configured for different methods of data transport. Such methods of data transports are called a 'strategy'.

By default, the JDBC River implements a simple strategy.

Simple strategy

This strategy contains the following steps of processing:

1. fetch data from the JDBC connection
2. build structured objects and move them to Elasticsearch for indexing or deleting

In the sql parameter of the river, a series of SQL statements can be defined which are executed at each river cycle to fetch the data.