Oracle Database
How to connect Oracle Database to Squadbase and what you need
The Oracle Database connector connects to Oracle Database with a JDBC URL. Once it's connected, AI can run SQL in a project's chat to analyze your data.
Required Information
| Item | Description |
|---|---|
| JDBC URL | The JDBC connection URL for Oracle Database. It accepts jdbc:oracle:thin:@host:1521/service, the SID form jdbc:oracle:thin:@host:1521:sid, jdbc:oracle:thin:user/password@host:1521/service, and oracle://user:password@host:1521/service. Only the Thin driver is supported. |
| Username (Optional) | Your Oracle username. Enter it if it's not included in the JDBC URL. |
| Password (Optional) | Your Oracle password. Enter it if it's not included in the JDBC URL. |
| SSH host (Optional) | Hostname of the bastion host, if you connect through one. Leave it empty to connect directly to the database. |
| SSH port (Optional) | SSH port of the bastion host. Uses 22 if left empty. |
| SSH username (Optional) | Username for SSH authentication. Required when an SSH host is set. |
| SSH private key (Optional) | Private key (PEM) for SSH authentication. Select a file or paste its contents. Required when an SSH host is set. |
| SSH private key passphrase (Optional) | Passphrase for the private key, if it's encrypted. |
If your database limits access by IP address, click Show IP addresses on the form to see Squadbase's IP addresses and add them to its allowlist.