...
Configuration
Property | Macro Enabled? | Version Introduced | Description |
---|---|---|---|
Name | No | Required. Name of the connection. Connection names must be unique in a namespace. Connection names can only include letters, numbers, underscores, and hyphens. | |
Description | No | Optional. Description of the connection. | |
JDBC Driver Name | NoYes | Required. Select the JDBC driver name to use. | |
Host | Yes | Required. Host name or IP address of the database server to connect to. Default is localhost. | |
Port | Yes | Required. Port number of the database server to connect to. Default is 1521. | |
Connection Type | No | Required. Whether to use an SID or , Service Name, or TNS Connect Descriptor when connecting to the database. | |
SID/Service Name/TNS Connect Descriptor | Yes | Required. Oracle connection point (Database name, Service name, or a TNS Connect Descriptor). When using TNS, place the full TNS Connect Descriptor in the text field. For example: | |
Username | Yes | User identity for connecting to the specified database. Required for databases that need authentication. Optional for databases that do not require authentication. | |
Password | Yes | Password to use to connect to the specified database. | |
Role | No | Login role of the user when connecting to the database. Default is Normal. | |
Transaction Isolation Level | Yes | 6.7.0 | Optional. The transaction isolation level of the databse connection
|
Connection Arguments | Yes | Optional. A list of arbitrary string tag/value pairs as connection arguments. These arguments will be passed to the JDBC driver, as connection arguments, for JDBC drivers that may need additional configurations. This is a semicolon-separated list of key-value pairs, where each pair is separated by a equals ‘=’ and specifies the key and value for the argument. For example, ‘key1=value1;key2=value’ specifies that the connection will be given arguments ‘key1’ mapped to ‘value1’ and the argument ‘key2’ mapped to ‘value2’. |
...