SQLite Spatial (FDO) Writer Parameters

Database Connections

Database formats include a Database Connection parameter that defines and stores authentication information. For general information about sharing database connections, please see Using Database Connections.

Note that Database Connection parameters may differ slightly, depending on context and/or database format.
ClosedConnection

Select an existing connection, or Add Database Connection to define a new connection.

The new connection can be made visible only to the current user, or can be shared among multiple users.

ClosedOverwrite Existing Database
  • If this option is unchecked (default) and a database already exists, then tables and features are written to the existing database.
  • If this option is checked, any existing database is deleted before writing begins.

If no database exists when writing begins, a new database is created.

Note: After a database is deleted, it cannot be recovered – all data is lost.

ClosedTemplate File

If a template file is specified, the destination file is replaced with a copy of the template before writing begins.

Table Defaults

ClosedOverwrite Table
  • No: The table will be created if it does not exist.
  • Yes: The table will be dropped if it exists, then created.
  • Truncate: If the table does not exist, it will be created. If the table does exist, then all its rows will be deleted.
ClosedWriter Mode

The default operation mode of the feature type in terms of the types of statements sent to the database.

Note: The primary key is the partition key, or the partition key and the sort key (if it exists).

  • Insert reates new items in the destination table. If an item with the same primary key already exists, the new item is not added to the table.
  • Update modifies an existing item in the destination table. If the attributes to be updated exist on the item with the specified primary key, the attributes are set to the new value. Otherwise, the attributes and their values are added to the item.
  • Delete deletes existing items in the destination table that have their primary key specified.
ClosedDefault auto-generated identity column

Specifies the name of the default index attribute that is added to the feature type if no user attribute is specified with an IDENTITY index type. This parameter defaults to PRIMARYINDEX.

ClosedGeometry Column Name(s)

A comma-separated list of the geometry column names for writing.

Location columns will be created for each of the supplied geometry column names when creating a new table or matched against the existing geometry columns when writing to an existing table.

Note: If the column names listed here conflict with any user attributes, the columns listed here take precedence.

This parameter has no effect when the Writer Mode is Delete.