Esri Legacy ArcSDE Raster Map Writer Parameters

• 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 database, user account, or wherever authentication is required.

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).

This field sets the default value for the configuration parameter SDE_CONFIG_KEYWORD. It specifies the storage parameters for the raster column. Note that in releases before ArcGIS 9.3, the configuration keyword specified must be present in the $SDEHOME/etc/dbtune.sde file.

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.

Instructs FME to operate in a specific mode:

• Insert mode inserts the raster into the table, overwriting any data that already pre-existed.
• Update mode specifies that the writer is to mosaic the raster data to the pre-existing data, thereby updating the single row in the table. Raster catalogs may be inserted to, updated, and deleted from in a similar manner as vector data.

To perform a successful update, several conditions must be met by all the raster data that is to be mosaicked: the coordinate systems must be the same, the pixel depth must be the same, and the raster data itself must be either palette colored or continuous (they cannot be mixed).

There is also a requirement for cell size and alignment to be the same, but the SDE writer will correct for these automatically, so they need not be altered. There is also no need to alter the writer mode when mosaicking, since the writer will automatically detect and correct this based on whether or not the data is pre-existing, in order not to overwrite it.

The only way to overwrite existing raster data in a raster map is to set either the Drop Table or the Truncate Table feature type parameters to Yes.

If this parameter is not specified, then Insert mode is used.

Instructs the SDE writer module to use transactions when loading data into the SDE.

The writer does not write any features to the SDE until the feature is reached that belongs to Last Successful Transaction.

Specifying a value of 0 causes the SDE writer to use transactions and to write every feature to the SDE. Usually, the value specified is zero – a non-zero value is only specified when a data load operation is being rerun.

If this parameter is not specified, then transactions are not used during the data load operation.

The number of features to be placed in each transaction before a transaction is committed to the database.

When set to VARIABLE, the SDE writer checks each feature for the fme_db_transaction attribute, for which there are 4 valid values:

• COMMIT_BEFORE – The current transaction is committed before writing the feature.
• COMMIT_AFTER – The current transaction is committed immediately after writing the feature.
• ROLLBACK_AFTER – The current transaction is rolled back immediately after writing the feature.
• IGNORE – The feature is written and no transaction handling occurs.

When the attribute is not found on the feature, then a value of IGNORE is assumed.

If this parameter is not specified, then a value of 100 is used as the transaction interval.

This statement instructs the FME where to find the pipeline file(s) to be used. A pipeline is used when a failure occurs in writing a feature. When this parameter is specified and there was an error in writing a feature, the writer first attempts to open a pipeline specific to the current table. The writer looks for a file called <tableName>_pipeline.fmi in the specified folder. If the file is not found, then the writer looks for a default pipeline called default_pipeline.fmi in the same folder. If neither of these files are found, then the translation is stopped.

If a pipeline file is found, then an FME pipeline is created. The pipeline can do almost anything a regular FME pipeline can do. However, only the first feature from the pipeline is retrieved. If the pipeline does not return any feature, then the writer does not insert into SDE the row that corresponds to the feature. At the present time, the feature is recorded as written in the statistics portion of the FME log, whether or not it was actually inserted into SDE.

If this parameter is used with the Skip Bad Data parameter set to Yes or ROLLBACK_THEN_CONTINUE, and a feature is returned from the pipeline, then if the returned feature causes an error while being written to the SDE, it will not cause the translation to stop. Rather a warning message, explaining why the feature couldn’t be written, will be logged and the translation will continue. If ROLLBACK_THEN_CONTINUE was specified, the current transaction will be rolled back instead of committed when it comes time to commit the transaction.

If this parameter is not specified, then no pipeline will be created by the writer for features rejected by SDE. A pipeline is only created if this parameter is specified and a failure occurs in writing a feature

Value: The absolute or relative path of a folder containing pipeline files. If the path contains spaces, the path should be double-quoted.

Instructs the writer to continue a translation even when an error occurs while attempting to load the data (the error may or may not be related to the data). A warning message explaining what went wrong will be output for each feature that could not be written to SDE.

This parameter is useful when trying to load bad data.

When set to ROLLBACK_THEN_CONTINUE, if a feature fails to be written, then the current transaction will be rolled back rather than committed when it is time to commit the transaction. This means that none of the features in the rolled back transaction will be written to SDE. The translation will continue regardless of the error encountered. Transactions must be used when this value is specified. When used in conjunction with the Rejected Pipeline Folder parameter, if a feature returned from a pipeline fails to be written, then the current transaction will be rolled back instead of committed.

If set to Yes and transactions are being used, all transactions will be committed; however, failed features will not be written to SDE.

Specifies the maximum number of streams that can be open simultaneously.

Each stream writes to a particular table and so this parameter determines the maximum number of tables that can be open and written to simultaneously.

If this parameter is not specified, or is given the value 0, then the SDE writer will set the maximum number of streams open simultaneously to 4 less than the number specified by MAXSTREAMS in giomgr.defs.

Specifies a definition to use for all integer column types when creating new tables.

Any of the allowed FME attribute types for the ArcSDE Writer can be used as values. Additionally, you can also use number(<width>) or number(<width>, <decimal>).

By default, this parameter is not set, and so integer columns are stored using the C language long integer data type.

When specified, the buffered writing of the SDE is used; this dramatically decreases the load time of data into SDE.