Connect Oracle to the Knowledge Base

With the Oracle connector, you can connect your Oracle databases directly to the Knowledge Base. Once connected, EKB indexes the tables you specify, making your database content searchable and accessible to your AI agents for grounded, data-driven responses.

Connecting to Oracle

1. Open Project Settings

   In your EKB project, navigate to Settings in the sidebar.

2. Go to Connections

   Select the Connections tab and find the Oracle tile under Databases.

3. Open the Oracle popup

   Click the Oracle tile. A popup appears with the option to connect to Oracle databases. Click + Add Connection.

4. Fill in the connection form

   Enter the following details:

   Server

   Field	Required	Description
   Connection Name	Yes	A display name for this connection (e.g. My Oracle Connection).
   Host	Yes	The hostname or IP address of your Oracle server (e.g. localhost).
   Port	Yes	The port your Oracle server is listening on. Default is 1521.
   Database	Yes*	The Oracle database name (e.g. ORCL). Provide either this or Service Name, not both.
   Service Name	Yes*	The Oracle service name (e.g. ORCL). Provide either this or Database, not both.

   Authentication

   Field	Required	Description
   Username	Yes	The Oracle user (e.g. system).
   Password	Yes	The password for the Oracle user.

   Database

   Field	Required	Description
   Schema	Yes	The schema to use (e.g. SYSTEM).
   Tables	Yes	The tables to index. Enter each table name separated by a comma.

5. Save the connection

   Click Save. EKB will authenticate using the details provided. If successful, the Oracle tile on the Connections page will display a green dot and a count of your active Oracle connections.

✓You're now ready to use your Oracle data in the Knowledge Base!