Looking up inventory from an external database
In this recipe, you will 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 https://docs.splunk.com/Documentation/DBX/latest/DeployDBX.
Getting ready
To step through this recipe, you will need a running Splunk Enterprise server, with Splunk DB Connect installed and the sample data loaded. The Splunk DB Connect installation and the sample data onboarding are covered in Chapter 1, Play Time - Getting Data In. You should also be familiar with navigating the Splunk user interface.
How to do it...
Follow the steps in this recipe to generate a local Splunk lookup using data from an external database using your Splunk DB Connect installation:
- Log in to your Splunk server.
- Select the
Operational...