JDBC input plugin is there to fetch data from any database with the Logstash JDBC interface. It has a built-in scheduler that can be set to fetch the data at regular intervals without affecting the application that is connected with the database. We can also run a one-time query to fetch the data from a database.
Each column of a record converts into field, and each row converts as a resultset that can be inserted as a document in Elasticsearch. JDBC driver library is not shipped with this plugin, and we need to explicitly pass the path of the driver using the jdbc_driver_library configuration of the plugin. We are going to discuss many features of JDBC input plugin here.
Mastering Kibana 6.x
Mastering Kibana 6.x
Overview of this book
Kibana is one of the popular tools among data enthusiasts for slicing and dicing large datasets and uncovering Business Intelligence (BI) with the help of its rich and powerful visualizations.
To begin with, Mastering Kibana 6.x quickly introduces you to the features of Kibana 6.x, before teaching you how to create smart dashboards in no time. You will explore metric analytics and graph exploration, followed by understanding how to quickly customize Kibana dashboards. In addition to this, you will learn advanced analytics such as maps, hits, and list analytics. All this will help you enhance your skills in running and comparing multiple queries and filters, influencing your data visualization skills at scale.
With Kibana’s Timelion feature, you can analyze time series data with histograms and stats analytics. By the end of this book, you will have created a speedy machine learning job using X-Pack capabilities.
Related Content you might be interested in
Current Title:
Mastering Kibana 6.x
Table of Contents (21 chapters)
Title Page
Copyright and Credits
Packt Upsell
Contributors
Preface
Free Chapter
Revising the ELK Stack
Setting Up and Customizing the Kibana Dashboard
Exploring Your Data
Visualizing the Data
Dashboarding to Showcase Key Performance Indicators
Handling Time Series Data with Timelion
Interact with Your Data Using Dev Tools
Tweaking Your Configuration with Kibana Management
Understanding X-Pack Features
Machine Learning with Kibana
Create Super Cool Dashboard from a Web Application
Different Use Cases of Kibana
Creating Monitoring Dashboards Using Beats
Best Practices
Other Books You May Enjoy
Index
Customer Reviews