All Apps and Add-ons

Splunk DB Connect: Is it possible to connect to an Oracle database using JDBC connection string with LDAP and Service name?

amit97ee354
Explorer

Hello,

We are using OPODs and the internal Oracle structure is kind of a black box for anyone but DBAs. They have provided us the following connection string. In Splunk DB connect, the requirement is to have the host name and port number for Oracle, so instead, can we use following string to make a connection to the underlying Oracle DB server?

jdbc:oracle:thin:@ldap://oid:389/xxxx001,cn=OracleContext,dc=yyyy,dc=com

Thanks,
Amit

0 Karma

pmdba
Builder

You can use LDAP to lookup the connect string by installing an Oracle Client on your Splunk system and altering the connect string prototype in the DB Connect db_connection_types.conf file to use a JDBC-Thick (OCI) connection instead of JDBC-Thin, something like this:

 jdbcUrlFormat = jdbc:oracle:oci:@TNSALIAS

This would allow you to use TNSNAMES, say to define a connection string with SOURCE_ROUTE, enable strong network encryption, or to use LDAP resolution instead of tnsnames.ora.

0 Karma

amit97ee354
Explorer

Our DBA group is insisting to use the LDAP lookup using JDBC connection string instead of hardcoding the host name and the port number for ORACLE DB connection. Can anyone please comment on how to override the Splunk DB Connect App required "host name" and "host port" fields?

0 Karma

amit97ee354
Explorer

I talked to DBA and found the host name and the port number associated with the oracle database and succesfully made a connection. This is not a preferred way to connect to database as per the DBA however with Splunk's limitation, this is the only way to make a connection as this time.

0 Karma
Get Updates on the Splunk Community!

.conf25 Registration is OPEN!

Ready. Set. Splunk! Your favorite Splunk user event is back and better than ever. Get ready for more technical ...

Detecting Cross-Channel Fraud with Splunk

This article is the final installment in our three-part series exploring fraud detection techniques using ...

Splunk at Cisco Live 2025: Learning, Innovation, and a Little Bit of Mr. Brightside

Pack your bags (and maybe your dancing shoes)—Cisco Live is heading to San Diego, June 8–12, 2025, and Splunk ...