JDBC connection to OTM datasets — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!