Connect Oracle Database to SaturnSQL

Last updated August 24, 2026 · By the SaturnSQL team

What you need

To connect an Oracle database you need the host, the port (1521 by default), the service name, and a database user with permission to read the tables you care about.

Service name, not SID

SaturnSQL connects by service name. If you only have a SID, ask your DBA for the service name, or run lsnrctl status on the database host and use the value under Service rather than Instance.

SELECT value FROM v$parameter WHERE name = 'service_names'

A read-only user

Create a dedicated login for SaturnSQL rather than reusing an existing account:

CREATE USER saturnsql IDENTIFIED BY "<a-strong-password>";
GRANT CREATE SESSION TO saturnsql;
GRANT SELECT ANY TABLE TO saturnsql;

SELECT ANY TABLE can be replaced by per-table grants if you would rather scope access more narrowly. See the read-only database user guide for the general approach.

Letting SaturnSQL in

SaturnSQL always connects from 100.49.19.161. See the static IP address guide for the firewall or security list rule to add, and the SSH tunnel guide for databases with no public endpoint.

TLS

Turning on Enable SSL makes SaturnSQL speak TCPS. A private or self-signed CA goes in the Advanced section as a PEM certificate. See the SSL certificates guide for how to add one.

What is not supported yet

SaturnSQL cannot follow a listener redirect, so RAC/SCAN addresses and shared-server configurations are not supported yet. A single instance with a dedicated server, which includes RDS for Oracle and Autonomous Database, connects normally. Wallet-only Autonomous connections (mTLS) are not supported; use the TLS endpoint instead.