Esri Geodatabase (ArcSDE Geodb) Writer Parameters

This parameter identifies the pathname of a connection file to be used to connect to an Enterprise Geodatabase.

A connection file provides the necessary information to connect to the SDE server, such as the server name or the username.

The connection file must be a *.sde file and have the proper format for a connection file as defined by Esri. Connection files can be created in ArcCatalog.

Check this option to override the User and Password from the connection file. Overriding credentials is required for Connection Files that do not have saved credentials.

Note: This parameter is ignored if the Connection File is using OS Authentication.

Enter the username and password to access the database, user account, or wherever authentication is required.

Select this parameter to override the version provided in the connection file.

The name of the SDE version to which the FME connects. This field is only applicable when dealing with versioned tables or layers.

Indicates which transaction mechanism the Geodatabase writer should use. Within ArcGIS, there are currently two transaction mechanisms: edit sessions and (regular) transactions. An edit session corresponds to a long transaction. During an edit session, edits made by other users do not become visible until the edit session is ended. If a translation does not complete successfully and the Geodatabase writer is using an edit session, then all the edits will be discarded.

Values:

• Versioned Edit Session: Starts an edit session and then ends it when the translation is finished. This value should be used when writing to a versioned table in an Enterprise Geodatabase.

Note: Versioned Edit Sessions should not be used on non-versioned tables as Edit Session features such as discarding edits after failure will not work.

• Non-versioned Edit Session: Starts an edit session on a non-versioned table and then ends it when the translation is finished. This can be used on non-versioned tables that have custom behavior.

• Transactions: Starts the (regular) transaction mechanism. This can be used only when writing to non-versioned tables that do not have custom behavior.
• None: No transaction mechanism is used. This can be used only when writing to non-versioned tables that do not have custom behavior. None differs from Transactions with a transaction interval of zero in that if the write fails, all successful features are committed for None, but are discarded for Transactions.

If specified, the writer will import the complete schema from the Esri XML workspace document specified into the destination Geodatabase. The import occurs after opening the Geodatabase for writing, but before any tables are created or features are written. Any error that occurs during import will cause the translation to fail.

Note: The XML Workspace document may contain both schema and data; however, FME imports only the schema.

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.

The coordinates of the X false origins for all feature classes and all feature datasets. This is used as an offset so that coordinate data is stored as positive integers, which allows a range from 0 to 2147483647 (so if the X origin is set below 0, then the maximum value will also drop, and vice versa). By default, the values for the false origins are set to 0. This is only used when creating new feature classes.

The coordinates of the Y false origins for all feature classes and all feature datasets. This is used as an offset so that coordinate data is stored as positive integers, which allows a range from 0 to 2147483647 (so if the Y origin is set below 0, then the maximum value will also drop, and vice versa). By default, the values for the false origins are set to 0. This is only used when creating new feature classes.

This parameter is only used when creating new feature classes. It is not used by the File-based Geodatabase writer, as default values are used for the domain and resolution.

A scaling conversion factor from world units to integer system units for all feature classes and all feature datasets. This is used to specify the level of precision to keep when storing XY coordinates, since all coordinates are stored as integers.

The x,y scale is the inverse of the spatial reference's XY Resolution. The resolution is defined as the minimum unit in map units that separate unique x values and unique y values for feature coordinates.

Examples

• If the XY scale is defined to be 100, which corresponds to the XY resolution of .01 units, then an x value of 3.03 is considered different than 3.04, but the same as 3.033.
• If you have the coordinate (5.354, 566.35) and you set the XY scale to be 100, then the coordinate stored will be (5.35, 566.35).

For more information, see Esri's documentation on the properties of a Spatial Reference.

The default value is 100 when writing to an Enterprise Geodatabase and 0 when writing to a Personal Geodatabase.

Determines whether or not the dataset contains z coordinates. Valid values are Yes, No, or Auto Detect. The default is Auto Detect.

Because Geodatabase does not allow mixed 2D and 3D features in the same feature class, it is best to select YES if you have mixed dimensions. The 2D features will be forced to 3D.

When set to Auto Detect, the writer determines the dimension of the feature class by checking the dimension of the first feature headed for that feature class.

The coordinates of the Z false origins for all feature classes and all feature datasets. This is used as an offset so that coordinate data is stored as positive integers, which allows a range from 0 to 2147483647 (so if the Z origin is set below 0, then the maximum value will also drop, and vice versa). By default, the values for the false origins are set to 0. This is only used when creating new feature classes.

A scaling conversion factor from world units to integer system units for all feature classes and all feature datasets. This is used to specify the level of precision to keep when storing Z coordinates, since all coordinates are stored as integers.

Depending on the scale, it changes the precision of the coordinates stored. For example, if you have the coordinate (5.354, 566.35) and you set the Z_SCALE to be 100, then the coordinate stored will be (5.35, 566.35). The default value is 100. This is only used when creating new feature classes.

This sets the global grid 1 size for the whole translation. For the Enterprise Geodatabase writer, the default is 1000. This directive is only used when creating new feature classes.