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.
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
|
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 |
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.
The Oracle Spatial Relational writer provides the following capabilities:
- Table Creation: The Oracle Spatial Relational writer uses the information within the FME mapping file to automatically create database tables as needed. When the relational model of storing geometry is used, the writer will create and populate all needed supporting tables. In such a case, the <layername>, <layername>_SDOGEOM, <layername>_SDOLAYER, <layername>_SDOINDEX, and <layername>_SDODIM tables will all be created.
- Index Creation: The Oracle Spatial Relational writer will set up and populate all needed indexes and index tables as part of the loading process. For the relational model, indexes on SDO_GID columns in the <layername> and <layername>_SDOGEOM tables are created, and a compound index on the SDO_GID and SDO_CODE columns in the <layername>_SDOINDEX is created. The <layername>_SDOINDEX table will also be populated.
- Bulk Loading: The Oracle Spatial Relational writer uses a bulk loading technique to ensure speedy data load.