JDBC connection to OTM datasets

Summary:

Hello,

We are looking to access OTM data from within a Java application to directly export datasets. To achieve this, we need to set up a JDBC connection using the oracle.jdbc.driver.OracleDriver class.

Additionally, the connection string must not use TNS but instead be based on host/port/SID format.

Would anyone here with experience in this area be able to advise how we can validate or obtain the correct host and SID values for the OTM database?

Any guidance would be greatly appreciated.

Thank you!

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):