Natural Language Interaction with Oracle Select AI

Back Next

Configuring and publishing the OracleADBConnection connection

Configure the JDBC driver, connection URL, and user credentials to log in to the database and publish the OracleADBConnection connection.

Open the

OracleADBConnection

connection.

From the

Type

list, select

OracleADBConnector

from the recipe assets folder.

From the

Runtime Environment

list, select the Secure Agent.

In the

Connection Properties

section, enter values for the following properties:

Property	Description
JDBC Driver	The fully qualified Java class name of the JDBC driver. Specify the following driver class name: oracle.jdbc.OracleDriver
JDBC Connection URL	The connection URL to connect to an external database. Specify the following connection URL: jdbc:oracle:thin:@(description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1521)(host=<hosturl>))(connect_data=(service_name=<ServiceName>))(security=(ssl_server_dn_match=yes))) Add the host and service name in the URL.
User Name	The user name to connect to the database.
Password	The password to connect to the database.