Oracle Integration
Connect an Oracle Database instance to Metaustral and automatically discover tables, views, and columns.
Prerequisites
- Oracle Database 12c Release 2 (12.2) or later, reachable from the Metaustral cloud — or use the On-Premise Agent for private networks.
- A database user with
CREATE SESSIONandSELECTonALL_TABLES,ALL_TAB_COLUMNS, andALL_VIEWS. - Port
1521(or your listener port) open to inbound connections from Metaustral. - Starter, Pro, or Enterprise plan.
How to connect
Open Integrations and click + New connection
Select Oracle as the type
Fill in the connection details
Enter a name, the host, port (default 1521), the Service Name (preferred) or SID, and your username and password. Optionally add a schema filter to limit discovery to specific schemas.
Save and import metadata
Go to Import → From a connection, select this connection, browse schemas and tables, and click Confirm import.
Connection fields
| Field | Required | Notes |
|---|---|---|
| Connection name | Yes | Display label in Metaustral. |
| Host | Yes | IP address or hostname of the Oracle listener. |
| Port | Yes | Default: 1521. |
| Service Name | Yes* | Preferred over SID for modern Oracle instances. Example: ORCLPDB1. |
| Username | Yes | Oracle user with SELECT on ALL_TABLES / ALL_TAB_COLUMNS. |
| Password | Yes | Stored encrypted with Fernet. |
| Schema filter | No | Comma-separated schemas to limit discovery. |
Tip: Create a dedicated read-only user:
GRANT CREATE SESSION TO metaustral_ro; GRANT SELECT ON ALL_TABLES TO metaustral_ro; GRANT SELECT ON ALL_TAB_COLUMNS TO metaustral_ro; GRANT SELECT ON ALL_VIEWS TO metaustral_ro;