How to connect Splunk using DB Connect and Oracle Wallet
We are using Splunk version 8.2.2, soon to upgrade to 9.x in a few months.
Splunk uses DB Connect version 3.5.1 to connect to Oracle over jdbc:oracle:thin client.
We use this to run queries which populate Splunk search results. Our current non-wallet connection string is
jdbc:oracle:thin:@SERVERNAME:1526:SIDNAME
In order to implement the Wallet (Oracle SEPS), we wish to change the username to "/" with no password, and the connect string to
jdbc:oracle:thin:@CONNECTION?TNS_ADMIN=\\UNC\Wallets
This causes an error:
IO Error: Invalid connection string format, a valid format is: "host:port:sid"
❓️ How can we set the connection properties in Splunk?