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