Connecting to Oracle
Note: PopSQL supports Oracle only as a direct connection.
- Open the connections page in preferences, see managing connections for more information.
- Click the
Add new Connection
button at the top of the connections page.
- Select
Oracle
from the list.
- Give a
Connection name
for your own internal reference. - For
Hostname
, enter the hostname of your database server. - For
Port
, use the default1521
, or enter the port used by your server. - For
Database
, enter the name of your database. - For
Username
andPassword
, enter the username and password for Oracle. These are optional. - For
Role
, select the role you normally use to connect to your Oracle server (e.g.SYSDBA
,SYSOPER
, etc). This is optional. - Share the connection with your team.
- Configure
SSH
andSSL
settings. These are optional. - Hit
Connect
and you're all set!
Happy querying! 🍭
Updated about 1 year ago