Documentation Index
Fetch the complete documentation index at: https://docs.summation.com/llms.txt
Use this file to discover all available pages before exploring further.
The Oracle connector supports standard Oracle databases and Oracle Autonomous Database (which requires TLS / TCPS and a wallet certificate). The form is split into three sections — Connection, Credentials, and Wallet SSO Certificate.
What you’ll need
- A reachable Oracle host and port (default
1521).
- A service name (not SID).
- A user with
SELECT on the schemas/tables you want exposed.
- For Autonomous Database, the client credentials wallet (
Wallet_<dbname>.zip) downloaded from the OCI console. See Download client credentials.
Connection
The Connection section has a toggle at the top — describe the connection either as host/port/service, or as a single EZConnect-style string. The two views stay in sync: filling host/port/service builds the equivalent string, and pasting a string parses it back into the discrete fields when possible.
EZConnect syntax is documented under Easy Connect Naming Method in the Oracle Net Services Administrator’s Guide.
Host & service name (default)
| Field | Required | Stored as | Notes |
|---|
| Protocol | Yes | Config | TCP or TCPS (TLS). Autonomous DB requires TCPS. |
| Host | Yes | Config | DNS name, e.g. db.example.com. |
| Port | Yes | Config | Default 1521. |
| Service Name | Yes | Config | Oracle service name, e.g. XEPDB1. See Specifying a Service Name. |
Connection string
| Field | Required | Stored as | Notes |
|---|
| Connection String | Yes | Config | EZConnect-style DSN, e.g. tcps://host:1522/service_name. |
Credentials
| Field | Required | Stored as | Notes |
|---|
| Username | Yes | Config | Oracle user. |
| Password | Yes | Secret | |
Wallet SSO Certificate (optional)
Required for Oracle Autonomous Database and any deployment that uses a wallet for TLS. You can either upload the wallet file or paste its contents. To find the wallet, see Download client credentials — the file you want is cwallet.sso from the unzipped wallet bundle.
| Input mode | Notes |
|---|
| Upload file | Click Upload cwallet.sso and select the wallet file from the unzipped Autonomous DB wallet bundle. |
| Paste contents | Paste the raw certificate. Useful when uploading from your machine isn’t possible. |
Adding datasets
Source references quote the schema and table names:
oracle:"MY_SCHEMA"."MY_TABLE"
Common problems
| Error or symptom | Likely cause |
|---|
ORA-12506 or other wallet errors | Autonomous DB requires cwallet.sso. Upload the wallet and set Protocol to TCPS. |
ORA-12541: TNS:no listener | Wrong host or port, or a firewall is blocking the connection. |
ORA-01017: invalid username/password | Wrong credentials. Oracle locks accounts after repeated failures — an admin may need to unlock. |