Oracle Autonomous Non-Spatial Reader/Writer

Licensing options for this format begin with FME Desktop Professional Edition.

Connecting to Oracle Autonomous Databases

For information about connecting to databases, and troubleshooting connection errors, see the FME Community article, Connecting to Oracle Autonomous Databases.

Format Notes

FME Version

This format requires FME 2020.1 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.

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.

Overview

The Oracle Autonomous Non-Spatial Reader/Writer enables FME to read and write attribute data stored using Oracle. This module communicates directly with Oracle for maximum throughput.

If you are reading or writing attributes only, use this Oracle Autonomous Non-Spatial reader/writer.

Reader Overview

This reader reads non-spatial tables from Oracle Autonomous Non-Spatial databases.

Writer Overview

The Oracle Autonomous Non-Spatial Writer module stores attribute data in an Oracle database, and 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.