Tyler Data & Insights Writer Feature Type Parameters

To access feature type parameters, click the gear icon on a feature type in the workspace. This opens the Feature Type Parameter Editor.

Tip  To always display the editor in FME Workbench, you can select View > Windows > Parameter Editor.

General

All feature types share similar General parameters, which may include Feature Type Name, Reader or Writer information, and Geometry.

In most Writer Feature Type parameter dialogs, you can also control Dynamic Schema Definitions. Some database formats accept Table or Index Qualifier prefixes on the output table feature type.

Dataset

Feature Operation

This parameter specifies the writing behavior. It corresponds to the Action Type in the Socrata Publishing API.

  • Update – Insert or update rows, based on the dataset’s row identifier, and the row identifier that may be specified on features being written.
  • Delete – Delete rows by ID. The dataset must have a row identifier.
  • Replace – Replace all existing rows with the data written in this translation.

Dataset Handling

  • Use Existing (default) – In order to avoid accidental dataset creation, this setting is the default.
  • Create If Needed – Create a new Data & Insights dataset if the writer’s dataset URL does not have a dataset ID.
  • Truncate Existing – Applies only when Feature Operation is Replace. This preserves all server-side column metadata and transformations, and ensures that the data replacement does not change the resulting schema.

When creating datasets, Data & Insights will assign the new dataset a four-four ID. After the writer successfully creates a dataset, it logs the new dataset’s URL.

To write to the new dataset, update the writer’s dataset URL parameter. Otherwise, subsequent translations may create a duplicate dataset. Dataset names are not unique.

Dataset Permission

This parameter specifies the access permission for the dataset.

  • Public – Anyone can read the dataset.
  • Private (default) – The dataset can only be read by those who are granted access.