Esri Knowledge Writer Parameters

About 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 differ slightly, depending on context and/or database format.

Connection

From the Connection parameter in a database format, you can do one of the following:

  • Select an existing, previously defined connection. See the section Reusing a Database Connection in Using Database Connections
  • Select Add Database Connection to define a new connection. See database-specific parameters below, as well as the section Adding a Database Connection in a Workspace in Using Database Connections The new connection can be made visible only to the current user, or can be shared among multiple users.

Database Connection

Select an existing Esri Knowledge Graph connection, or Add Database Connection...

Add Esri Knowledge Server Connection

To define a new connection from the Connection parameter in an Esri Knowledge format, see the topic Esri Knowledge: Add Connection

Table Parameters

ArcGIS geometry has to satisfy certain constraints to be considered valid. For example, polygons must have more than 2 vertices. This parameter allows you to specify whether geometry that breaks those constraints will be simplified to ensure only valid geometry is written.

Note that simplifying geometries can be resource-intensive.

For details on the conditions for invalid geometry and how it is simplified, please refer to ArcGIS documentation: Simplifying a Geometry and Calling the Simplify Method.

Advanced

The number of features written in each Edit Operation of an Edit Session. Data is sent to the server when each edit operation ends.

Default: 1000

This parameter tells the writer whether it should ignore features that would usually cause the translation to fail. This includes features that are topologically incorrect, are not supported by the writer, or conflict with the definition of the table to which it is to be inserted (that is, they are outside of the geometry envelope specified by the feature class). Additionally, the writer will also ignore polygons, donuts, or aggregates of polygons/donuts that cannot be reoriented.

The default setting is No, which means that failed features are not ignored and will cause the translation to fail when encountered.

This parameter sets the number of features to ignore before causing a translation to fail due to a problematic feature. (However, the translation may still fail for other reasons.)

Values: To ignore all failed features: -1; otherwise 0 or a positive integer.

This parameter allows you to store the failed features to an FFS file for later viewing.

This parameter allows you to specify an FME Feature Store (FFS) file to store any failed features.

This file will be created automatically, but will only be created if there is a failed feature.

Note: If the writer encounters a failed feature and writes to this file, and if a file with the same name already exists, the existing file will be overwritten.

This parameter is required when Dump Failed Features to File is set to Yes.

Values: path and filename

If either the path or the filename contains a space, the value must be enclosed in double quotation marks. The filename must end in the extension .ffs.

When Transaction Type is set to None, this parameter determines whether to copy the GlobalIDs from the source table to the destination table, or generate new GlobalIDs for the destination table. The feature operation must be set to Insert.

  • Yes – Preserves the existing source feature type GlobalID attributes.
  • No – Auto-generated GlobalIDs are assigned to features that do not have one.

Note: Ensure that GlobalIDs are not duplicated. If a GlobalID is already in use, FME will write the feature, but the Knowledge Graph will silently reject it.

Enables fast deletes when feature operation is set to Delete.

  • Yes – Combines WHERE clause predicates up to a limit of 32K characters at a time. If the limit is exceeded, a new query to the table is created.
  • No – Slower deletes by creating a query to the table for each feature.

Specifies whether to create a connection to an Esri Knowledge database that persists and can be shared by other readers, writers, and transformers.

When set to Yes, the connection will remain open until FME shuts down, even if this writer is finished using it. Otherwise, the connection will be closed when the writer is shut down (unless another reader, writer, or transformer is still using the connection).

Creating a new connection is a resource-expensive operation. Depending on how FME is being used (for example, if there are multiple instances of the reader/writer being used), performance may improve by setting this parameter to Yes.