Oracle Database

Connect an Oracle Database to Lakehousecat using a connection URI.

Connection Fields

Field	Required	Description
Connection URI	Yes	Full connection string including credentials, host, port, and service name
Use SSH	No	Enable if the database is behind an SSH bastion host. See SSH Tunneling.

URI Format

oracle+oracledb://user:password@host:1521/?service_name=myservice

The service_name query parameter is the recommended way to specify the target database (e.g. FREEPDB1, ORCL).

Prerequisites

• Admin or Builder role in Lakehousecat
• An Oracle user with SELECT privilege on the relevant schemas and tables
• Network connectivity from the Lakehousecat backend to the database (direct or via SSH)

Notes

• SSH Tunnel: supported
• Use a read-only Oracle user to follow the principle of least privilege

Next Steps

After creating the datasource, go to the Operations tab to trigger semantic extraction.