Oracle
Schema-driven source documentation.
ORACLE47 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.
Quick discovery scan
Discover all tables and views in the Oracle service with lineage — works with any standard Oracle setup
Schedule
{
"enabled": true,
"preset": "weekday_business",
"cron": "12 13 * * 1-5",
"timezone": "UTC"
}Config Payload
{
"type": "ORACLE",
"required": {
"host": "your-host",
"port": 1521,
"service_name": "your-service-name"
},
"masked": {
"username": "your-username",
"password": "your-password"
},
"optional": {
"scope": {
"include_tables": true,
"include_views": true,
"include_view_lineage": true,
"include_view_column_lineage": true
}
},
"sampling": {
"strategy": "RANDOM",
"rows_per_page": 50
}
}Targeted schema scan with latest sampling
Scan specific schema objects and prioritize latest rows — useful for monitoring active business schemas
Schedule
{
"enabled": true,
"preset": "nightly",
"cron": "4 0 * * *",
"timezone": "UTC"
}Config Payload
{
"type": "ORACLE",
"required": {
"host": "your-host",
"port": 1521,
"service_name": "your-service-name"
},
"masked": {
"username": "your-username",
"password": "your-password"
},
"optional": {
"scope": {
"include_tables": true,
"include_views": true,
"include_schemas": [
"YOUR_SCHEMA"
]
}
},
"sampling": {
"strategy": "LATEST",
"fallback_to_random": true,
"rows_per_page": 50
}
}