Getting Data In

Splunk DB Connect

harshavrath
Contributor

Hi my team Manager has installed Splunk DB Connect App,how can i figure if he has installed the Database drivers.

Any help is Appreciated,

Cheers.

0 Karma
1 Solution

sroback_splunk
Splunk Employee
Splunk Employee

Hi. You should be able to connect Splunk DB Connect to your Oracle db.

Here are the basic steps for setting up DB Connect:

  1. Install the DB Connect App. (you already have the app installed, so ignore this step)
  2. Install the JDBC drivers for Oracle. For instructions on downloading and installing the JDBC driver, see: http://docs.splunk.com/Documentation/DBX/latest/DeployDBX/Installdrivers
  3. Setup your connection to the database. See:http://docs.splunk.com/Documentation/DBX/latest/DeployDBX/Addadatabaseconnection

Once you have your database connection established, you can run queries against the database, and setup database inputs and outputs that let you add and index your database data in Splunk.

Hope this helps.

View solution in original post

sroback_splunk
Splunk Employee
Splunk Employee

Hi. You should be able to connect Splunk DB Connect to your Oracle db.

Here are the basic steps for setting up DB Connect:

  1. Install the DB Connect App. (you already have the app installed, so ignore this step)
  2. Install the JDBC drivers for Oracle. For instructions on downloading and installing the JDBC driver, see: http://docs.splunk.com/Documentation/DBX/latest/DeployDBX/Installdrivers
  3. Setup your connection to the database. See:http://docs.splunk.com/Documentation/DBX/latest/DeployDBX/Addadatabaseconnection

Once you have your database connection established, you can run queries against the database, and setup database inputs and outputs that let you add and index your database data in Splunk.

Hope this helps.

sroback_splunk
Splunk Employee
Splunk Employee

Hi. Which database are you connecting to? You might try looking in $SPLUNK_HOME/etc/apps/dbx/bin/lib directory to see if the driver has been installed. For more info on driver installation, see http://docs.splunk.com/Documentation/DBX/latest/DeployDBX/Installdrivers

harshavrath
Contributor

I checked the SPLUNK_HOME/etc/apps/dbx/bin/lib directory no driver is been installed.

0 Karma

harshavrath
Contributor

Splunk DB Connect is installed on my machine but I'm not sure if JRE is been Installed or the DB Drivers are installed.
Please guide me through the process of setting up the Splunk DBConnect,

0 Karma
Get Updates on the Splunk Community!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Get the T-shirt to Prove You Survived Splunk University Bootcamp

As if Splunk University, in Las Vegas, in-person, with three days of bootcamps and labs weren’t enough, now ...

Wondering How to Build Resiliency in the Cloud?

IT leaders are choosing Splunk Cloud as an ideal cloud transformation platform to drive business resilience,  ...