Oracle Spatial GeoRaster Reader/Writer

FME can read and write GeoRaster and attribute data stored using Oracle Spatial. This module communicates directly with Oracle Spatial for maximum throughput.

Note  If you are reading or writing attributes only, use the FME Oracle Non-Spatial Reader/Writer.

This section assumes familiarity with Oracle Spatial, its GeoRaster support, and its indexing mechanisms.

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

Oracle Spatial GeoRaster Product and System Requirements

Dependencies  Raster data is supported only for Oracle 10g and above.

Format

FME Platform

Operating System

Reader/Writer

FME Form

FME Flow

FME Flow Hosted

Windows 64-bit

Linux

Mac

Reader

Yes

Yes

Yes

Yes

Yes

Yes

Writer

Yes

Yes

Yes

Yes

Yes

Yes

Format Notes

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.

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.

Reader Overview

This reader reads GeoRaster tables from Oracle Spatial databases.

Writer Overview

The Oracle Spatial GeoRaster writer module stores raster and attribute data in an Oracle Spatial database. Only uppercase table names are supported.

FME Raster Features

FME raster features represent raster data and use several concepts that are unlike those used in the handling of vector data.

For comprehensive information about how FME processes raster data, see Rasters.

Oracle supports rasters with an arbitrary number of bands, provided all bands are the same data type. Any number of bands may optionally have a palette.

Oracle supports reading and writing 1-, 2-, and 4-bit rasters. Note that the smallest data type supported by FME is 1 byte (8 bits). Thus, on reading, 1-, 2-, and 4-bit rasters are automatically converted to 8 bits. On writing, an option is provided to reduce the size of 8-bit rasters to 1, 2, or 4 bits.