Esri Legacy ArcSDE Writer Parameters
WARNING: The Esri Legacy ArcSDE format will be deprecated in FME 2019+. Please consider upgrading to an Esri Geodatabase reader. For more information, see http://fme.ly/sde30.
Note: If you’re using ArcSDE with Oracle, you don’t have to change the default ArcSDE dataset name, since Oracle ignores this field.
Database Connection
- OS Authentication provides the necessary information to connect to the SDE server, by validating the username and password through the operating system. If you choose Parameters, you will have to fill in the username and password fields.
- Populate from Connection File… will fill in the Database Connection parameters with values extracted from an Esri Connection File. If selected, a file chooser dialog will open, and you can navigate to and select the desired connection file.
Once selected and confirmed, all the Database Connection parameters except the password will be populated from the data in the connection file. This option is particularly useful for ensuring that the Instance parameter is correct for direct connections.
Note that this option requires the installation of a compatible and licensed version of ArcGIS.
Enter the ArcSDE server name.
This field identifies the SDE database from which features are written. In SDE, the dataset is referred to as the Database. The Destination Dataset area of the Set Translation Parameters dialog box will default to sde, which is the dataset name you will use most often. This field is required no matter what the underlying RDBMS of the SDE. Some RDBMSes, such as Oracle, do not require a value, whereas others, such SQLServer, do. For databases that do not require the value, the field will be ignored.
Enter the username and password to access the service.
The instance to which FME is to connect. The usual value for systems with a single SDE instance is esri_sde. The instance can also be of the form port:<port-number>, which is usually port:5151 (you may have to confirm this with your System Administrator).
The SDE version to which FME connects. The version must already exist and the current user must have privileges set so that it can access the version. If the VERSION_NAME directive is not used, then FME attempts to connect to SDE.DEFAULT. If there is no SDE schema, FME then attempts to connect to dbo.DEFAULT. If the name is not prefixed by the owner of the version, then it is assumed that the owner is the current user. This setting is only applicable when dealing with versioned tables.
Table Parameters
Enter a keyword to specify the storage parameters to use for the layer.
If not specified, the keyword DEFAULTS will be used.
Tip: For more information, search parameter name-configuration string pairs in Esri ArcGIS Server help files.
Defines the dimension of the spatial data to be stored. This must be 2 or 3.
Are for the entire layer – features that have smaller coordinate values will cause the translation to be aborted (unless the writer has been directed to skip bad data).
The scale of the spatial column. This defines the number of units per user coordinate stored within the spatial column.
Specifies the size of the spatial index in the coordinate system of the layer (vector spatial column) (measured in the ground units of the features, not the SDE's “system" units).
If you're trying to improve the speed of writing features by dropping the spatial index, you can use SDE administrative commands via pre- and post-Python processing scripts. See Esri's ArcSDE documentation for more details.
For more information about spatial indexes, see "Layer (Vector Spatial Column) Properties" in Esri Legacy ArcSDE Reader/Writer, and Configuration Parameters.
Specifies the level 2 grid element size. This is not needed for the majority of spatial columns. If specified, must be at least 3 times the Grid 0 Size. If 0, no level 2 grid is built.
Specifies the level 3 grid element size. This level grid is rarely required. If specified, must be at least 3 times the Grid 1 Size. If 0, no level 3 grid is built.