Oracle
Connect Oracle Database with the Oracle database type. Amazon RDS for Oracle connects the same way.
Connect a database
Add the database as in Connect a database, with these values:
| Field | Value |
|---|---|
| Database type | Oracle |
| Port | 1521, Oracle's listener default. |
| Database name | The service name, for example ORCLPDB1, or FREEPDB1 on Oracle Database Free. To connect by SID instead, prefix it with a colon, as in :ORCL. |
For the credential, create a read-only user. To keep QueryDesk's queries off your primary, connect a read replica.
Tables
The schema sync reads the tables that the default credential's user owns. A read-only user owns none, so with it as the default credential the table list is empty, and queries name each table with its owner, as in SELECT * FROM app.orders.
AI read-only
With Read only set, an AI query's statements share one read-only transaction that is always rolled back, and Oracle refuses DML from a function called in a query. The parser also refuses utl_http and the other network packages, and httpuritype, which fetch a URL. See AI governance.