Oracle

Connect to Oracle so you can browse schemas, build queries, and (where supported) render spatial maps.

Goal

Create a working Oracle connection in Connection Manager.

Prerequisites

• Host name, port, database name, and credentials
• Firewall access from your workstation

Steps

1. Open Data → Connection Manager….
2. Add a connection and choose Oracle.
3. Enter connection details (host, port, database/service, user, password, and provider-specific options).
4. Click Test (or equivalent) to verify connectivity.
5. Save the connection.
6. On the Data tab, select the connection and open Query Builder to start a query.

[ Screenshot: Oracle connection settings ]

Notes

Note

Oracle connections support Service Name or SID style options in the connection form.

Tip

Confirm with your DBA whether you should connect by service name or SID.

Result

The connection appears in Connection Manager and can be selected for queries and compatible map sources.

See Also

• Data Sources overview
• Query Builder
• Parameters
• Oracle Spatial
• Oracle Spatial maps