Oracle Autonomous Spatial Object Reader/Writer

Autonomous Database includes Oracle Spatial. Oracle Autonomous Database technology was designed to deliver automated patching, upgrades, and maintenance.

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

Using FME with Oracle Autonomous Formats

Oracle Format	Data Type	Characteristics
Oracle Autonomous Spatial	read and write geometric and attribute data	Communicates directly with Oracle Spatial for maximum throughput. This object-relational model is often referred to as simply the object model, to prevent confusion with the pure relational model.
Oracle Autonomous Non-Spatial	read and write attributes only	Communicates directly with Oracle for maximum throughput. Relational model reads and writes attribute data stored using Oracle.

Connecting to Oracle Autonomous Databases

Oracle Resources

Oracle Autonomous Database services

FME Community Resources

For information about connecting to databases, and troubleshooting connection errors, see Connecting to Oracle Autonomous Databases.
For information about reading and writing data from Oracle Autonomous Databases, see Reading and Writing Oracle Autonomous Databases.

Format Notes

3D Geometry Support

Reading and writing of 3D surfaces and solids is available only for Oracle 11g and above.

Oracle Instant Client

Instant Client can be used to run your OCI, OCCI, JDBC, and ODBC applications without installing a full Oracle Client. Instant Client supports SQL*Plus.

For more information on how it works with FME, see

See the FME Community for more information on how Instant Client works with FME.

Oracle Wallet

To use an Oracle Wallet with FME, leave the Username and Password parameters empty, and enter the name of the Oracle Wallet as the value of the Service Name or Easy Connect parameter.

Oracle Autonomous Spatial 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

Dependencies This format requires FME 2020.1 and above.

Reader Overview

The Oracle Autonomous Spatial Object reader reads attributes and geometry from Spatial tables in an Oracle Autonomous Data Warehouse.

Writer Overview

The Oracle Autonomous Spatial Object writer stores geometric and attribute data in an Oracle Autonomous Data Warehouse. Both uppercase and lowercase table names are supported.

The writer provides the following capabilities:

Transaction Support: Provides transaction support that eases the data loading process. Occasionally, a data load operation terminates prematurely due to data difficulties. The transaction support provides a mechanism for reloading corrected data without data loss or duplication.
Table Creation: Uses the information within the FME workspace to automatically create database tables as needed.
Table Dropping: Optionally, allows each table to be written to be dropped if recreating, or truncated if appending.
Index Creation: Sets up and populates all needed indexes and index tables as part of the loading process.
Bulk Loading: Uses a bulk loading technique to ensure speedy data load.