In this recipe, you will install and leverage DB Connect to search an external database's product inventory table. You will then pull this data back into Splunk and turn it into a local lookup that harvests the data once per day. This product inventory table will be used in the next chapter.
Note
DB Connect has a dedicated Splunk manual that can be found at http://docs.splunk.com/Documentation/DBX/latest/DeployDBX.
To step through this recipe, you will need a running Splunk Enterprise server, with the sample data loaded from Chapter 1, Play Time – Getting Data In. You should be familiar with navigating the Splunk user interface.
Additionally, it is recommended that you have one of the following supported databases installed:
DB2
Informix
MemSQL
MS SQL
MySQL
Oracle
PostgreSQL
SAP SQL
Sybase
Teradata
DB Connect might work with other JDBC-compatible databases and data stores, but this is not guaranteed. DB Connect 2 has several prerequisites detailed...