You are here: Popular Formats > Esri Geodatabase Reader/Writer > Mapping File Directives > Writer Mapping File Directives > Writer Directives - Enterprise Geodatabase

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

Value: YES | NO

Default Value: NO

Workbench Parameter: Commit Transactions at end of Write

Example:

GEODATABASE_SDE_COMMIT_TRANSACTIONS_AFTER_WRITE YES