List of Supported Formats

Search the Online Transformer Gallery

Writer Feature Type Properties: Format Parameters

To access format parameters, open the Feature Type Properties dialog by clicking the properties button on a feature type in the workspace. These parameters are applicable only to the selected feature type.

Table Settings: General

ClosedWriter Mode
  • INSERT: Allows for only INSERT operations.
  • UPDATE and DELETE: These writer modes can be overwritten at the feature type levels.
  • INHERIT_FROM_WRITER: Takes the value from the writer level and does not override it at the feature type level.
ClosedDrop Table

If the table exists by this name, it should be dropped and recreated before any features are written to it.

ClosedTruncate Table

If the table exists by this name, it should be truncated before any features are written to it.

Table Creation Parameters

The parameters in this section take effect only when FME creates a table.

ClosedTable Type

The type of table to be created. The valid values for the type may include one or all of the values listed below:

  • MYISAM
  • InnoDB
  • MEMORY
  • BDB
  • CSV
  • ARCHIVE
  • MERGE
  • NDB
  • FEDERATED

Please refer to MySQL documentation for further information on these table types.

Table Settings: Spatial

ClosedCreate Spatial Index

Indicates whether or not a spatial index is to be created as part of the data writing. Valid choices are Yes or No.

ClosedSpatial Column

This parameter specifies the name of the column to be created that will hold the geometry when creating a new MySQL table. If this value is left blank, no geometry column will be created and an attribute only table will be written.

Note: This may invalidate other geometry-related parameters.

Table Settings: Advanced

ClosedOperations Per SQL Statement

If set to 1, insert data will be bound (packed efficiently, with statement reuse), and sent every feature.

Any value N > 1 will cause inserts to be batched without statement reuse and executed every N statements.

In general, N=1 will result in fewer bytes transmitted over the network, but more round-trips than a higher N. Experimentation may be required to determine which value will offer the best performance for a given scenario.

This parameter is ignored for UPDATE and DELETE modes, where statements are always executed singly.

Tags MYSQL MariaDB