Documentation
Connections
Oracle

Oracle

Supported databases

This connector uses the Oracle JDBC Thin Driver (ojdbc8) and supports:

Supported Oracle versions

  • Oracle Database 12c Release 2 (12.2) and newer
  • Oracle Database 18c
  • Oracle Database 19c (Long Term Support)
  • Oracle Database 21c
  • Oracle Database 23c

Supported Oracle editions

  • Oracle Enterprise Edition
  • Oracle Standard Edition
  • Oracle Standard Edition 2
  • Oracle Express Edition (XE)

Supported deployment types

  • On-premise Oracle Database
  • Oracle Cloud Infrastructure (OCI)
  • Oracle Autonomous Database (ATP / ADW)
  • Oracle databases running in virtual machines or containers

Required connection parameters

Users must provide:

  • Host – database server hostname or IP address
  • Port – default: 1521
  • Service name (recommended) or SID
  • Username
  • Password

Note: Service name is strongly recommended for Oracle 12c and newer.

Optional supported parameters

  • SSL / TCPS connections
  • Connection timeout
  • Load balancing
  • Failover (Oracle RAC)

Supported connection features

  • Oracle RAC (using service name–based connections)
  • Pluggable Databases (PDBs)
  • Container Databases (CDBs)
  • SYS and non-SYS users (subject to permissions)

Not supported

  • Oracle Database versions older than 12c
  • TNS alias resolution using tnsnames.ora
  • OS authentication (external users)
  • Kerberos authentication
  • Wallet-only authentication without username/password
  • Bequeath or shared memory connections

Authentication limitations

The connector supports username/password authentication only.

The following authentication methods are not supported:

  • Oracle Wallet–only authentication
  • OCI IAM token authentication
  • Kerberos / Active Directory authentication

If such mechanisms are required, credentials must be resolved outside the application and provided as a username and password.

Notes

  • This application uses thin JDBC connections over TCP/IP only.
  • Easy Connect and Easy Connect Plus formats are supported internally.
  • Firewall rules must allow access to the configured host and port.## Supported databases This connector uses the Oracle JDBC Thin Driver (ojdbc8) and supports:

Supported Oracle versions

  • Oracle Database 12c Release 2 (12.2)
  • Oracle Database 18c
  • Oracle Database 19c (Long Term Support)
  • Oracle Database 21c
  • Oracle Database 23c

Supported Oracle editions

  • Oracle Enterprise Edition
  • Oracle Standard Edition
  • Oracle Standard Edition 2
  • Oracle Express Edition (XE)

Supported deployment types

  • On-premise Oracle Database
  • Oracle Cloud Infrastructure (OCI)
  • Oracle Autonomous Database (ATP / ADW)
  • Oracle databases running in virtual machines or containers

Required connection parameters

You must provide the following:

  • Host
  • Port – default: 1521
  • Service name (recommended) or SID
  • Username
  • Password

The JDBC connection string is generated automatically.

Supported connection features

  • Service name–based connections
  • Pluggable Databases (PDB)
  • Container Databases (CDB)
  • Oracle RAC (using service-based connections)

Optional parameters

  • SSL / TCPS
  • Connection timeout
  • Load balancing
  • Failover configuration

Not supported

  • Oracle Database versions older than 12c
  • TNS aliases (tnsnames.ora)
  • OS authentication
  • Kerberos authentication
  • Wallet-only authentication without username/password
  • Bequeath or shared memory connections
  • Custom JDBC URLs

Notes

  • Service name is strongly recommended for Oracle 12c and newer.
  • Only TCP/IP (thin driver) connections are supported.
  • Firewall access to the configured host and port must be allowed.
MariaDBLocal connection (Agent)