Oracle Non-Spatial Reader/Writer

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

Using FME with Oracle Formats

Oracle Format	Data Type
Oracle Non-Spatial Reader/Writer	attributes only
Oracle Spatial GeoRaster Reader/Writer	raster
Oracle Spatial Object Reader/Writer	object relational model (referred to as the object model)
Oracle Spatial Point Cloud Reader/Writer	point cloud
Oracle Spatial Relational Reader/Writer	relational model

Oracle Non-Spatial Product and System Requirements

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 and FME	Description
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.

Oracle and FME

Description

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 non-spatial tables from Oracle Non-spatial databases.

Writer Overview

The Oracle Non-Spatial writer module stores attribute data in an Oracle database. The writer supports the following features:

Feature	Description
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	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.