Learning Elastic Stack 6.0

JDBC

This plugin is used to import data from a database to Logstash. Each row in the results set would become an event and each column would get converted into fields in the event. Using this plugin, one can import all the data at once by running a query, or one can periodically schedule the import using a cron syntax (using the schedule parameter/setting). When using this plugin the user would need to specify the path of the JDBC drivers appropriate to the database, and the driver library can be specified using the jdbc_driver_library parameter.

The SQL query can be specified using the statement parameter or can be stored in a file; the path of the file can be specified using the statement_filepath parameter. One can use either statement ...