Write Spatial Data allows you to insert data into a writable named table as output of a job, or update or delete records in a named table using a primary key or a filter. You have the option to insert the columns that you would like to write to the table; it is not necessary to specify all columns. If a column is not specified, a null value will be inserted. The option to update or delete by filter allows you to use an MI SQL WHERE clause to specify criteria for the operation. The option to update or delete by primary key uses the primary key as the criteria; the primary key matches the input features with the features in the table that you want to update or delete.
The Write Spatial Data stage requires an upstream stage such as Read From File or Read Spatial Data. This stage also accepts geometries that are generated by stages in the Enterprise Routing Module, such as a LineString or Polygon.
Since Write Spatial Data uses an existing named table, it is necessary to create a writable named table where records will be inserted, updated, or deleted using the Spatial Manager before configuring the Write Spatial Data stage.