Writer Directives – Enterprise Geodatabase

The directives listed below are used when connecting to an Enterprise Geodatabase and writing to either feature classes or raster datasets.

The CONNECTION_FILE, SERVER, USERID, PASSWORD, and INSTANCE directives operate in the same manner as they do for the Geodatabase reader.

The other writer-specific directives are discussed in the following sections.

CONNECTION_FILE

Required/Optional: Optional

The pathname of a connection file for an Enterprise Geodatabase. Having a connection file means that it is not necessary to specify the other directives.

Workbench Parameter: Connection File

PERSISTENT_CONNECTION

A user may want to keep a connection to a database for reuse during a particular FME session. For example, when running a batch of 100 mapping files on the same database connection, it may be desirable to keep a connection open and save the processing time required to make and break a database connection.

A database connection will be determined to be the same when the database name, the username, the password, and the transaction interval are the same.

Values

YES | NO (default)

Mapping File Syntax

GEODATABASE_SDE_PERSISTENT_CONNECTION YES

Workbench Parameter

Persistent Connection

DATASET

Required/Optional: Required

The Enterprise Geodatabase dataset from which data is to be written.

Workbench Parameter: Destination Esri Geodatabase (ArcSDE) Dataset

SERVER

Required/Optional: Optional

The server machine where the dataset resides.

Workbench Parameter: Server

INSTANCE

Required/Optional: Optional

The Enterprise Geodatabase instance to connect to.

Workbench Parameter: Instance Name

USERID

Required/Optional: Optional

User ID of the Enterprise Geodatabase user.

If the userid and password are missing or not set, then the reader will try and connect with AUTHENTICATION_MODE set to OSA (Operating System Authentication).

Workbench Parameter: User ID

PASSWORD

Required/Optional: Optional

Password for the user account.

If the userid and password are missing or not set, then the reader will try and connect with AUTHENTICATION_MODE set to OSA (Operating System Authentication).

Workbench Parameter: Password

COMMIT_TRANSACTIONS_AFTER_WRITE

Required/Optional: Optional

Only valid when the versioning type is set to ‘transactions’. Specifies whether to commit transactions at the end of each write operation. If ‘yes’, transactions will be committed as soon as they are complete. If set to ‘no’, transactions will be committed at the start of the subsequent transaction. This option has no effect on translations taking place within an edit session.

Value: YES | NO

Default Value: NO

Workbench Parameter: Commit Transactions at end of Write

Example:

GEODATABASE_SDE_COMMIT_TRANSACTIONS_AFTER_WRITE YES