All Apps and Add-ons

splunk DB connect

VijaySrrie
Builder

Hi,

How to connect the postgresql data to DB connect?
What are the details to be collected from the user?

Thanks,
Vijay Sri S

Labels (2)
Tags (1)
0 Karma
1 Solution

codebuilder
Influencer

Install Splunk DB Connect.
Download and install the PostgreSQL drivers (and update permissions/ownerships).
Restart Splunk.
Configure the DB connection settings.

It's a lot more straightforward / easier than it seems. It's a great tool and super easy to install/configure/use.

Good documentation links describing in more detail here:
https://docs.splunk.com/Documentation/DBX/3.3.1/DeployDBX/AboutSplunkDBConnect
https://docs.splunk.com/Documentation/DBX/3.3.1/DeployDBX/Installdatabasedrivers
https://docs.splunk.com/Documentation/DBX/3.3.1/DeployDBX/ConfigureDBConnectsettings

----
An upvote would be appreciated and Accept Solution if it helps!

View solution in original post

0 Karma

codebuilder
Influencer

Install Splunk DB Connect.
Download and install the PostgreSQL drivers (and update permissions/ownerships).
Restart Splunk.
Configure the DB connection settings.

It's a lot more straightforward / easier than it seems. It's a great tool and super easy to install/configure/use.

Good documentation links describing in more detail here:
https://docs.splunk.com/Documentation/DBX/3.3.1/DeployDBX/AboutSplunkDBConnect
https://docs.splunk.com/Documentation/DBX/3.3.1/DeployDBX/Installdatabasedrivers
https://docs.splunk.com/Documentation/DBX/3.3.1/DeployDBX/ConfigureDBConnectsettings

----
An upvote would be appreciated and Accept Solution if it helps!
0 Karma

VijaySrrie
Builder

Hi @codebuilder

I have DB connect app installed--> postgresql driver installed --> I got the hostname, userid, password, port, JDBC URL, SQL query from the customer. In my test instance I have created an identity and while creating a connection with the details provided by the user, I got below error.

Database connection is invalid

[Amazon]JDBC Null Pointer Exception.

0 Karma

VijaySrrie
Builder

It worked for different hostname

0 Karma
Get Updates on the Splunk Community!

Detecting Brute Force Account Takeover Fraud with Splunk

This article is the second in a three-part series exploring advanced fraud detection techniques using Splunk. ...

Buttercup Games: Further Dashboarding Techniques (Part 9)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...

Buttercup Games: Further Dashboarding Techniques (Part 8)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...