The SpatialWare Reader/Writer format has the following capabilities:
- Programmatic Table Creation: You do not have to create tables before a data import operation. All table creation details are handled by FME.
- Programmatic Spatial Column and Attribute Verification: When loading data into an existing spatial database, FME verifies that the table definitions specified in the mapping file match the existing RDBMS definitions.
- Transaction Support: Transactions are fully supported enabling a partially complete load operation to be resumed later, without the loss of or duplication of data.
- Attribute Query Support: Any complex Structured Query Language (SQL) query can be specified to limit the data being exported.
- Spatial Query Support: FME exploits all additional spatial query capabilities of SpatialWare. Any complex SQL/Spatial query can be specified to limit the data being exported.
- Multi-Table Query Support: The queries may combine multiple RDBMS tables thereby exploiting the full SQL capabilities of the underlying RDBMS.
- Multiple SpatialWare Connections: FME can support multiple SpatialWare connections open to the same or different SpatialWare databases. This may be used for selective replication between different SpatialWare sites, for moving data from a preparation SpatialWare to a production SpatialWare, or for building result sets of features from multiple SpatialWare databases.
- Non-Spatial Table Support: Any table can be read or written to a SpatialWare database with FME whether or not it is spatially enabled. For example, if your SpatialWare uses SQL Server, you can use FME to read, write, or create regular SQL Server tables.
- Fully Automatic Import and Export: FME’s SpatialWare support provides fully automated import and export of data through Workbench or the Quick Translator. This is ideal for quick data imports or quick data exports.
Tip: The query support enables the data export operation to be highly focused, thereby reducing the amount of data that is exported.
The SpatialWare modules in FME are designed to work with other SpatialWare products. For example, a user with a simple GUI search engine can easily identify all features satisfying a complicated query, then use FME with the SpatialWare reader to process these features.