Tyler Data & Insights Writer Feature Type Parameters
|
To access feature type parameters, click the gear icon 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.
on a feature type in the