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