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!

Archived Metrics Now Available for APAC and EMEA realms

We’re excited to announce the launch of Archived Metrics in Splunk Infrastructure Monitoring for our customers ...

Detecting Remote Code Executions With the Splunk Threat Research Team

WATCH NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If exploited, ...

Enter the Dashboard Challenge and Watch the .conf24 Global Broadcast!

The Splunk Community Dashboard Challenge is still happening, and it's not too late to enter for the week of ...