Build a simple dashboard with Splunk to visualise your DB data

A Simple Splunk Dashboard we aim to build
  • Setting up a database connection using the Splunk DB Connect
  • Turn your DB queries into a simple metrics dashboard

Install Splunk

Download Splunk Free and follow the setup instructions. When finished, navigate to http://localhost:8000 or http://localhost:8001.

Set Up DB Connection — Install Splunk DB Connect on a Single Server Deployment

Splunk DB Connect comes as a Splunk app to easily help you integrate structured data sources with Splunk’s real-time data collection.

  • Java Runtime Environment (JRE) version 8 from Oracle. (DB Connect uses a JDBC to connect to the DB.)
  • A supported relational database running locally or elsewhere on your network. (for this tutorial, I will be using a MySQL instance. )
  • Install database drivers and follow the instructions for your own DB and OS type.
DB Connect uses an RPC server to communicate with the Java subsystem and a JDBC driver to enable Splunk to communicate with your DB (image source)
  • Use the search box to find db connect.
  • Click the Install button next to Splunk DB Connect.
  • Restart Splunk.
Welcome page once DB Connect is installed
Set Up General Settings for DB Connect
Installed DB Drivers
New Identity is created

Creating a Dashboard

  • Create a new app. Navigate to Home page and in the left tab called Apps click on the Settings icon.
The AdminDashboard application we have just created
Create a new Dashboard for the AdminDashboard application
Dashboard that shows the number of active users

former @Salesforce > ETL-ing my experience and learnings into short stories

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store