Oracle
Schema-driven source documentation.
ORACLE40 fields2 examples
Commonly Asked Questions
Assistant knowledge mapped to this source type from
assistant_knowledge.json.Required
Fields required for a valid configuration payload under `config.required`.
| Path | Type | Required | Description | Default | Constraints |
|---|---|---|---|---|---|
| required | object | Yes | — | — | no extra properties |
| required.host | string | Yes | Oracle host endpoint | localhost | — |
| required.port | integer | Yes | Oracle TCP port | 1521 | min 1, max 65535 |
| required.service_name | string | Yes | Oracle service name (for example, TEST_PDB) | — | — |
Masked
Sensitive fields under `config.masked` (secrets/credentials).
| Path | Type | Required | Description | Default | Constraints |
|---|---|---|---|---|---|
| masked | object | Yes | — | — | no extra properties |
| masked.password | string | Yes | Oracle login password | — | — |
| masked.username | string | Yes | Oracle login username | — | — |
Optional
Optional configuration fields under `config.optional`.
| Path | Type | Required | Description | Default | Constraints |
|---|---|---|---|---|---|
| optional | object | No | — | — | no extra properties |
| optional.connection | object | No | Connection tuning for Oracle. | — | no extra properties |
| optional.connection.connect_timeout_seconds | integer | No | Connection timeout in seconds | 10 | min 1, max 120 |
| optional.scope | object | No | Schema, object, and lineage extraction scope. | — | no extra properties |
| optional.scope.exclude_schemas | array | No | Schema denylist (exact schema names) | ["SYS","SYSTEM","DBSNMP","WMSYS","CTXSYS","XDB","MDSYS","ORDSYS","OUTLN","ORDDATA"] | — |
| optional.scope.exclude_schemas[] | string | No | — | — | — |
| optional.scope.include_objects | array | No | Optional object allowlist. Accepted forms: schema.object or service.schema.object | — | — |
| optional.scope.include_objects[] | string | No | — | — | — |
| optional.scope.include_schemas | array | No | Optional schema allowlist (exact schema names) | — | — |
| optional.scope.include_schemas[] | string | No | — | — | — |
| optional.scope.include_tables | boolean | No | Include table assets in extraction | true | — |
| optional.scope.include_view_column_lineage | boolean | No | Enable view column lineage collection from Oracle dependency metadata | true | — |
| optional.scope.include_view_lineage | boolean | No | Extract coarse lineage links from views to referenced tables/views | true | — |
| optional.scope.include_views | boolean | No | Include view assets in extraction | true | — |
| optional.scope.table_limit | integer | No | Optional cap on number of table/view assets extracted | — | min 1 |
Examples
Reference payloads generated from shared source examples JSON.
Scan Oracle service with table and view lineage
Extract Oracle tables and views for one service name and include view lineage links
Schedule
{
"enabled": true,
"preset": "weekday_business",
"cron": "12 13 * * 1-5",
"timezone": "UTC"
}Config Payload
{
"type": "ORACLE",
"required": {
"host": "some-test-company.example.com",
"port": 1523,
"service_name": "TEST_PDB"
},
"masked": {
"username": "test",
"password": "test"
},
"optional": {
"scope": {
"include_tables": true,
"include_views": true,
"include_view_lineage": true,
"include_view_column_lineage": true
}
},
"sampling": {
"strategy": "RANDOM",
"limit": 25,
"max_columns": 20,
"max_cell_chars": 512
}
}Scan selected Oracle objects with latest sampling
Target specific Oracle schema objects and prioritize latest rows for detector payloads
Schedule
{
"enabled": true,
"preset": "nightly",
"cron": "4 0 * * *",
"timezone": "UTC"
}Config Payload
{
"type": "ORACLE",
"required": {
"host": "some-test-company.example.com",
"port": 1523,
"service_name": "TEST_PDB"
},
"masked": {
"username": "test",
"password": "test"
},
"optional": {
"scope": {
"include_tables": true,
"include_views": false,
"include_objects": [
"HR.EMPLOYEES",
"HR.DEPARTMENTS"
],
"table_limit": 100
}
},
"sampling": {
"strategy": "LATEST",
"limit": 20,
"order_by_column": "LAST_UPDATE_DATE",
"fallback_to_random": true
}
}