Oracle

Required

Fields required for a valid configuration.

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(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.

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

Extracted Metadata

Table

Field	Type	Required	Description
database	string	Yes	Database or catalog name
table_name	string	Yes	Table name
table_type	string	Yes	Object type (TABLE/VIEW)
schema	string	No	Schema name
columns	object[]	No	Columns as {name, type} objects
row_count	integer	No	Estimated number of rows
object_type	string	No	Source object type
lineage	object	No	View lineage extraction settings

Examples

Quick discovery scan

Discover all tables and views in the Oracle service with lineage — works with any standard Oracle setup

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": "AUTOMATIC",
    "rows_per_page": 50
  }
}

Schedule

{
  "enabled": true,
  "preset": "weekday_business",
  "cron": "12 13 * * 1-5",
  "timezone": "UTC"
}

Targeted schema scan with latest sampling

Scan specific schema objects and prioritize latest rows — useful for monitoring active business schemas

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": "AUTOMATIC",
    "fallback_to_random": true,
    "rows_per_page": 50
  }
}

Schedule

{
  "enabled": true,
  "preset": "nightly",
  "cron": "4 0 * * *",
  "timezone": "UTC"
}