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!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...