Back

Connectors

Oracle: spatial geometry columns now replicated as WKT

Oracle SDO_GEOMETRY columns are replicated as WKT strings, and timestamps with out-of-range years are set to null instead of causing errors.

Oracle SDO_GEOMETRY columns (spatial/GIS data) were previously unsupported, blocking pipelines on any table that used them. Separately, DATE/TIMESTAMP values with years outside the valid range [0, 9999] would crash the pipeline entirely.

Oracle SDO_GEOMETRY columns are now replicated as WKT (Well-Known Text) strings. Out-of-range timestamps are filtered to null instead of causing errors.

Why this matters

  • Unblocks Oracle pipelines on tables with spatial/GIS columns
  • Prevents pipeline failures from legacy timestamps with out-of-range years