Hi,
How to connect the postgresql data to DB connect?
What are the details to be collected from the user?
Thanks,
Vijay Sri S
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
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
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.
It worked for different hostname