Connect with SQLcl, Toad, DBeaver and other tools

Ready-to-use connection settings for SQLcl, Toad, DBeaver, JDBC and Python, so you can work with your APEX HostMate schema from any Oracle tool.

Your connection details

Every tool uses the same five values. You will find them in the client area under Services → your APEX service → Access details:

In the examples below, replace HOST and SCHEMA with your own values.

Note: Always use a service name, never a SID, and port 1555 rather than 1521.

SQLcl

sql SCHEMA@//HOST:1555/freepdb1

SQLcl asks for your password. To check the connection:

SELECT user FROM dual;

Toad for Oracle

1. Open a new connection and choose the Direct tab (no TNS file is needed).
2. Host: your Host. Port: 1555.
3. Select Service Name and enter freepdb1.
4. Enter your User and Password, then click Connect.

DBeaver

1. Click New Database Connection and choose Oracle.
2. Host: your Host. Port: 1555.
3. Database: freepdb1, with Service Name selected in the drop-down next to it.
4. Enter your Username and Password.
5. Click Test Connection. DBeaver may offer to download the Oracle driver the first time — accept it.

Connection strings for applications

Python with the oracledb package:

import oracledb

conn = oracledb.connect(user="SCHEMA", password="your-password",
                        dsn="HOST:1555/freepdb1")
print(conn.version)

Tip: Never store your password in source code. Read it from an environment variable or a secrets file outside your project.

Troubleshooting

The error messages are the same in every tool. See the troubleshooting table in How to connect to your schema with SQL Developer.