Looking up inventory from an external database

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.

Getting ready

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

• MS SQL

• MySQL

• Oracle

• Sybase

• HyperSQL

• PostgreSQL

• H2

• SQLite

• Adaptive Server Enterprise v15.7 Developer Edition

DB Connect might work with other databases and data stores using the generic ODBC driver provided with the application...