splunk DB connect

[VijaySrrie]

Hi,

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

Thanks,
Vijay Sri S

[codebuilder · Accepted solution]

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

[VijaySrrie]

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.

[VijaySrrie]

It worked for different hostname