The JDBC URL to connect to the database when Driver is oracle. For example, to connect with a database hosted in multiple Oracle nodes:

(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=yes)(FAILOVER=on)(ADDRESS=(PROTOCOL=TCP)(HOST=host1.domain.com)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=host2.domain.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ServiceName)))

Do not include the following prefix in the parameter value:

jdbc:oracle:thin:@

Mandatory: database connection settings support the following combinations.

Driver

Database name

Host

​Port

JDBC URL

​oracle

(tick)​

(tick)​

(tick)

(error)

oracle

(error)

(error)

(error)

(tick)

postgres

(tick)

(tick)

(tick)

(error)

sqlserver

(tick)

(tick)

(tick)

(error)

Remove any unnecessary parameters.

JSON data type: String.