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.Documentation Index
Fetch the complete documentation index at: https://ai-kb.automationanywhere.com/llms.txt
Use this file to discover all available pages before exploring further.
Connecting to Oracle
Open the Oracle popup
Click the Oracle tile. A popup appears with the option to connect to Oracle databases. Click + Add Connection.
Fill in the connection form
Enter the following details:Server
Authentication
Database
| 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. |
| Field | Required | Description |
|---|---|---|
| Username | Yes | The Oracle user (e.g. system). |
| Password | Yes | The password for the Oracle user. |
| 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. |
You’re now ready to use your Oracle data in the Knowledge Base!