Database driver Oracle

Table of contents

• Connection settings
• Main
  • Configuration
    • Authentication
• Driver properties
• SSH Tunnel
  • Access
  • AI
• Connection details
  • Default connection view
• Advanced settings
  • Misc
  • Performance
  • Content
  • Data
• Initialization settings
• Supported objects
• Additional features
  • Oracle specific support
  • Tools and integrations

Connect to Oracle in CloudBeaver, configure the driver, and work with your database objects.

To get started, click Connection in the toolbar, select New Connection, then choose the driver that matches your database: use 'Oracle (Legacy)' for versions 8.x, 9.x, 10.x and 'Oracle' for version 11 and later

For information on the full workflow, see Creating a connection.

Connection settings

The connection dialog organizes settings into these entries:

Entry	Description
Main	Connection and authentication settings
Driver Properties	Oracle JDBC driver properties
SSH Tunnel	SSH tunnel settings
AI	AI assistant and MCP server settings
Connection details	Connection identification and project settings
Advanced settings	Oracle-specific connection options
Initialization settings	Connection initialization options

Main

Configuration

Choose how to configure the connection, then enter the required values.

Field	Description
Configuration	Choose Manual or URL
Host	Enter the Oracle server host; this field is required
Port	Enter the Oracle server port; the default is 1521
Database	Enter the database name

Authentication

Field	Description
Authentication model	Choose the type of authentication you want to use for the connection. For detailed guides on authentication types, please refer to the following articles: - Username/password - Oracle Wallet - Microsoft Entra ID - Kerberos
Save credentials	Saves credentials so all users with access to this connection can use them without entering them manually. Learn more

Note: Only administrators can change the driver properties and SSH tunnel settings.

Driver properties

Use the Driver Properties table to view and edit properties supplied through the Oracle driver metadata. The available properties and values depend on the driver and server configuration.

SSH Tunnel

CloudBeaver supports SSH connections to Oracle. For setup details, see SSH configuration

Access

Control which users and teams can use this connection. Grant access by selecting the checkbox next to a user or team name.

Switch to the Shared project to enable the Access tab.

For information on managing users and teams, see Users and Teams.

AI

Enable Transfer information to AI vendor to let the AI assistant use this connection's schema and data when generating SQL suggestions.

Note: This tab is only available if AI Integration is enabled in Settings -> Administration -> Server Configuration. For information on setting up AI integration, see AI assistant setup.

Connection details

Use these settings to identify and organize the connection:

Field	Description
Connection name	Enter a connection name; this field is required
Project	Select the project for the connection
Description	Enter a description
Connection type	Select the connection type Learn more

Default connection view

Note: This section is available only for shared connections. For details, see Connection details.

Option	Description
Simple / Advanced	Sets the default view for this connection in the Connections.
Show system objects	Shows system objects in the Connections.

For more details on connection view, see Simple and Advanced View

Advanced settings

Configure the Oracle-specific connection options shown in this section.

Misc

Option	Description
Service type	Select the Oracle service type
Role	Select the role for the connection
Set Username to OS_USER property	Set the user name as the OS_USER property

Performance

Option	Description
Use metadata queries optimizer	Optimize metadata queries
Use RULE hint for system catalog queries	Add the RULE hint to system catalog queries
Simple constraint reading query	Use a simple query to read constraints
Use UNION for table metadata reading	Use UNION when reading table metadata
Search metadata in synonyms	Include synonyms when searching metadata

Content

Option	Description
Show only connected user schema	Show only the connected user's schema
Hide empty schemas	Hide schemas without objects
Always show DBA objects	Always show DBA objects
Always use DBA_* views	Use DBA_* views where available when reading metadata, and fall back to ALL_* views
Use SYS schema prefix	Use SYS. in metadata queries; otherwise, use view names without an explicit schema

Data

Option	Description
Show DATE values specifically as DATE	Show Oracle DATE values as DATE instead of TIMESTAMP; requires date/time formatting to be enabled

Initialization settings

Use these settings when CloudBeaver initializes the connection:

Field	Description
Keep-alive interval (seconds)	Set the interval for keeping the connection open
Auto-commit mode	Set the default auto-commit mode
Read-only connection	Open the connection in read-only mode
Default catalog	Set the default catalog
Default schema	Set the default schema

Supported objects

CloudBeaver lets you view and manage a wide range of Oracle objects:

• Schemas
  • Tables
    • Columns
    • Constraints
    • Indexes
    • Foreign Keys
    • Dependencies
    • References
    • Partitions
    • Triggers
    • Rules
    • Policies
  • Views
  • Materialized Views
  • Indexes
  • Sequences
  • Queues
  • Types
  • Packages
  • Procedures
  • Functions
  • Synonyms
  • Schema Triggers
  • Table Triggers
  • Database Links
  • Java
  • Jobs
  • Scheduler
    • Jobs
    • Programs
  • Recycle bin
• Global metadata
  • Types
  • Public Synonyms
  • Public Database Links
• Storage
  • Tablespaces
    • Files
    • Objects
• Security
  • Users
  • Roles
  • Profiles

Note: Table elements like columns, indexes, and constraints appear in the Connections tree only if this option is enabled in Connections settings

Additional features

Oracle specific support

Category	Objects
Security	Users, roles
Programmability	Packages, standalone procedures, triggers
Storage and data organization	Tablespaces, sequences, materialized views
Database links and external access	Synonyms, database links
Database management	Jobs

Tools and integrations

Category	Feature
Data transfer	Data import
	Data export
Session management	Session manager
Data visualization	GIS guide
	ERD guide
Query management	Query manager
	Query history
SQL tools	Visual query builder
Administration	Audit logging