What you’ll need
- A reachable Oracle host and port (default
1521). - A service name (not SID).
- A user with
SELECTon 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 iscwallet.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: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. |