Oracle Spatial Relational Reader/Writer

FME can read and write geometric and attribute data stored using Oracle Spatial.

This module communicates directly with Oracle Spatial for maximum throughput. FME supports both the relational and object-relational models of Oracle Spatial: the relational model is discussed here, and the object-relational model is discussed in Oracle Spatial Object Reader/Writer.

Note If only attributes are to be read or written, use the Oracle Non-Spatial Reader/Writer.

This chapter assumes familiarity with Oracle Spatial and its indexing mechanisms.

Tip The FeatureReader transformer performs queries against any FME-supported format.

Oracle Spatial Relational Product and System Requirements

Compatibility Oracle libraries are not yet available for the macOS M1 ARM architecture (Apple Silicon). Please use an alternative platform such as Intel macOS.

Format	FME Platform	Operating System
Reader	Yes	Yes	Yes	Yes	- Linux Intel: Yes - Linux ARM: Yes	- macOS Intel: Yes - macOS ARM: No
Writer	Yes	Yes	Yes	Yes	- Linux Intel: Yes - Linux ARM: Yes	- macOS Intel: Yes - macOS ARM: No

Format

FME Platform

Operating System

Reader/Writer

FME Form

FME Flow

FME Flow Hosted

Windows 64-bit

Linux

Mac

Reader

Yes

- Linux Intel: Yes

- Linux ARM: Yes

- macOS Intel: Yes

- macOS ARM: No

Writer

Yes

- Linux Intel: Yes

- Linux ARM: Yes

- macOS Intel: Yes

- macOS ARM: No

Reader Overview

This reader reads relational tables from Oracle Spatial Relational databases.

Writer Overview

The Oracle Spatial Relational writer module stores both geometry and attributes into an Oracle Spatial database. Only uppercase table names are supported.