Most often, you'll be using DB Connect to poll databases to fetch data to ingest in Splunk using an Input—let's set one up. You can look at the screenshot after the following steps to see how they were applied:
- Click Data Lab | Inputs | New Input. You'll arrive on the Set SQL Query page.
- Select a Connection (MySQLDevTest).
- Select a Catalog (performance).
- Select either a Schema or Table (webbytes, for this example).
- Splunk will create a generic SQL query (or you can edit/create one yourself in the SQL Editor)—click Execute SQL to run it. The rows and columns that are returned from the database are used to support and continue the configuration.
- Select an Input Type of either Batch or Rising. Batch input is a bulk download of all of ...
