Connect Using JDBC

You can use Java Database Connectivity (JDBC) to connect your data.

Note:

Reach out to your database administrator for JDBC connection string details.

  1. Ensure that you have access to Oracle SQL Developer and that Oracle JDBC drivers are installed.
  2. In Oracle SQL Developer, select New then select Connection.
  3. Select Oracle as the Database Type.
  4. Enter your Autonomous Data Warehouse username and password.
  5. Select Custom JDBC connection and paste the connection string: jdbc:oracle:thin:@(DESCRIPTION=(RETRY_COUNT=20)(RETRY_DELAY=3)(ADDRESS=(PROTOCOL=tcps)(HOST=adb.<region>.oraclecloud.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=<service_name>.adb.oraclecloud.com))(SECURITY=(SSL_SERVER_DN_MATCH=yes)))

Parent topic: Explore Oracle Health Real-World Data